MOS Excel: Managing Worksheets & Workbooks 5 — Questions and Answers
Question 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?
- Sheet Options > Headings > Print checkbox (Correct answer)
- Page Setup > Header/Footer > Include Headings
- Print Titles > Rows to repeat at top
- View > Show > Headings
Correct answer: Sheet Options > Headings > Print checkbox
The 'Print' checkbox under Sheet Options > Headings in the Page Layout tab enables printing of row/column headings.
Question 2: You want to link a cell in one workbook to a cell in a different workbook. What syntax does the external reference use?
- =[WorkbookName]SheetName!CellRef
- ='[WorkbookName.xlsx]SheetName'!CellRef (Correct answer)
- =EXTERNAL(WorkbookName,SheetName,CellRef)
- =[SheetName!CellRef]WorkbookName
Correct answer: ='[WorkbookName.xlsx]SheetName'!CellRef
External references use the syntax ='[WorkbookName.xlsx]SheetName'!CellRef with the filename in square brackets.
Question 3: What is the purpose of a workspace file (.xlw) in older versions of Excel?
- It stores multiple workbooks' data merged into one file
- It saves the arrangement of multiple open workbook windows so they can be reopened together (Correct answer)
- It creates a backup of the active workbook
- It stores shared macros accessible to all open workbooks
Correct 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.
Question 4: You need to repeat specific rows at the top of every printed page in a large worksheet. Where do you configure this?
- Insert > Header & Footer > Repeat Rows
- Page Layout > Page Setup > Print Titles > Rows to repeat at top (Correct answer)
- View > Page Layout > Freeze Rows
- File > Print > Print Settings > Repeat Headers
Correct 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.
Question 5: When you use 'Arrange All' under the View tab with multiple workbooks open, which arrangement option tiles windows side by side horizontally?
- Tiled
- Horizontal
- Vertical (Correct answer)
- Cascade
Correct answer: Vertical
The 'Vertical' arrangement in Arrange All places workbook windows side by side in columns.
Question 6: Which workbook property, viewable in File > Info, shows the total time the file has been actively worked on?
- Last Modified
- Total Editing Time (Correct answer)
- Created Date
- Last Printed
Correct answer: Total Editing Time
The 'Total Editing Time' property in File > Info tracks cumulative time spent with the workbook open and active.
Question 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?
- Click File > Enable Editing from the menu
- Click the 'Enable Editing' button on the yellow bar (Correct answer)
- Press Ctrl+Shift+E to toggle editing mode
- Close and reopen the file from a trusted location
Correct 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.
MOS Excel: Managing Worksheets & Workbooks 5
Which option in the Page Layout tab controls whether row and column headings (1, 2, 3 and A, B, C) print on each page?