Microsoft Office Specialist: Associate (Office 2019) — Practice Set 1

Question 1

You are working in Microsoft Word (Office 2019). You have finished editing a long report and need to move directly to a bookmark named "Appendix" without scrolling through the whole document. Which method should you use?

Accepted Answer

The Go To feature (Home > Find dropdown > Go To, or Ctrl+G) lets you jump to a specific bookmark by name, which is exact and reliable regardless of document length. Ctrl+End only moves to the very end of the document, not necessarily to the Appendix bookmark. Ctrl+F searches for text matches, which could return unrelated occurrences of the word "Appendix" in body text rather than the bookmark location. Inserting a hyperlink is a way to let others navigate there later but is unnecessary extra work for a single one-time jump.

Question 2

You are working in Microsoft Word (Office 2019). Before sending a document to an external client, you need to check the file for hidden metadata, such as author names and revision history, so it can be safely removed. Which tool should you use?

Accepted Answer

Document Inspector (File > Info > Check for Issues > Inspect Document) scans for hidden properties, personal information, comments, and revision history, letting you remove them before sharing externally. Check Accessibility looks for issues that make content hard for people with disabilities to read, not hidden metadata. Accepting all tracked changes finalizes edits but does not remove author metadata stored in document properties. Trust Center manages security and privacy settings for macros and file sources, not a metadata-removal tool.

Question 3

You are working in Microsoft Word (Office 2019). You need to copy the exact character formatting (font, size, and color) of one heading and apply it to another piece of text elsewhere in the document, without retyping the text. What should you use?

Accepted Answer

Format Painter (Home tab, brush icon) copies the exact character formatting from selected text and applies it to another selection with a click-and-drag. Find and Replace can search and replace formatting attributes across the document but is more cumbersome for a single one-off copy. The Styles pane applies predefined styles rather than copying ad hoc formatting from a specific run of text. Clear Formatting removes formatting rather than copying it.

Question 4

You are working in Microsoft Word (Office 2019). You need the first two pages of a document to remain in a single column, while the remaining pages display the text in three columns. What is the correct approach?

Accepted Answer

Applying different column layouts to different parts of a document requires a section break, since column settings are a section-level property. Placing the cursor where the three-column layout should start and inserting a Continuous section break (Layout > Breaks > Continuous) creates a new section beginning at that point, to which you can then apply the three-column layout independently of the earlier section. Applying columns to the entire document (B) would incorrectly format the first two pages as well. Text boxes (C) are a workaround that loses proper text flow and reflow behavior. A Page Break (D) forces a new page but does not create a new section, so column formatting would still apply to the whole existing section.

Question 5

You are working in Microsoft Word (Office 2019). You have a table that spans multiple pages, and you need the header row to repeat automatically at the top of every page it flows onto. How do you configure this?

Accepted Answer

Selecting the header row (or placing the cursor in it) and clicking "Repeat Header Rows" on the Table Layout tab configures Word to automatically display that row at the top of the table whenever it continues onto a new page, and the setting updates dynamically as content is added or removed. Manually copying the header row (B) creates a static duplicate that will not stay synchronized with the original if it changes and can misalign when the table reflows. Inserting page breaks (C) forces pagination but does not repeat the header. Converting to text (D) destroys the table structure entirely.

Question 6

You are working in Microsoft Word (Office 2019). You have added several citations throughout a research paper using the built-in citation tools. You now need to generate a bibliography that lists all the sources you cited. What should you do?

Accepted Answer

References > Bibliography inserts a bibliography field that automatically compiles all the sources you added through References > Insert Citation into a formatted list, using the citation style already selected (e.g., APA, MLA). Manually retyping sources (B) is unreliable and error-prone, and does not update if new citations are added. Table of Contents (C) lists document headings, not citation sources. Copying citation text out of the body (D) produces an unformatted, unmanaged list rather than a proper bibliography field.

Question 7

You are working in Microsoft Word (Office 2019). You have inserted a company logo image into a document, and you need the surrounding paragraph text to flow around the image's irregular shape rather than leaving a rectangular gap. What should you configure?

Accepted Answer

"Tight" and "Through" text wrapping options make text follow the actual outline of the image's non-transparent content (using its wrap points) rather than a bounding rectangle, so text flows closer to the visible shape of the logo. "In Line with Text" (B) treats the image like a single large character, pushing text above and below it with no wrap-around at all. Resizing the image (C) doesn't change the wrap behavior, only its size. "Behind Text" (D) places the image behind the text, letting text overlap the image rather than flow around its outline.

Question 8

You are working in Microsoft Word (Office 2019). A colleague has sent back a draft with several tracked changes and comments. You need to review each change individually and decide whether to keep or discard it, then remove all resolved comment threads. Which TWO actions accomplish this correctly? Choose 2.

Accepted Answer

Review > Changes > Accept/Reject (using the Next/Previous navigation) lets you step through each tracked change individually and decide its fate, which satisfies the requirement to review changes one at a time. Deleting resolved comments (either directly or after marking them Resolve) clears the finished comment threads from the document. Accepting all changes at once without review (C) skips the required individual evaluation. Turning off Track Changes (D) only stops recording new changes; it does not resolve or remove the existing markup. Printing and noting changes manually (E) does not actually accept, reject, or clean up anything in the file itself.

Question 9

You are working in Microsoft Excel (Office 2019). You have a worksheet with column headers in row 1 and want them to stay visible at the top as you scroll down through hundreds of rows of data. What should you do?

Accepted Answer

Selecting the row below the headers (row 2) and choosing View > Freeze Panes > Freeze Panes locks everything above and to the left of the selection in place — in this case, row 1 — so it remains visible while scrolling through the rest of the sheet. Bold formatting (B) only changes appearance, not scroll behavior. A page break (C) affects printing, not on-screen scrolling. Split (D) divides the window into separately scrollable panes but does not lock row 1 in place the way Freeze Panes does; it's a different, less direct tool for this specific goal.

Question 10

You are working in Microsoft Excel (Office 2019). You copied a cell that contains a formula with formatting (fill color and borders) applied, but you only want to paste the resulting calculated value into a new location, without carrying over the formula or the formatting. Which paste option should you use?

Accepted Answer

Paste Special > Values pastes only the calculated result of the formula as static data, discarding both the underlying formula and any formatting from the source cell. Paste Special > Formulas would carry over the formula itself, recalculating based on the new location's references. Regular Paste (Ctrl+V) copies everything — formula, formatting, and value. Paste Special > Formats copies only formatting (fill, borders, fonts) without any data or formula at all, the opposite of what's needed here.

Question 11

You are working in Microsoft Excel (Office 2019). You need a group of cells in column C to automatically highlight in red whenever the value entered is below 50, and this behavior needs to keep working as new values are entered later. What is the correct approach?

Accepted Answer

Conditional Formatting with a "Less Than" rule (Home > Conditional Formatting > Highlight Cells Rules > Less Than, entering 50 and choosing a red fill) applies formatting dynamically based on each cell's current value, automatically updating as new values are typed in — exactly matching the requirement for ongoing behavior. Manually applying red fill (B) is static and will not update for future entries. The Number format's built-in red-for-negative option (C) only applies to negative numbers, not a custom threshold like 50. Applying and removing a style manually (D) requires constant manual intervention and is not automatic.

Question 12

You are working in Microsoft Excel (Office 2019). You have a range of cell data with headers and want to convert it into a formal Excel table so you can use structured references and built-in filtering. What is the correct method?

Accepted Answer

Selecting the range and using Insert > Table (or Ctrl+T) converts a plain cell range into a formal Excel Table object, which enables structured references, automatic filter buttons on headers, banded formatting, and automatic range expansion when new rows are added. Applying a fill color (B) only changes appearance and provides none of a Table's structural or functional benefits. Sort (C) reorders rows but does not create a Table object. Merging header cells (D) would actually break the one-header-per-column structure that Excel Tables require.

Question 13

You are working in Microsoft Excel (Office 2019). You have an Excel table of sales transactions and need to display a Sum total for the Amount column at the bottom of the table, which should update automatically as filters are applied. What should you do?

Accepted Answer

Enabling "Total Row" on the Table Design tab adds a row directly beneath the table that lets you choose an aggregate function (like Sum) per column from a dropdown. This total row is table-aware, meaning it recalculates automatically to reflect only the currently visible (filtered) rows. A manual SUM formula placed outside the table (B) would sum all rows regardless of filtering unless written with SUBTOTAL, and it's not part of the table's built-in structure. Data > Subtotal (C) inserts subtotal rows within grouped data ranges and actually requires the data to be a plain range, not a formal Table — using it on table data isn't the intended workflow. A PivotTable (D) is a valid alternative reporting tool but is a heavier solution than simply enabling the table's built-in Total Row for this straightforward need.

Question 14

You are working in Microsoft Excel (Office 2019). You have a formula in cell B2 that references cell A1 as =A1*10. You need to copy this formula down to B3 through B10 so that every row multiplies its own value in column A by the same fixed value stored in cell D1, which should NOT change as the formula is copied. How should you write the reference to D1?

Accepted Answer

An absolute reference, written with dollar signs before both the column and row ($D$1), locks the reference so it does not change when the formula is copied to other cells — every copied row will still reference D1. A relative reference (D1) would shift as the formula is copied down, referencing D2, D3, and so on, which is not desired here. A mixed reference like D$1 locks only the row (useful when copying across columns but not down rows in this particular direction alone) — since only column D1 must stay fixed while A1 correctly changes relatively as a row reference, the fully absolute $D$1 is required, not a mix that leaves the column unlocked. Locking column A instead of D ($A1) does not address the actual requirement, which concerns the D1 reference remaining fixed.

Question 15

You are working in Microsoft Excel (Office 2019). You need a formula that joins the first name in A2 and the last name in B2 into one cell as "Smith, John" (last name, comma, space, first name). Which formula produces this result?

Accepted Answer

CONCAT() joins multiple text values into one string, so =CONCAT(B2,", ",A2) combines the last name, a literal ", " separator, then the first name — producing "Smith, John". SUM() adds numeric values and is not designed for text concatenation. LEFT() extracts a specified number of characters from the left side of a single text string and does not combine two separate cells. COUNTA() counts non-blank cells and returns a numeric count, not joined text.

Question 16

You are working in Microsoft Excel (Office 2019). You have created a column chart, but the data series originally plotted by column are now showing incorrectly and you need the rows and columns of the source data to be swapped in the chart. Which option should you use?

Accepted Answer

Chart Design > Switch Row/Column instantly swaps how Excel interprets the source data's rows and columns as chart series versus categories, without needing to re-enter or reselect the underlying data. Change Chart Type (B) changes the visual chart style (e.g., column to line) but does not affect which axis rows/columns are plotted on. Format Selection (C) opens formatting options for a selected chart element's appearance, not its data orientation. Re-inserting the chart (D) creates an entirely new chart rather than fixing the orientation of the existing one.

Question 17

You are working in Microsoft Excel (Office 2019). You need to make a chart accessible to a colleague who uses a screen reader, and you also want the chart to visually match the rest of the report using a consistent, pre-designed color and effect combination. Which TWO actions should you take? Choose 2.

Accepted Answer

Adding Alternative Text (A) (right-click chart > Edit Alt Text) provides a text description that screen readers announce, making the chart's content accessible to users who cannot see it visually. Applying a built-in Chart Style (B) from the Chart Design tab instantly applies a coordinated combination of colors, effects, and formatting that keeps the chart visually consistent with a polished report design, without manually styling each element. Converting the chart to a static picture (C) would actually reduce accessibility, since a picture without proper alt text conveys no data structure to assistive technology. Manually recoloring each series (D) is far more time-consuming than applying a built-in style and risks inconsistency. Removing the chart title (E) reduces context for screen reader users rather than improving accessibility.

Question 18

You are working in Microsoft PowerPoint (Office 2019). Before sharing a finished presentation, you want to make sure no one can edit the content further and reviewers understand it is the final version. What should you do?

Accepted Answer

Mark as Final (File > Info > Protect Presentation > Mark as Final) flags the file as complete, sets it to read-only, and disables editing commands, alerting anyone who opens it that it is intended as the final version (though this can be manually overridden). Renaming the file (B) is only a labeling convention and provides no actual protection against edits. Exporting to PDF (C) creates a separate non-editable file format but changes the deliverable format entirely rather than protecting the original .pptx. Compare (D) is used to merge and review differences between two presentation versions, not to lock a file.

Question 19

You are working in Microsoft PowerPoint (Office 2019). You want every slide in the presentation to use a specific font pairing and background image without editing each slide individually, and any new slides added later should automatically follow this design. What is the correct approach?

Accepted Answer

View > Slide Master opens the master view, where changes to fonts, colors, and background made on the slide master apply to all associated layouts and slides, including any new slides created afterward, since they inherit from the master. Manually copying formatting slide-by-slide (B) is repetitive and does not affect future new slides. Design > Variants (C) offers curated design alternatives but does not guarantee automatic propagation to new slides the way master-level edits do, and it isn't a "random" selection tool. Selecting all slides and manually changing backgrounds (D) is tedious and, again, would not automatically apply to slides added later.

Question 20

You are working in Microsoft PowerPoint (Office 2019). Your presentation has 40 slides organized into three topics. You need to group the slides by topic so you can collapse and navigate them more easily while editing, and so each group has its own descriptive label. What should you do?

Accepted Answer

Right-clicking between slides in the Slide Panel (or Thumbnail Pane) and choosing Add Section creates a collapsible section marker; sections can be renamed with a descriptive label and collapsed/expanded independently, making it easy to navigate a large deck by topic while editing. Inserting a title slide before each group (B) adds a visible slide during the presentation and does not provide the collapse/expand organizational benefit in the editing view. Outline View indentation (C) affects the hierarchy of bullet text within a slide's outline, not slide-level grouping in the Slide Panel. Applying different themes (D) changes visual appearance but has no organizational or navigational function.

Question 21

You are working in Microsoft PowerPoint (Office 2019). You have written a detailed outline of your presentation in Microsoft Word using heading styles (Heading 1 for slide titles, Heading 2 for bullet points). You need to bring this content into PowerPoint as slides, with each Heading 1 becoming a new slide title and each Heading 2 becoming a bullet under it, without retyping any text. What should you do?

Accepted Answer

Home > New Slide > Slides from Outline lets you browse to a Word document and imports its heading structure directly, converting each Heading 1 into a new slide title and each Heading 2 into a bulleted line beneath it — exactly matching the described outline structure, with no retyping required. Pasting the text into the Notes pane (B) puts the content in speaker notes, not as slide titles and bullets. Inserting a PDF as an embedded object (C) places a static, non-editable file rather than actual editable slide content. Manually retyping (D) works but defeats the purpose of reusing the already-structured outline.

Question 22

You are working in Microsoft PowerPoint (Office 2019). You have three shapes overlapping on a slide, and you need the middle shape to always appear visually in front of the other two, regardless of how they are later moved. What should you do?

Accepted Answer

Selecting the shape and choosing Arrange > Bring to Front moves it to the topmost position in the stacking (z-order), ensuring it visually overlaps any shapes beneath it, and this stacking order persists even as shapes are repositioned. Increasing the shape's size (B) makes it larger but does not change its layering position relative to the other shapes. Selecting the other two shapes and sending them backward individually (C) can achieve a similar visual result but is a more roundabout, error-prone way to accomplish the same z-order goal compared to directly bringing the target shape to front. Grouping the shapes (D) combines them into a single selectable unit but does not establish which one displays on top.

Question 23

You are working in Microsoft PowerPoint (Office 2019). You have inserted a chart showing quarterly revenue, and the underlying numbers have since changed in the source spreadsheet. You need to update the chart's data without deleting and recreating it. What should you do?

Accepted Answer

Chart Design > Edit Data opens the small embedded worksheet that stores the chart's underlying values, letting you directly update numbers and see the chart refresh accordingly, without disturbing the chart's formatting, position, or type. Deleting and recreating the chart (B) is unnecessary rework and risks losing custom formatting already applied. Format Chart Area (C) controls visual formatting like fill and border of the chart's background area, not its data values. Inserting a new embedded Excel object (D) creates a separate, unrelated object rather than updating the existing chart.

Question 24

You are working in Microsoft PowerPoint (Office 2019). You need to insert a short video clip stored on your computer directly into a slide so it plays during the presentation without needing an internet connection. Which option should you use?

Accepted Answer

Insert > Media > Video > This Device lets you browse to and embed a local video file directly into the slide, so it is packaged with the presentation and plays without requiring internet access. Online Videos (B) requires a network connection to stream the video from a hosting service, which contradicts the offline requirement. Insert > Object > Create from File (C) is intended for embedding files as linked or embedded objects of arbitrary file types and does not provide native in-slide video playback controls the way the Media > Video option does. Simply pasting a copied video file (D) is not a supported method for inserting playable video content on a slide.

Question 25

You are working in Microsoft PowerPoint (Office 2019). You have applied the same transition to every slide in the presentation, but you want each transition to take exactly 1.5 seconds to complete. What is the correct way to apply this setting to all slides at once?

Accepted Answer

The Duration field on the Transitions tab controls how long the transition effect itself takes to play. Setting it to 1.5 and clicking Apply To All applies that duration to every slide's transition in one action, avoiding the need to configure each slide separately. Setting it individually on each slide (B) achieves the same end result but is far less efficient and error-prone for a large deck when Apply To All accomplishes it in one step. The Animations tab's Duration field (C) controls the speed of object animations (like entrance or emphasis effects), not slide transitions. Rehearse Timings (D) records how long each slide is displayed during a rehearsal, which is unrelated to transition playback duration.

MO-100 / MO-200 / MO-300 — Microsoft Office Specialist: Associate (Office 2019)