Practice Test GeeksMOS - Microsoft Office Specialist Certification Practice Test
← All MOS Flashcard Decks

Excel: Managing Worksheets & Workbooks Flashcards

7 cards from real MOS practice questions. Tap to flip, then mark Knew It or Still Learning — missed cards come back until you master them.

Read the first 7 Excel: Managing Worksheets & Workbooks flashcards as text

  1. Which option in the Page Layout tab controls whether row and column headings (1, 2, 3 and A, B, C) print on each page?

    Answer: Sheet Options > Headings > Print checkbox

    The 'Print' checkbox under Sheet Options > Headings in the Page Layout tab enables printing of row/column headings.

  2. You want to link a cell in one workbook to a cell in a different workbook. What syntax does the external reference use?

    Answer: ='[WorkbookName.xlsx]SheetName'!CellRef

    External references use the syntax ='[WorkbookName.xlsx]SheetName'!CellRef with the filename in square brackets.

  3. What is the purpose of a workspace file (.xlw) in older versions of Excel?

    Answer: It saves the arrangement of multiple open workbook windows so they can be reopened together

    An .xlw workspace file saves the window positions and layout of multiple open workbooks for later restoration.

  4. You need to repeat specific rows at the top of every printed page in a large worksheet. Where do you configure this?

    Answer: Page Layout > Page Setup > Print Titles > Rows to repeat at top

    The 'Rows to repeat at top' field in Page Layout > Page Setup > Print Titles specifies which rows print on every page.

  5. When you use 'Arrange All' under the View tab with multiple workbooks open, which arrangement option tiles windows side by side horizontally?

    Answer: Vertical

    The 'Vertical' arrangement in Arrange All places workbook windows side by side in columns.

  6. Which workbook property, viewable in File > Info, shows the total time the file has been actively worked on?

    Answer: Total Editing Time

    The 'Total Editing Time' property in File > Info tracks cumulative time spent with the workbook open and active.

  7. You open an Excel workbook and see a yellow bar at the top saying 'Protected View'. Which action exits Protected View and allows full editing?

    Answer: Click the 'Enable Editing' button on the yellow bar

    Clicking the 'Enable Editing' button on the Protected View notification bar exits restricted mode and allows full editing.