Reference no: EM131135956

Part 1:

1. You're working in a table that has three columns and five rows. Since the first row will be a header row, you want it to span all three columns. What formatting feature should you use?
A. Merge cells
B. Autofit cells
C. Combine cells
D. Connect cells

2. Suppose you want to view a document that has several headings. What view would you use?
A. Outline
B. Draft
C. Web
D. Read

3. _______ allows you to specify how a photo is positioned in the text of your document.
A. Wrap Text
B. Align Text
C. Wrap Photo
D. Align Photo

4. To insert text from a separate file into your Word document,
A. click TextBox in the Insert tab.
B. click Text in the Object group, and then click Text from File.
C. click the Object arrow in the Text group, and then click Text from File.
D. You have to open the file, copy the text, and then paste it into the document.

5. Word allows the user to view a document in different ways. What view would you choose to view a document like a book?
A. View Mode
B. Print Layout
C. Read Mode
D. Web Layout

6. If you want to insert a column into an existing table, what would you do?
A. Click Column in the Insert tab.
B. Click one of the insert buttons in the Data group of the Layout tab.
C. Click one of the insert buttons in the Rows & Columns group of the Layout tab.
D. Click in the Table Style Options group of the Design tab.

7. Elisa and Josh need to access General Help. Elisa will press the F1 key. Josh will click on ? in the upperright corner of the Word document. Who will access General Help?
A. Neither Elisa nor Josh
B. Both Elisa and Josh
C. Only Elisa
D. Only Josh

8. If you press the Tab key when you're in in the last cell of a table,
A. a new table is added.
B. the cell is divided.
C. a new row is added.
D. a new column is added.

9. _______ allows you to add formatting such as shapes and colors to text.
A. WordArt
B. WordDraw
C. WordShapes
D. WordDesign

10. Suppose you want to delete an existing file from within Word. What would you do?
A. Click on the File button, choose Recent, open the file, and select Delete.
B. Open the file in Word, click on Save As, and save the file to the Recycle Bin.
C. Click on the File button, choose Save As, find the file, right click on the file, and select Delete.
D. Click on Save As and give the file a new file name.

11. Which of the following menu commands would you select to make a copy of an open file and rename it?
A. Versions
B. Replace
C. SaveAs
D. Copy

12. Formulas within table cells always begin with
A. parentheses.
B. a symbol that looks like a backwards F.
C. theAutoSum symbol.
D. an equals sign.

13. Users with a Microsoft account have access to an online storage and sharing system known as
A. WebApps.
B. Producer.
C. OneDrive.
D. OfficeAnywhere.

14. To set up Automatic Backup on your computer, what option would you choose from the Word Options screen?
A. Backup
B. General
C. Advanced
D. Customize Ribbon

15. The _______ is the area on your screen where you can access the tab and menu options for Word.
A. Backstage view
B. Status bar
C. Ribbon
D. Navigation bar

16. What is the default file extension for a file saved in Word 365?
A. .docext
B. .doc365
C. .doc
D. .docx

17. To reveal paragraph markers, such as spaces, hard returns, and tabs in your document, you should
A. click the General tab.
B. click the Show/Hide button.
C. right-click anywhere in the task bar and click the ¶ symbol.
D. click the Page Layout tab.

18. To remove any hidden data from your document before sharing it, what should you do?
A. Click the View tab and then click Protect Document.
B. Click the File tab, click Check for Issues, and then click Protect Document.
C. Click the File tab, click Check for Issues, and then click Inspect Document.
D. Click the File tab, click Check for Issues, and then click Check Accessibility.

19. What screen enables you to customize how files will be saved on your computer?
A. Auto Options
B. Word Options
C. Save Options
D. Save As Options

20. What keyboard shortcut can you use when you want to save a document?
A. Ctrl+SV
B. Ctrl+S
C. Alt+S
D. Shift+SV

Part 2:

1. David has a small business and is working on an Excel worksheet to help manage his inventory. David realizes cell E14 has the wrong output. To check the problem, David should first select cell E14 and look at the _______ to check the formula.
A. Name box
B. range
C. Formula bar
D. Function tab

2. Which of the following ranges of cells is correctly named?
A. A/E5
B. A5:E5
C. A5:G1
D. A5+G1

3. A feature in Excel that allows you to graphically display in a single cell the trend across a range of cells is called a
A. spark point.
B. pivot line.
C. sparkline.
D. pivot point.

4. You've been asked to find the largest number in a range of numbers. Which of the following could you use to find the largest number in range E11:E23?
A. =SUM(E11:E23)
B. =AVERAGE(E11:E23)
C. =MAX(E11:E23)
D. =MIN(E11:E23)

5. Joshua needs to join the text in two cells together. Which of the following would perform this function?
A. ="Good"&&"Morning"
B. ="Good"+"Morning"
C. =(Good)&(Morning)
D. =Good "&" Morning

6. Which of the following is a group of cells chosen to perform an action?
A. Group
B. Data series
C. Command
D. Range

7. To combine a range of cells into one large cell, you should highlight the cells and choose
A. Merge Cells.
B. Wrap Text.
C. Increase Indent.
D. Decrease Indent.

8. Arthur needs to copy the formula in cell C13 to cell D13. He needs cell D13 to have the same formula but referenced with a new location. Which type of cell reference should he use?
A. Relative cell reference
B. Mixed cell reference
C. Absolute cell reference
D. Duplicate cell reference

9. You've been asked to find the average of a range of numbers. Which of the following could you use to find the average of cells A1:A10?
A. =AVERAGE(A1:A10)
B. =MAX(A1:A10)
C. =MIN(A1:A10)
D. =SUM(A1:A10)

10. After inputting a formula or a piece of data into a cell, what happens to the cell pointer when you press Enter?
A. It moves up one cell.
B. It moves down one cell.
C. It moves to the next adjacent cell to the right.
D. It moves to the last cell in the column.

11. The order of precedence is very important when building formulas in Excel. Which of the following formulas will produce 778 as the result?
A. =(25*(27/9) + 5 + 309)*2
B. =25*((27/9 + 5) + 309*2)
C. =25*(27/9 + 5) + 309*2
D. =25*27/9 + 5 + 309*2

12. What category of predefined formulas in Excel contains the Boolean functions?
A. Recently Used
B. Math and Trig
C. AutoSum
D. Logical

13. You plan to use the Fill Down feature on a formula and you need to keep a cell reference the same. Which one of the following formats will allow you to keep the same cell reference?
A. $E19
B. E$19
C. $E$19
D. E19

14. What are the two types of formulas in Excel?
A. Trig and Mathematical
B. Complex and Simple
C. Logical and Boolean
D. General and Currency

15. Andrea needs to format the legend on her chart. She clicks on the chart to select it. Which of the following options appears only when a chart is selected?
A. Chart Tools
B. Insert
C. Page Layout
D. Review

16. Keeping in mind the role the order of precedence plays in equations, what would Excel display as the result of the following equation? =(24+75)/(6*3)
A. 5.5
B. 109.5
C. 28.2
D. 198

17. The order of precedence determines
A. how values are divided and multiplied.
B. the order in which worksheets are printed.
C. the order in which calculations are performed.
D. the properties of the cell reference.

18. If you sort a portion of an Excel sheet and you get an error message such as #DIV/0, what is a likely cause of the error message?
A. One or more cells contain absolute cell references.
B. The cell ranges are incorrect.
C. One or more cells contain relative cell references.
D. You're attempting to sort too many cells.

19. Which one of following is an example of a formatted number using the Currency option?
A. 7778.92%
B. $7,778.92
C. 7,7789.2
D. 777892

20. Which of the following is an example of a complex formula?
A. =A1<= A14
B. Income - Expenses
C. =150*.05
D. SUM(A1:A1

Part 3:

1. You're creating a table for one of your slides, and need to make some modifications to your table structure. Which of the following options can you perform by right-clicking inside the table?
A. Invoke Excel spreadsheet
B. Merge cells
C. Create SmartArt
D. Create a comment

2. Suppose you're creating a slide presentation. During the presentation, you'll need to go to a specific address on the Web. You should insert a/an
A. Word file.
B. table.
C. graphic.
D. hyperlink.

3. Abby wants to add a hyperlink to her presentation. Which of the following is the correct form for a link?
A. www.pennfoster.edu
B. wwwpennfosteredu
C. www.pfedu
D. www.penn.foster.edu

4. Alan wants to find an image of a car he can use in a presentation. What button should he click in the Images group to run a search?
A. WordArt
B. Online Images
C. Internet Pictures
D. Clip Art

6. Which of the following is an example of a transition effect available in PowerPoint?
A. Erase
B. Block Out
C. Uncover
D. Rain

7. To create an identical version of a slide, you would click
A. Clone.
B. Create Slide.
C. Copy.
D. Duplicate Slide.

8. To insert a new slide, which tab option should you select?
A. Slides
B. Design
C. Home
D. Insert

9. Which view should you use if you want to look only at the text of the slides?
A. Reading View
B. Outline View
C. Normal View
D. Slide Sorter

10. Mark needs to edit many different parts of a presentation. Which of the following views does he need to be in to effectively edit the presentation?
A. Slide Sorter
B. Print Preview
C. Normal
D. Slide Show

11. Jane is creating a slide that will have a large heading and a number of bullet points below it. What slide format should she use?
A. Title Only
B. Comparison
C. Title and Content
D. Two Content

12. Which button would you use to insert a downloaded video clip on your computer into a slide?
A. Video on My PC
B. Online Video
C. Clip Art Video
D. Media

13. A(n) ________ allows you to quickly apply a color scheme to a presentation.
A. spell check
B. hyperlink
C. theme
D. animation

14. Julie is trying to decide whether or not to add a color scheme to her presentation, and she asks you for advice. You should advise her that color schemes
A. help to keep a presentation consistent.
B. often result in an uninteresting presentation.
C. make the design process overly complicated and tedious.
D. are mainly useful in the creation of colorful charts.

15. Cindy wants to merge two cells together. Which of the following best describes the process of merging two cells?
A. Highlight the two cells, right-click, and choose Merge Cells.
B. Highlight the two cells and click the Home tab. In the Drawing group, click the Merge Cells button.
C. Highlight the two cells and click the Design tab. In the Setup group, click the Merge Cells button.
D. Highlight the two cells and click the Home tab. In the Paragraph group, click the Merge Cells button.

16. Which of following allows you to preview a presentation?
A. Normal view
B. Slide Sorter
C. Preview tab
D. Slide Show

17. Sue needs to add a header and a footer to a presentation. Which process should she use to do this?
A. Click the View tab, and in the Show/Hide group, choose Header and Footer.
B. Click the Home tab, and in the Window group, choose Header and Footer.
C. Click the Home tab, and in the Insert group, choose Header and Footer.
D. Click the Insert tab, and in the Text group, choose Header and Footer.

18. Tracy inserted one of her favorite photos into a slide presentation. However, the picture is small and needs to be longer and wider. To make the picture larger, which of the following should she do?
A. Select the object and use the size handles.
B. Double-click on the object and click Size.
C. Click the Insert tab and in the Size group, click the Size drop-down arrow, and choose Size Object.
D. Right-click on the object and click Size.

19. A _______ is a set of commands.
A. handout
B. website
C. tab
D. slide

20. When planning a presentation, there are several factors you need to consider. Which of the following is one factor you should consider when initially planning your presentation?
A. Type of font
B. Location of audience
C. Title placeholder
D. Saving your work.