I85PREP
⌘ K
MO-200 study materials
MO-200 study resources

MO-200 practice questions

One question at a time. Build your MO-200 understanding.

First 50 of 200 questions. Each one lists the choices, the correct answer, and an explanation. The checker at the top of this page saves progress in this browser when it is available.

Continue in the practice tool above to load more questions, 50 at a time.

Question 1Manage worksheets and workbooks

A workbook has three worksheets named Jan, Feb, and Mar. Which action creates a single new worksheet inserted immediately after the Feb tab?

  1. Select all three tabs and press Ctrl+N
  2. Right-click the Feb tab and choose Insert, then choose Worksheet Correct answer.
  3. Right-click the Feb tab and choose Move or Copy without checking Create a copy
  4. Choose File > New and select Blank workbook

Explanation

The Insert command on a sheet tab's shortcut menu adds a new worksheet positioned directly after the tab you right-clicked. File > New creates an entirely separate workbook file, not a sheet inside the current one.

Question 2Manage worksheets and workbooks

Which file format preserves worksheet formulas, multiple sheets, and formatting while remaining the default Excel workbook type?

  1. .txt
  2. .pdf
  3. .xlsx Correct answer.
  4. .csv

Explanation

The .xlsx format is the standard Excel workbook format and retains formulas, multiple worksheets, charts, and formatting. Plain-text and PDF formats flatten the workbook and cannot store live formulas across sheets.

Question 3Manage worksheets and workbooks

You want the row and column headings (1, 2, 3 and A, B, C) to appear on every printed page of a long worksheet. Where do you configure this?

  1. Formulas > Show Formulas
  2. View > Freeze Panes
  3. Page Layout > Print Titles Correct answer.
  4. Insert > Header & Footer

Explanation

The Print Titles option on the Page Layout tab lets you specify rows to repeat at top and columns to repeat at left on every printed page. Freeze Panes only affects the on-screen view, not the printout.

Question 4Manage worksheets and workbooks

Which view should you use to drag page-break lines and adjust margins visually before printing a worksheet?

  1. Normal view
  2. Page Layout view
  3. Page Break Preview Correct answer.
  4. Custom Views

Explanation

Page Break Preview displays automatic and manual page breaks as draggable blue lines so you can reposition them. Normal view shows no page boundaries, and Page Layout view shows margins but does not let you drag break lines.

Question 5Manage worksheets and workbooks

You need a worksheet tab to display the text 'Q1 Summary' instead of 'Sheet1'. What is the correct procedure?

  1. Change the workbook file name to Q1 Summary
  2. Double-click the tab, type the new name, and press Enter Correct answer.
  3. Choose View > Rename Sheet
  4. Type the text into cell A1 and it becomes the tab name

Explanation

Double-clicking a sheet tab (or right-clicking and choosing Rename) activates the tab name for editing; typing the new text and pressing Enter applies it. Cell content and file names are independent of the sheet tab label.

Question 6Manage worksheets and workbooks

Which command hides an entire worksheet so its tab does not appear in the workbook?

  1. Select the sheet's columns and choose Format > Hide
  2. Right-click the sheet tab and choose Hide Correct answer.
  3. Choose View > Hide
  4. Set the tab color to white

Explanation

The Hide command on a sheet tab's shortcut menu removes the tab from view while keeping the sheet's data in the workbook. Hiding columns only conceals cells on a visible sheet, not the tab itself.

Question 7Manage worksheets and workbooks

A user wants two worksheets from the same workbook to appear side by side for comparison. Which command accomplishes this?

  1. View > New Window, then View > Arrange All Correct answer.
  2. Data > Consolidate
  3. View > Zoom to Selection
  4. View > Freeze Panes

Explanation

Creating a new window for the same workbook and then using Arrange All lets you display different sheets from that workbook side by side. Freeze Panes and Zoom affect a single window's display, and Consolidate combines data values.

Question 8Manage worksheets and workbooks

You want column A to remain visible while scrolling right through columns B through Z. Which setting should you apply?

  1. Select column A, then choose Format > Hide
  2. Choose View > Split at cell B1
  3. Select cell B1, then choose View > Freeze Panes > Freeze Panes Correct answer.
  4. Select cell A1, then choose View > Freeze Panes > Freeze First Column

Explanation

Freeze Panes freezes everything above and to the left of the active cell, so selecting B1 keeps column A locked while other columns scroll. The Freeze First Column option also works but is not among the choices as a cell-selection method here; selecting B1 is the precise approach.

Question 9Manage worksheets and workbooks

A workbook must be shared so reviewers can open it read-only and cannot accidentally overwrite the original. Which approach best meets this requirement?

  1. Save the file as .csv
  2. Hide all worksheets except one
  3. Mark the workbook as Final and apply a password to modify Correct answer.
  4. Protect the worksheet with a password

Explanation

Marking the workbook as Final signals it is complete, and a password to modify forces users to open read-only unless they supply the password. Worksheet protection restricts cell editing but does not control whether the file opens read-only.

Question 10Manage worksheets and workbooks

Which action changes the default number of worksheets created in every new workbook?

  1. Insert > Worksheet repeated manually
  2. View > Workbook Views
  3. Page Layout > Sheet Options
  4. File > Options > General > set 'Include this many sheets' Correct answer.

Explanation

The number of sheets included in new workbooks is controlled in File > Options > General under the setting for sheets to include. This is an application-level default that applies to future workbooks, not the current one.

Question 11Manage worksheets and workbooks

You need to display only rows where a specific department appears, without permanently deleting other rows. Which feature should you use?

  1. Group the worksheet tabs
  2. Sort the data by department
  3. Delete the other rows
  4. Apply a filter to the department column Correct answer.

Explanation

Filtering temporarily hides rows that do not match criteria while keeping the data intact and restorable. Sorting reorders rows but still displays all of them, and deleting rows is destructive.

Question 12Manage worksheets and workbooks

A worksheet is protected, and you want users to edit only cells B2:B10 while all other cells remain locked. What must you do before enabling sheet protection?

  1. Unlock cells B2:B10 in the Format Cells dialog Correct answer.
  2. Hide column B
  3. Merge cells B2:B10
  4. Apply a conditional format to B2:B10

Explanation

By default all cells are locked, but locking only takes effect once sheet protection is enabled. You must clear the Locked property for B2:B10 in Format Cells so those cells remain editable after protection is applied.

Question 13Manage worksheets and workbooks

You want a worksheet to print on a single page wide regardless of how many columns it contains. Which setting achieves this?

  1. Set Scale to Fit to 1 page wide by blank tall Correct answer.
  2. Increase the top margin
  3. Choose Portrait orientation
  4. Set the print area to the first column only

Explanation

The Fit to option under Page Setup scaling forces the printout to fit within a specified number of pages wide and tall. Setting 1 page wide with tall left blank shrinks the content horizontally to a single page.

Question 14Manage worksheets and workbooks

A user wants the same header row repeated on each printed page of a 40-row table. Which setting is used?

  1. Header & Footer with a custom header
  2. Page Break Preview
  3. Freeze Panes at row 1
  4. Print Titles with rows to repeat at top Correct answer.

Explanation

Print Titles lets you designate specific rows (for example $1:$1) to repeat at the top of every printed page. A header or footer prints text in the margin, not the worksheet's header row.

Question 15Manage worksheets and workbooks

You want to save the current sheet's column widths, hidden rows, and print settings so they can be reapplied later. Which feature should you use?

  1. Conditional formatting
  2. Sheet protection
  3. Custom Views Correct answer.
  4. Freeze Panes

Explanation

Custom Views stores print settings, hidden rows and columns, column widths, and filter settings for a worksheet, and can be reapplied later. It is the appropriate tool for capturing and restoring a specific display and print configuration.

Question 16Manage worksheets and workbooks

A workbook contains a hidden worksheet named Rates. What is the correct way to make it visible again?

  1. Right-click any tab and choose Unhide, then select Rates Correct answer.
  2. Change the tab color of Rates
  3. Choose View > Freeze Panes
  4. Select all tabs and press Ctrl+H

Explanation

The Unhide command on a sheet tab's shortcut menu lists all hidden sheets so you can select the one to restore. Hidden sheets do not appear as tabs, so they cannot be right-clicked directly until unhidden.

Question 17Manage worksheets and workbooks

You need to move a worksheet named Data from the current workbook into a different open workbook. Which command allows this?

  1. Choose Data > Consolidate
  2. Choose File > Save As and overwrite the other workbook
  3. Right-click the Data tab and choose Move or Copy, then select the other workbook Correct answer.
  4. Choose Insert > Worksheet

Explanation

Move or Copy lets you send a sheet to another open workbook by choosing that workbook in the To book list. Saving as a different file replaces the whole file rather than transferring one sheet.

Question 18Manage worksheets and workbooks

A user wants to print only rows 5 through 20 of a large worksheet. What is the most direct method?

  1. Hide rows 1 through 4 and 21 onward
  2. Set the print area to A5:last column row 20 Correct answer.
  3. Reduce the scaling to 50 percent
  4. Delete rows outside the range

Explanation

Defining a print area restricts printing to the specified range, so setting it to rows 5 through 20 prints only those rows. Hiding or deleting rows alters the worksheet and is not a clean way to limit print output.

Question 19Manage worksheets and workbooks

You want to compare two worksheets from different workbooks on screen at the same time. Which sequence works?

  1. Open both workbooks and choose Data > Consolidate
  2. Choose File > Options > Advanced
  3. Choose View > Freeze Panes in each workbook
  4. Open both workbooks, then View > Arrange All and choose a layout Correct answer.

Explanation

Arrange All tiles all open workbook windows so they can be viewed simultaneously. It works across separate workbooks as well as multiple windows of the same workbook.

Question 20Manage worksheets and workbooks

A workbook must prevent users from adding, deleting, or renaming worksheets while still allowing them to edit cell data. Which protection setting is required?

  1. Mark as Final
  2. Protect Workbook with the Structure option enabled Correct answer.
  3. Encrypt with a password
  4. Protect Worksheet with all cells unlocked

Explanation

Protecting the workbook structure prevents inserting, deleting, renaming, moving, or hiding sheets while leaving cell editing unaffected. Worksheet protection governs cells, not the sheet tabs themselves.

Question 21Manage worksheets and workbooks

A user reports that a worksheet tab is missing but the sheet's data still appears in formulas elsewhere. What is the most likely explanation?

  1. The cells are formatted as text
  2. The worksheet has been hidden Correct answer.
  3. The workbook was saved as .csv
  4. The worksheet has been deleted

Explanation

A hidden worksheet's tab is not displayed, yet its cells remain available to formulas and references in other sheets. Deletion would break references, and a .csv save would not retain multiple sheets at all.

Question 22Manage worksheets and workbooks

You need the same print area and page orientation applied consistently to several worksheets in one workbook. Which approach is most efficient?

  1. Group the worksheets, apply the page setup, then ungroup Correct answer.
  2. Save the workbook as a template
  3. Use conditional formatting on each sheet
  4. Apply the settings to each sheet individually

Explanation

Grouping worksheets causes page setup changes to apply to every selected sheet at once, after which the sheets can be ungrouped. This avoids repeating the same configuration on each sheet manually.

Question 23Manage worksheets and workbooks

A workbook opens with a message that the file is read-only. Which cause is consistent with that behavior?

  1. The workbook contains a hidden sheet
  2. The cells use a custom number format
  3. The worksheet contains frozen panes
  4. The file was marked as Final and protected with a password to modify Correct answer.

Explanation

Marking a workbook as Final together with a password to modify causes Excel to prompt for the password and open read-only if it is not supplied. The other options affect display or formatting only and do not make a file read-only.

Question 24Manage worksheets and workbooks

Which statement accurately describes the effect of choosing 'Move or Copy' with the Create a copy check box selected?

  1. A duplicate of the sheet is inserted in the destination, and the original remains Correct answer.
  2. The sheet is protected in the destination
  3. The original sheet is relocated and no copy remains
  4. The sheet is exported to a new workbook file

Explanation

Selecting Create a copy duplicates the sheet into the chosen destination while leaving the original sheet in place. Without the check box, the sheet is moved rather than duplicated.

Question 25Manage worksheets and workbooks

What is the effect of pressing Ctrl and clicking multiple sheet tabs before typing in a cell?

  1. Only the active sheet receives the entry
  2. A new worksheet is inserted
  3. The entry is applied to the same cell on all selected sheets Correct answer.
  4. The selected sheets are hidden

Explanation

Selecting multiple tabs groups them, so typing in a cell enters the same value on every selected sheet in the same position. This is useful for consistent data entry across identically structured sheets.

Question 26Manage worksheets and workbooks

A user wants every new workbook opened on a shared computer to start with four worksheets instead of one. Which setting accomplishes this?

  1. Change the value in the 'Include this many sheets' box under File > Options > General Correct answer.
  2. Right-click the sheet tab and choose Insert four times, then save the workbook as a template
  3. Add three extra sheets and mark the workbook as final under File > Info
  4. Set the default print area to cover four sheets under Page Layout

Explanation

Excel exposes a workbook-level default: File > Options > General contains an 'Include this many sheets' setting that controls how many worksheets each newly created workbook contains. Changing it affects new workbooks only, not workbooks that already exist.

Question 27Manage worksheets and workbooks

A worksheet tab named Q3 is no longer visible, but formulas on other sheets still reference Q3!A1 and return values. Which action makes the Q3 tab visible again?

  1. Choose View > New Window so the hidden sheet is displayed in a second window
  2. Use Home > Format > Hide & Unhide > Hide Columns on the active sheet
  3. Right-click any visible tab, choose Unhide, and select Q3 in the dialog box Correct answer.
  4. Delete the formulas that reference Q3!A1 so the sheet reappears automatically

Explanation

A sheet whose tab is absent but whose cells are still referenced is hidden, not deleted. The Unhide command on the sheet-tab shortcut menu lists hidden sheets and restores the selected one.

Question 28Manage worksheets and workbooks

A user selects Sheet1, holds Ctrl, clicks Sheet2 and Sheet3, then types a value into cell A1 of Sheet3 and presses Enter. What is the result?

  1. The value is entered into Sheet3 and Sheet1 but not Sheet2 because Ctrl selects only pairs
  2. The value is entered only into Sheet3 because typing breaks the group selection
  3. An error appears because data cannot be typed while multiple sheets are selected
  4. The value is entered into A1 of Sheet1, Sheet2, and Sheet3 because the sheets are grouped Correct answer.

Explanation

Ctrl-clicking sheet tabs creates a sheet group, and while tabs are grouped, edits made on the active sheet are applied to the same cell on every sheet in the group. The grouping persists until it is broken by right-clicking a tab and choosing Ungroup Sheets or by clicking a tab outside the group.

Question 29Manage worksheets and workbooks

A user needs the same header row and the same print area applied to five worksheets in one workbook without configuring each sheet individually. Which approach is most efficient?

  1. Set the print titles on the active sheet and rely on Excel to apply them workbook-wide
  2. Copy the first sheet four times and paste the data into the new copies
  3. Save the workbook as .xlsx, close it, reopen it, and set the options on each sheet separately
  4. Group the five sheet tabs, set the print titles and print area once, then ungroup the sheets Correct answer.

Explanation

When worksheets are grouped, page setup changes such as print titles and print area are applied to every sheet in the group at once. Ungrouping afterward leaves the settings in place on each sheet.

Question 30Manage worksheets and workbooks

A workbook must let reviewers edit cell contents but must prevent them from adding, deleting, renaming, or moving worksheets. Which protection configuration achieves this?

  1. Mark the workbook as final and distribute it with a password to open
  2. Protect each worksheet and clear the 'Select locked cells' check box
  3. Protect the workbook structure with a password and leave worksheet cells unlocked Correct answer.
  4. Apply a password to the file and share it from a read-only network folder

Explanation

Workbook structure protection, found under Review > Protect Workbook, blocks structural changes such as inserting, deleting, renaming, moving, or hiding sheets while leaving cell editing unaffected. Worksheet protection and file-level passwords control different things and do not restrict sheet structure.

Question 31Manage data cells and ranges

In Excel, which procedure uses the Clipboard to move the contents of a selected range to a new location while leaving the original cells empty?

  1. Copy the range, then paste it at the destination
  2. Cut the range, then paste it at the destination Correct answer.
  3. Drag the range border with the mouse and drop it at the destination
  4. Copy the range, then use Paste Special with Values selected

Explanation

Cut followed by Paste moves the selected range through the Clipboard and clears the source contents once the paste is completed. Copying leaves the source contents in place. Dragging the range border also moves cells, but does not use the Clipboard.

Question 32Manage data cells and ranges

You want the value 25 to appear in cells B2 through B20 without typing it repeatedly. What is the fastest built-in method?

  1. Type 25 in B2, select B2:B20, then use Fill > Down Correct answer.
  2. Enter 25 in B2, copy it, and paste it into B3:B20 one cell at a time
  3. Type 25 in each cell individually
  4. Type 25 in B2 and drag the fill handle while holding Ctrl

Explanation

Fill Down copies the top cell of a selection into every cell below it within the selection, so one command populates the whole block. It is the standard way to repeat a constant across a contiguous range. Typing or pasting cell by cell achieves the same result but is far slower.

Question 33Manage data cells and ranges

Which range reference is fully absolute, so that both the column and the row stay fixed when the formula is copied?

  1. $A$1 Correct answer.
  2. A1
  3. A$1
  4. $A1

Explanation

Dollar signs lock a reference component. Placing a dollar sign before both the column letter and the row number makes the reference absolute in both directions, so copying the formula never changes it. A single dollar sign locks only one component.

Question 34Manage data cells and ranges

What does the Name Box at the left end of the formula bar display when the range C4:F12 is selected?

  1. F12:C4
  2. The name of the active worksheet
  3. The count of selected cells
  4. C4:F12 Correct answer.

Explanation

The Name Box shows the address of the active cell, or the full address of the selected range using the top-left and bottom-right corners separated by a colon. It reads C4:F12 for that block. It does not report cell counts or worksheet names.

Question 35Manage data cells and ranges

Which action deletes the selected cells and shifts the remaining cells up to close the gap?

  1. Right-click and choose Clear Contents
  2. Use Home > Clear > Clear All
  3. Press Delete on the keyboard
  4. Right-click and choose Delete, then select Shift cells up Correct answer.

Explanation

The Delete command with the Shift cells up option removes the cells themselves and pulls the cells below upward, closing the gap. Pressing Delete or using Clear only empties content and leaves the cell structure unchanged.

Question 36Manage data cells and ranges

Which number format displays 1234.5 as 1,234.50 while keeping the underlying value unchanged?

  1. Text format
  2. General
  3. Accounting with two decimal places Correct answer.
  4. Percentage with two decimal places

Explanation

Number formats change only the display, not the stored value. The Accounting format inserts a thousands separator and a fixed number of decimals, so 1234.5 appears as 1,234.50. General drops trailing zeros, and Text converts the entry to a text string.

Question 37Manage data cells and ranges

What is the purpose of the fill handle in the lower-right corner of a selected cell or range?

  1. It extends a series or copies content into adjacent cells Correct answer.
  2. It opens the Format Cells dialog
  3. It inserts a new worksheet
  4. It resizes the column width

Explanation

Dragging the small square at the lower-right corner of a selection extends the content into adjacent cells, either copying a constant or continuing a recognized series such as months or numbers. Excel also shows an AutoFill Options button to control the result. It does not affect column width or open dialogs.

Question 38Manage data cells and ranges

You select the entire row 5 by clicking its row header. Which cells does the selection include?

  1. Only the cells that contain data in row 5
  2. All cells in row 5 across every column in the worksheet Correct answer.
  3. Only cells A5 through the last used column
  4. Only the visible cells in row 5

Explanation

Clicking a row header selects the whole row, which spans every column in the worksheet up to the maximum column, regardless of where data currently ends. Formatting applied to that selection therefore affects the entire row.

Question 39Manage data cells and ranges

A formula in D2 contains the reference B2. When the formula is copied to D3, what reference appears in D3?

  1. B3 Correct answer.
  2. C3
  3. C2
  4. B2

Explanation

A relative reference adjusts by the same offset as the copy. Moving the formula one row down changes the row number by one, so B2 becomes B3. The column stays the same because the formula did not move sideways.

Question 40Manage data cells and ranges

You want to paste only the formatting of a copied range onto another range, without its values. Which Paste Special option do you choose?

  1. Formats Correct answer.
  2. Formulas
  3. Values
  4. Column widths

Explanation

The Formats option in Paste Special transfers number formats, fonts, fills, and borders while leaving the destination's existing values untouched. Values and Formulas paste content instead of appearance. Column widths affect layout only.

Question 41Manage data cells and ranges

A worksheet has several non-adjacent ranges you need to format identically. How do you select them in one operation?

  1. Select the first range and press F4 to add each additional range
  2. Select the first range, then hold Shift and click each additional range
  3. Select the first range, then hold Ctrl and select each additional range Correct answer.
  4. Select each range in turn and apply the format separately

Explanation

Holding Ctrl while dragging or clicking adds each new range to the current selection, producing a multi-area selection that can be formatted or cleared in one action. Shift extends a single contiguous selection rather than adding separate blocks.

Question 42Manage data cells and ranges

You need a named range called TaxRate that always points to cell F1. Which tool creates it with the least risk of typing errors?

  1. Use Formulas > Define Name and set the Refers to box to F1 Correct answer.
  2. Apply a custom number format to F1
  3. Type TaxRate directly into a cell and reference that cell
  4. Insert a comment on F1 that says TaxRate

Explanation

The Define Name dialog lets you specify the name and its Refers to range explicitly, so Excel stores the correct address and validates the syntax. Typing the name in a cell creates text, not a defined name. Comments and number formats have no effect on references.

Question 43Manage data cells and ranges

What happens when you use Home > Clear > Clear Formats on a selected range?

  1. Both the contents and the formatting are removed
  2. Only the formatting is removed, and the values stay Correct answer.
  3. Only the cell contents are removed, and formatting stays
  4. The cells are deleted and remaining cells shift left

Explanation

Clear Formats removes number formats, fills, borders, and font styling from the selection while leaving the values and formulas intact. Clear Contents does the reverse, and Clear All removes both. Deleting cells removes the cells themselves.

Question 44Manage data cells and ranges

You type 1 in A1 and 3 in A2, select both cells, and drag the fill handle down to A5. What values appear in A3 through A5?

  1. 5, 7, 9 Correct answer.
  2. 3, 3, 3
  3. 1, 3, 1
  4. 4, 5, 6

Explanation

When two or more numeric cells are selected, Excel recognizes a linear trend and continues it using the step between the values. With a step of 2, the series continues 5, 7, 9. A single selected number would instead be copied.

Question 45Manage data cells and ranges

You want to insert a new blank column between columns C and D. Which action achieves this?

  1. Select columns C and D and use Clear All
  2. Select column D and use Home > Insert > Insert Sheet Columns Correct answer.
  3. Select cell D1 and press Ctrl+Delete
  4. Select column C and press Delete

Explanation

Inserting a column places the new blank column to the left of the selected column, so selecting column D inserts a new column between C and D. Deleting or clearing cells removes content rather than adding space.

Question 46Manage data cells and ranges

A formula in cell C5 reads =$A$1*B5. It is copied to D5. What does the formula in D5 contain?

  1. =$B$1*B5
  2. =$A$1*C5 Correct answer.
  3. =$A$1*B5
  4. =$B$1*C5

Explanation

The absolute reference $A$1 stays fixed no matter where the formula is copied. The relative reference B5 shifts one column to the right along with the formula, becoming C5. The result is =$A$1*C5.

Question 47Manage data cells and ranges

Which paste option would you use to copy a range of formulas into another range while preserving the formulas but not the original borders?

  1. Paste Special > All
  2. Paste Special > Values
  3. Paste Special > Formulas Correct answer.
  4. Paste Special > Formats

Explanation

Paste Special with Formulas transfers the formulas and their relative references but leaves the destination's existing formatting, including borders, in place. Paste All brings the borders along with the formulas. Values and Formats paste content or appearance only.

Question 48Manage data cells and ranges

A user reports that the formula =SUM(Data) returns #NAME? even though a defined name Data exists. What is the most likely cause?

  1. The SUM function cannot accept a defined name as an argument
  2. The name Data contains a space in its definition
  3. The name Data was defined with a scope of a different worksheet and is not visible from this sheet Correct answer.
  4. The cells in Data contain text values

Explanation

A defined name has a scope, either workbook-wide or limited to one worksheet. If Data was created with worksheet scope on a different sheet, the formula on this sheet cannot resolve it and Excel returns #NAME?. Scoping the name to the workbook or to the current sheet resolves the error.

Question 49Manage data cells and ranges

You want every cell in the range A1:A10 to show exactly two decimal places, but the stored values must keep full precision. What should you do?

  1. Round each value with the ROUND function
  2. Use the Decrease Decimal button until two decimals show
  3. Apply the Number format with two decimal places to A1:A10 Correct answer.
  4. Convert the range to Text format

Explanation

Applying a Number format with two decimals changes only how the values are displayed; the underlying stored values keep full precision and remain usable in calculations. Decrease Decimal changes the display precision but is a manual stepping action, and ROUND changes the actual values.

Question 50Manage data cells and ranges

A worksheet is filtered, and you select a range and copy it. What does Excel copy by default?

  1. All cells in the range, including hidden rows
  2. Only the visible cells in the range Correct answer.
  3. Only cells that contain formulas
  4. Only the cells in the active row

Explanation

When rows are hidden by a filter, copying a selected range copies only the visible cells by default, so pasting elsewhere produces a compact list without the hidden rows. To include hidden rows you would need to remove the filter or use a different approach.