Part I: Word Exam MO‐100

Chapter 1: Working with Documents

1.  C. Open the Find And Replace dialog box by clicking the Replace icon in the Home ribbon or by pressing Ctrl+H. Then type the existing and replacement text in the Find and Replace fields, respectively. Replace all instances of the existing text by clicking the Replace All button.
2.  B. A watermark is lighter background text that conveys the document status to your readers, such as a document that's confidential and only available to certain people to read.
3.  D. The header is the area between the top of the page and the top margin.
4.  C. The File screen contains the Info menu option so that you can inspect documents.
5.  A. When you click in a paragraph in your text and click a style that has the paragraph marker to the right of the name in the Styles list, Word applies all the formatting settings contained within the style to the selected paragraph.
6.  D. A theme is a collection of styles for formatting various parts of your page, such as heading text, body text, headers, and footers.
7.  B. The Share option gives you several options for sending a document either as an email attachment or on the web in a variety of formats.
8.  C. In the Home ribbon, click the down arrow to the right of the Find icon, and then click Go To in the drop‐down menu. (You can also press Ctrl+G.)
9.  D. The Accessibility Checker inspects your document and checks to see if any potential problems exist that could keep people of different abilities from reading it.
10.  B. The Compatibility Checker ensures that your document can be read by three earlier versions of Word dating back to Word 97, and it alerts you to any formatting issues that you may need to change so that all your recipients can read your document.

Chapter 2: Inserting and Formatting Text

1.  C. When you click Advanced Find in the Home ribbon, the Find And Replace dialog box appears so that you can change more search options.
2.  B. You can open the Find And Replace dialog box by clicking Replace in the Home ribbon and then clicking the Match Case dialog box to specify that the text you want to find has one or more letters in a different case.
3.  D. Open the Symbol window from the Insert ribbon by clicking the Symbol icon and then clicking the More Symbols option in the drop‐down menu. Then you can add a special character using the Special Characters tab.
4.  A. To change the format of multiple selections in your document, you must first double‐click Format Painter.
5.  C. Word makes it easy to copy the format of a selected block of text by double‐clicking the Format Painter icon. Then you can apply it to as much text in the document as you want.
6.  D. Word allows you to create a maximum of three columns.
7.  B. By default, Word adds a ½‐inch indent to the first line of the paragraph, but subsequent lines are not indented.
8.  A. Word automatically adds a new page after the one into which you inserted the page break, and you can start typing in the new page.
9.  C. After you click Column in the Breaks drop‐down menu, a new column appears on the page or on the next page so that you can type more text.
10.  B. A section is a portion of the document that has its own formatting on the same page or a new page.

Chapter 3: Managing Tables and Lists

1.  C. After you move the mouse pointer over Quick Tables, click the table style that you want to place on the page.
2.  B. When you move the mouse pointer over the grid, you can highlight three columns and seven rows and then click the lower‐right corner of the highlighted grid to insert the table on the page.
3.  C. Sorting from Z to A is descending order. Sorting from A to Z is ascending order.
4.  A. Hold down the Alt key as you click and drag on the column so that you can see the exact measurement.
5.  D. The built‐in AutoFit feature allows you to fit the size of your table or a column automatically to the longest block of content.
6.  A. Both the Table Design and Layout menu options appear at the right side of the row of options in the menu bar.
7.  B. You can use bullets from symbols, fonts, and even pictures.
8.  C. You can sort by text, which is the default search type, as well as by numbers and dates in a table.
9.  C. At the beginning of a new paragraph, you can start a bulleted list by pressing the asterisk (*) key, a space, and then some text. Word automatically converts the asterisk to the default bullet style.
10.  D. Word gets confused when you update numbers in text and then you try to add a new number in the list. So, use the Numbering feature to keep your lists numbered correctly.

Chapter 4: Building References

1.  C. When you click the References menu option, the ribbon shows you options for adding footnotes, endnotes, and more.
2.  B. After you select text in the footnote, the pop‐up menu appears above the footnote so that you can easily change the font, spacing, and paragraph styles.
3.  C. Word automatically applies the correct citation format for the writing style that you need to use for your document, so you don't need to change the format manually.
4.  A. After you click Edit Citation in the menu, add the page number in the Edit Citation dialog box and then click OK.
5.  D. After you place the cursor where you want to add the placeholder, click Add New Placeholder, type the placeholder name in the Placeholder Name dialog box, and then click OK.
6.  A. Word uses its built‐in heading styles to determine how many times text with a certain heading style should be indented in the TOC.
7.  B. You can open the Styles pane by pressing Alt+Ctrl+Shift+S to view all nine TOC styles based on all the style levels, and then modify each style as you see fit.
8.  C. A TOC reflects the layout of your document when you created it, but Word doesn't update the TOC with any other text you added to the document unless you update the TOC manually.
9.  C. Word applies the correct formats for your desired writing style into your bibliography, so you don't have to change any formatting manually.
10.  D. When you click Bibliography in the References menu ribbon, the three built‐in bibliography styles appear in the drop‐down menu.

Chapter 5: Adding and Formatting Graphic Elements

1.  C. When you click the Insert menu option, click Shapes to view a wide variety of shapes you can add from the drop‐down menu.
2.  B. When you click the SmartArt icon in the ribbon, the Choose A SmartArt Graphic dialog box opens so that you can select a prebuilt graphic from eight different categories.
3.  D. A text box is useful when you want to have text that stands apart from the rest of the text, such as a sidebar, so that you can have additional information on a side of the page that doesn't interfere with the main block of text.
4.  C. After you click Picture Effects, you can change an effect in one of the six effect categories.
5.  A. In the SmartArt Design menu ribbon, click the Reset Design icon to clear all of your previous changes and return to the original style.
6.  C. Clicking and dragging the Rotate button that appears in the middle of the selected model lets you rotate the 3D model.
7.  B. After you create at least two text boxes, click in the first one. Then click Create Link in the Text section in the Shape Format menu ribbon. You can then tell Word which text box will receive overflow text.
8.  D. After you right‐click the shape, select Add Text from the context menu.
9.  C. Placing your graphic in line with text means that the graphic is embedded at the insertion point in the text. The text above and below the graphic will stay that way, even as you add more to the document.
10.  B. If you're sharing a Word document online with other people in your company who may not be able to see the graphics in your document, then Alt text is a great way to tell those people about the messages in your graphics.

Chapter 6: Working with Other Users on Your Document

1.  D. The top of the comment box in the right margin tells you the name of the person who wrote the comment, shows the writer's avatar, and tells you how long ago the person wrote the comment.
2.  B. Click Reply in the comment box to write your reply within the comment box.
3.  C. The comment and the name of the person who wrote it are grayed out in the right margin of the document, but the comment remains in case you want to reopen it.
4.  B. After you click Reopen in the comment box, the comment is restored so that you can add to your comment or reply to it.
5.  D. After you click Delete All Comments in the menu, all comments and the right margin in your document disappear.
6.  A. The Track Changes option is available in the Review menu ribbon.
7.  B. In the Review menu ribbon, click the down arrow to the right of Simple Markup and then click All Markup. You see all of the formatting in the text as well as the change bars in the left margin.
8.  C. After you click the Reject icon in the Review menu ribbon, click Reject All Changes. All of the changes made in the document disappear.
9.  D. After you accept a change, click the Previous icon to go to the previous change in the document.
10.  A. If you want to make sure that people do not turn off Track Changes when they make any changes to a document you've shared, add a password that only you know.

Part II: Excel Exam MO‐200

Chapter 7: Managing Worksheets and Workbooks

1.  A, C. A text file uses a tab character as the delimiter, and a comma‐separated value file uses a comma as the delimiter.
2.  B. Type the tilde ( ~ ) before the question mark to ensure that Excel finds text in cells with a question mark.
3.  C. When you double‐click the right edge of the column within the header, such as to the right of the B column, Excel automatically adjusts the width to the text in a cell that has the greatest width.
4.  B, D. You can only add tools and commands to the Quick Access Toolbar.
5.  A, B, D. You can save to PDF format, text format, and HTML, which is the language used to create web pages.
6.  A, D. The Quick Access Toolbar is in the title bar by default, but you can also move it under the ribbon.
7.  B. When you add a Screen Tip, a pop‐up box appears when you move the mouse pointer over the link.
8.  C. You can add a header and/or footer from within Page Layout view.
9.  C. You must protect the worksheet by clicking the Review menu option and then clicking Protect Sheet in the Protect section in the Review menu ribbon.
10.  D. Click the Page Layout menu option to open the Page Layout ribbon. Next, click Print Area in the Page Setup section and then select Set Print Area from the drop‐down menu.

Chapter 8: Using Data Cells and Ranges

1.  B. When you select the Formulas And Number Formatting icon from the Paste drop‐down menu, Excel copies only the formatting in the formulas and any number formatting into the new cell.
2.  C. When you select Merge Across from the Merge & Center drop‐down menu in the Home ribbon, the selected cells merge and the data in the first column within the selected cells is left‐aligned.
3.  B, D. You can only start a named range with letters and underscores.
4.  D. When you click a blank cell and press Ctrl+A, Excel selects all cells in the worksheet.
5.  A. Place the Sparkline chart after the last column in a row to have the Sparkline collect its data from all columns within the row.
6.  A, B, D. You can Auto Fill sequential information, including numbers, dates, and months of the year. You can also Auto Fill a number in one cell into one or more other cells.
7.  C. When you select Format Cell Alignment from the menu, you can specify the angle in degrees.
8.  C. When you click Greater, you can format cells with numbers that are greater than a specific value in the Greater Than dialog box.
9.  C. A named range can be no longer than 255 characters, including spaces.
10.  A, C, D. You can apply the Accounting Number style (the $ icon) for the type of currency, the Percent style (the % icon), and the Comma style for numbers larger than 999.

Chapter 9: Working with Tables and Table Data

1.  C. Excel applies the formatting from your table to the cell range.
2.  B, D. You can press Ctrl+Z to undo the deletion, or you can click the Undo icon in the Quick Access Toolbar if you prefer to use the mouse.
3.  C. Sorting from Z to A is descending order. Sorting from A to Z is ascending order.
4.  A, C, D. In the Format Cells dialog box, you can change the font, border, and fill color and pattern in the appropriate tabs.
5.  D. The Count Numbers option shows you the total number of cells in the column that have numbers in them.
6.  A, B, D. In the Table Design menu ribbon, the Header Row, Banded Rows, and Filter Button check boxes are checked by default.
7.  A, B. The header row and filter button are two features that appear automatically in your new table.
8.  C. You need to sort by column in a custom sort, and you can select the column you want to use for the sort.
9.  B. Excel totals the last (or rightmost) column in a table.
10.  D. Several style tiles appear in the Table Styles section within the Table Design menu ribbon that opens after you create a table.

Chapter 10: Performing Operations by Using Formulas and Functions

1.  C. As you press F4 on the keyboard, the cell reference type cycles between all three types.
2.  B. The COUNTA ( ) function counts all cells in a selected range that have characters in them and returns the number of cells Excel found.
3.  C. The RIGHT() function shows the last five characters, or the five characters at the right, of the text in cell A3.
4.  A, C, D. You can create a mixed, relative, or absolute cell reference type in a formula.
5.  D. The function does not count empty cells when you average numbers within a range of cells.
6.  D. The LEFT() function treats spaces as characters, so spaces appear in the cell where you entered the LEFT() formula.
7.  B. Using A2 without any $ signs in the cell reference indicates that this is a relative cell reference.
8.  C. Type the equal sign before you type the left parenthesis when you start to add a formula in the Formula Bar.
9.  A. The CONCAT() function combines text strings in two or more cells and does not place a space or any other characters between each string.
10.  D. You need to add a comma between each cell range in the parentheses within the SUM() function.

Chapter 11: Managing Charts

1.  C. When you select the All Charts tab, a list of chart categories appears at the left side of the dialog box so that you can click each category and see the different types of charts that you can add to the right of the list.
2.  B. Excel uses columns for the horizontal axis when there are an equal number of columns and rows.
3.  A, C. You can change styles for both shapes and WordArt.
4.  A. The legend appears at the bottom of the chart area so that you know what each color in the chart represents.
5.  A, C, D. The built‐in styles contain options for changing the border color, text color, and/or text background color.
6.  C. When you click the Chart Elements icon in the upper‐right corner of the selected chart, the right arrow appears when you move the mouse pointer over the element.
7.  B. A chart in a chart sheet is a fixed size, even though sizing handles appear in the bounding box around the chart.
8.  C. A trendline shows you the overall trend of one specific type of data over time.
9.  D. A chart layout allows you to make changes to how the data is presented, and the chart style allows you to change the look and feel of the chart.
10.  B. If you're sharing an Excel workbook online with other people in your company who may not be able to see the chart in your document, then Alt text is a great way to tell those people about the messages in your chart.

Part III: PowerPoint Exam MO‐300

Chapter 12: Creating Presentations

1.  A, C. You can change fonts and colors in the slide layout, as well as the title, footers, and effects. You can also hide background graphics.
2.  B. PowerPoint automatically displays your slideshow in Normal view.
3.  B, D. PowerPoint will print slides 3 through 8, slide 10, and slide 12.
4.  C. When you click the Browsed At A Kiosk (Full Screen) button in the Show Type section, the Loop Continuously Until ‘Esc’ check box is hidden, because when you click the button you loop the presentation automatically.
5.  D. Marking a slideshow as final still gives people the ability to edit your slideshow. Adding a password turns off the ability to edit the slideshow to anyone who does not have the password.
6.  C. Once you apply changes to a handout master, you will see that all pages in the handout reflect those changes.
7.  A, D. Widescreen (16:9) is the default size, but you can also change your slide size to Standard (4:3).
8.  B. You can select from one of nine print options for the slideshow handouts.
9.  C. The bottom of the left pane tells you what slide you're on and how many slides there are in the presentation.
10.  A, C. The default resolution is 1080p, but you can also choose Standard (480p), HD (720p), and Ultra HD (4K).

Chapter 13: Managing Slides

1.  C. PowerPoint automatically checks to see if there is more text than a slide can manage and creates one or more additional slides to display the rest of the outline text.
2.  B. You still see the hidden slide in the list, but the slide has a gray background and the slide number above the slide has a diagonal line through it.
3.  D. When you click Section in the menu, select Add Sections from the drop‐down menu to type the name of the new section in the Rename Section dialog box.
4.  C. When you select the Keep Source Formatting check box in the Reuse Slides pane, PowerPoint keeps the source formatting.
5.  A, C. You can add a gradient and pattern fill to a slide background. The solid fill is selected by default. You can also hide background graphics, but PowerPoint does not classify that as a background fill.
6.  D. When you press and hold the Ctrl key as you click each slide, PowerPoint selects all the slides you click on so that you can move the slides to a new location.
7.  B. PowerPoint places the new slide directly below the selected slide.
8.  A. A page number appears at the right side of the footer, which is the bottom‐right corner of the slide.
9.  C. Rename the section by clicking the Home menu option. In the Slides area in the Home section, click Section and then select Rename Section from the drop‐down menu.
10.  D. PowerPoint displays one slide per section within a Summary Zoom slide.

Chapter 14: Inserting and Formatting Text, Shapes, and Images

1.  A. To change the format of multiple selections in your document, you must first double‐click Format Painter.
2.  C. PowerPoint uses the standard blue underlined text for hyperlinks in a slide.
3.  C. After you click Picture Effects, you can change an effect in one of the seven effect categories.
4.  D. A text box is useful when you want to have text that stands apart from the rest of the text on the slide and that doesn't interfere with the main block of text.
5.  C. Selecting Send Backward from the Arrange drop‐down list moves the selected object down a level in the stack of objects.
6.  B, D. The Place In This Document option is selected by default. Then you have to click the numbered slide that corresponds to the Summary Zoom slide because PowerPoint does not name that slide by default.
7.  A. Once you click the Home menu option, you can change the indentation and spacing in the Paragraph section in the Home ribbon.
8.  D. After you right‐click the shape, select Edit Text from the context menu.
9.  B. If you're sharing a slideshow with other people in your company who may not be able to see the graphics in PowerPoint, then Alt text is a great way to tell those people about the messages in your graphics.
10.  A, B, D. You can view guides, gridlines, and or rulers by selecting the appropriate check boxes in the View ribbon.

Chapter 15: Inserting Tables, Charts, SmartArt, 3D Models, and Media

1.  C. After you move the mouse pointer over Quick Tables, click the table style that you want to place on the page.
2.  B. PowerPoint uses columns for the horizontal axis when there are an equal number of columns and rows.
3.  A. In the SmartArt Design menu ribbon, click the Reset Graphic icon to clear all your previous changes and return to the original style.
4.  C. Clicking and dragging the Rotate icon that appears in the middle of the selected model lets you rotate the 3D model.
5.  D. Press the Windows logo key, Shift, and Q at the same time to stop the video recording.
6.  A. Both the Table Design and Layout menu options appear at the right side of the row of options in the menu bar.
7.  C. A trendline shows you the overall trend of one specific type of data over time.
8.  B. When you click the SmartArt icon in the ribbon, the Choose A SmartArt Graphic dialog box opens so that you can select a prebuilt graphic from eight different categories, including the Pyramid category.
9.  B, D. You can change the height and width of the 3D model by typing those measurements in inches (and as precisely as hundredths of an inch) in the Height and Width boxes, respectively.
10.  D. When you click a bookmark, you can click the bookmark dot in the playback bar timeline to jump to that spot in the audio or video clip.

Chapter 16: Applying Transitions and Animations

1.  C. After you apply the transition, click Apply To All in the Timing section in the Transitions ribbon.
2.  B, C. You can animate text by specifying that you can animate one letter at a time, one line at a time, or all of the text on the slide as an entire object.
3.  C. After you change the duration, click Preview at the left side of the Transitions ribbon to see how long the slide stays on the screen before moving to the next one.
4.  A, D. From the drop‐down list of transition effects, you can choose effects from the Subtle and Exciting sections, and you can also select from the Dynamic Content section.
5.  B. Click the Transitions menu option to add transition effects between slides in the Transitions ribbon.
6.  A, C. When you click the Animations menu option, markers appear in the slide and show you the marker numbers in the sequence, with the largest number signifying the last animation in the sequence.
7.  B. In the transition effects drop‐down list, hover the mouse pointer over the effect icon for a second or two. A tooltip will pop up and tell you what the effect does.
8.  B. The One by One sequence animates each shape within a SmartArt graphic. When the animation of the first shape is complete, PowerPoint animates the second shape in the graphic.
9.  C. Each effect has its own default duration that you can change in the Transitions ribbon.
10.  D. The Animation Pane contains a list of all animations. When you click the down arrow to the right of the animation name in the list, you can remove the animation from the drop‐down menu.