Penn foster college
Microsoft Word 2016
1. Font size, font style, and ______are all aspects of character formatting. A. typeface B. indentation C. line spacing. D. alignment
2. When you select Insert and click on a shape the mouse pointer turns into a/an A. double-headed arrow. B. crosshairs. C. I-beam. D. hand.
3. Pressing and holding the ______key while dragging a corner handle of an image proportionally resizes it. A. Ctrl B. Tab C. Alt D. Shift
4. Add pictures using the ______tab. A. Layout B. Design C. Home D. Insert
5. How many times do you need to click the Format Painter button to apply copied formats to multiple paragraphs one right after the other? A. Three times B. Once C. Twice D. Format Painter doesn't copy formats
6. On the Insert tab, select Table > ______to create a table from selected text. A. Draw Table B. Insert Table. C. Convert Text to Table D. Quick Tables
7. On the Picture Tools Layout tab, you can preview results of the numerous styles, borders, effects, and layouts by ______commands. A. single-clicking B. pointing to C. double-clicking D. right-clicking
9. When you are in ______cell in a row of a table, pressing Tab moves the insertion point to the first cell in the next row. A. the first B. the center C. any D. the last
10. Of the following pieces of information in a document, for which would you most likely insert a mail merge field? A. Closing message of a letter B. First name of the person to whom the letter will be sent C. The body of the letter D. Personalized message for the person receiving the letter
11. Click ______to add a new column to a table. A. Banded Columns B. Insert Control C. More D. Draw Table
12. ______automatically moves the insertion point to the next line while you're typing. A. Word placement B. Smart Lookup C. AutoCorrect D. Word wrap
13. When you see a/an ______pointer, this means you can drag the row or column border to change height or width. A. crosshair B. I-beam C. hand D. double-headed
14. When you right-click a word with a red squiggly line under it, which of the following displays? A. Smart Lookup dialog box B. Replace dialog box C. Spelling menu D. Grammar menu
15. Options to open, save, and print a document are found on which of the following tabs? A. Home B. Design C. File D. Layout 16. Which one of the following buttons is used for paragraph alignment?
17. On the Header & Footer Tools Design tab, you can conveniently add a header, a footer, page numbers, and A. columns. B. table. C. timestamp. D. style.
18. For what type of document would you use the landscape page orientation? A. School essay B. Three-column brochure C. Business letter D. Legal contract
19. You've formatted the first paragraph of a document. What button can you use to apply the formatting from the first paragraph to the next paragraph in the document? A. Paste B. Format Painter C. Copy D. Cut
20. What size paper should you use for a legal document? A. 8½″ × 11" B. 8½″ × 14″ C. 7¼″ × 10½″ D. 3″ × 5″
Microsoft Excel 2016
1. Applying what formatting option to your Excel workbook will make it easier to read when printed out?A. Font color
B. Font style
C. Alignment
D. Gridlines Print
2. Which key removes all data from an active cell with one click?
A. Tab
B. Delete
C. F2
D. Esc
3. If you want to place the insertion point in a cell to edit a specific part of its contents, you can
A. click the status bar.
B. press F2.
C. press F4.
D. click the cell.
4. The most efficient way to perform data entry is to keep your hands on the keyboard and press ______to move to the next cell in the row or press ______to move to the next cell in the column.
A. Enter; Tab
B. Tab; Home
C. Home; Tab
D. Tab; Enter
5. What would be a situation in which you could use an Excel chart to present your data?
A. Required ingredients for three different kinds of cake.
B. Listing team members on a soccer team with their address information.
C. What percentage of customer 101 buys product A, and what percentage of the same customer buys product B?
D. Compiling survey questions and answers from business clients.
6. Which of these charts has only one data series?
A. Area
B. Line
C. Bar
D. Pie
7. Which command is used to combine two or more cells together into one cell?
A. Wrap Text
B. Orientation
C. Merge & Center
D. Conditional Formatting
8. Press the ______key to move to the next cell in a row.
A. Tab
B. Home
C. Enter
D. Page Down
9. If you have long column labels with columns so wide that they affect the readability of a worksheet, you should first
A. leave the column labels as is.
B. consider how you could shorten the column labels.
C. format the column labels.
D. decrease the column widths.
10. When considering changing the content of a cell which button should you press to leave the cell as it originally was?
A. Backspace
B. Delete
C. Cancel
D. Enter
11. Create a cell reference in a formula by typing in the cell name or
A. clicking the row where the cell is located.
B. clicking the column where the cell is located.
C. right-clicking the cell.
D. clicking the cell.
12. Which function should be used to display a value based on a comparison?
A. COUNT
B. IF
C. AVERAGE
D. MIN
13. If you enter 234.567 into a cell that is formatted to display 1 decimal place, what is the value stored in the cell?
A. 234.6
B. 234.567
C. 234.5
D. 234.0
14. You can tell a cell is the active cell when it has a
A. colored border and it is where the data you type will appear.
B. colored border and data you type will appear next to it.
C. bold border and it is where the data you type will appear.
D. bold border and data you type will appear next to it.
15. You are able to drag a cell to a new location by pointing to the cell border until the pointer displays a ______arrow, and then dragging the cell to the new location.
A. four-headed
B. double-headed
C. three-headed
D. single
16. What is entered into a cell that is typically numeric and can be used for calculations?
A. Function
B. Label
C. Tab
D. Value
17. From the Start screen, you can
A. access recently opened Excel workbooks.
B. access recently saved documents.
C. create a document from a template.
D. create new blank documents.
18. Which feature of Excel changes obvious misspellings automatically?
A. Quick Analysis
B. AutoCorrect
C. AutoComplete
D. Spelling
19. What feature of Excel allows you to automatically calculate common formulas with selected data?
A. Custom Sort
B. Conditional Formatting
C. Quick Analysis
D. Orientation
20. A table can be changed back to cell data by clicking the ______button.
A. Convert to Range
B. Quick Analysis
C. Resize Table
D. Number Filters
PowerPoint 2016
1. Which button is used to set up the pen color?A. Record Slideshow
B. Custom Slideshow
C. Set Up Slideshow
D. Rehearse Timings
2. If you're in the last cell of the table and you press Tab, what will happen?
A. A new row will be automatically added to the table.
B. Because you're at the end of the table, nothing will happen.
C. The cursor will move to the first cell in the table.
D. The cursor will move to the first cell in that row.
3. When creating a professional presentation, you must be aware of how many effects you're adding. What's a recommended guideline for producing a professional presentation?
A. Limited use of transitions
B. A different animation for each element on a slide
C. Abundant use of music
D. Multiple media elements on a slide
4. From the Table Style Options area of the Design tab, you select Banded Columns. What will happen to your table?
A. Each column will split in half.
B. Every other column will be shaded.
C. Every other column will be merged with its neighboring column.
D. Every other column will have a border added to it.
5. When editing the master slides, if you edit the layout on the title page, those changes appear on
A. only the first title slide in the presentation.
B. all slides in the presentation.
C. all slides in the current and future presentations.
D. all title slides in the presentation.
6. Which tab is used to insert a hyperlink onto a slide?
A. Add-in
B. Format
C. Home
D. Insert
7. If you combine two cells into one, what action are you performing?
A. Splitting the cells
B. Merging the cells
C. Removing a new row or column
D. Adding a new row or column
8. Which chart element provides the boundaries of the graphic?
A. Slices
B. Legend
C. Chart area
D. Chart elements
9. How can you add and remove categories from a previously created chart?
A. Click the Format tab.
B. Click the Chart Styles button.
C. Click the Chart Elements button.
D. Click the Chart Filters button.
10. PowerPoint creates visuals called
A. charts.
B. text.
C. slides.
D. images
11. While typing, a red squiggly line appears. What does that signify?
A. An alternate word from the thesaurus is recommended.
B. A fatal error and the word must be deleted and retyped.
C. A possible spelling error has been identified.
D. A grammatical error has been identified.
12. When adding audio to the entire presentation, which slide should it be added to?
A. Any slide
B. Slide 1
C. It's not added to a slide.
D. The last slide
13. The point where a row and column intersect is called a/an
A. table.
B. axis.
C. element.
D. cell.
14. What's the best way to change the font size of all your notes pages at once?
A. Handout Master
B. Select each slide individually and make the change.
C. Slide Master
D. Notes Master
15. To make an exact copy of an existing slide, from the new slide gallery, select
A. Reuse slides.
B. Slides from Outline.
C. Duplicate selected slides.
D. Copy.
16. After you've added a number of animations to your slide, what's the best way to edit the animations?
A. Effect Selection Pane
B. Play Animation icon next to the thumbnail
C. Add Animation button
D. Animation Pane
17. You're creating a presentation to promote a new product. If you wanted to add a square to your slide to serve as a backdrop behind the image of the product, which option would you use to insert the square?
A. Insert Clip Art
B. Insert SmartArt
C. Insert Picture
D. Insert Shapes
18. For the most effective presentation, it's best to
A. rely heavily on the speaker notes to ensure you cover each point.
B. read the slide material to the audience verbatim to ensure they understand your message clearly.
C. practice to the point where speaker notes aren't necessary.
D. watch the projection screen to ensure there are no errors in your presentation.
19. To move the insertion point on a table to a different cell, which key should be pressed?
A. Delete
B. Tab
C. Enter
D. Home
20. How are additional slides added to a presentation?
A. Add-ins > New Slide
B. Home > New Slide
C. View > New Slide
D. Transitions> New Slide