MOS Excel: Managing Worksheets & Workbooks 5

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?

Accepted Answer

Sheet Options > Headings > Print checkbox

Answer

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?

Accepted Answer

='[WorkbookName.xlsx]SheetName'!CellRef

Answer

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?

Accepted Answer

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

Answer

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?

Accepted Answer

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

Answer

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?

Accepted Answer

Vertical

Answer

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

MOS - Microsoft Office Specialist Certification Practice Test