Exam 33: Multiple Sheet Workbook Management: Hands On Exercise Videos

To group adjacent worksheets,you:

A(n)________ window makes it possible to monitor cells not immediately visible on the screen.

When linking to an external workbook,the workbook name is surrounded by single quotation marks.

In the figure shown above,________.

When using Trace Precedents and Trace Dependents,tracer arrows display showing the relationship between cells and formulas.

You would use ________ to monitor data input and display an appropriate message if a user enters erroneous data.

When creating a data validation rule,you can specify both input message and an alert.

A formula that references itself is called a(n)________ reference.

In a 3-D reference,worksheets references are separated from their cell references by a(n)________.

Which of the following references is written incorrectly?

To ungroup worksheets,right-click any one of the grouped worksheets' tabs and click Ungroup Sheets.

When worksheets are grouped,[Group] is displayed in the titles bar immediately after the file name.

A hyperlink to a worksheet always references cell A1 of that worksheet.

When referencing a worksheet in another workbook,the workbook name is enclosed in ________.

When Excel detects an error in a formula:

To examine multiple worksheets in the same workbook at the same time,you use New Window and Arrange All located on the ________ tab.