Exam 9: Multiple-Sheet Workbook Management

'[StPaul.xlsx]Qtr3'!A3 is an example of a(n)________.

The worksheet name in a 3-D reference is enclosed in ________.

Validation ________ are the rules that dictate the type of data that can be entered.

A(n)________ window has two or four panes displaying the same worksheet.

What is the best method to consolidate 3 workbooks from 3 branch office into one regional workbook?

You developed a sales quotation workbook that you will share with your sales staff to help them quote prices.It shows #DIV/0 in some cells where there are empty quantities in a column.Which function would handle the error and replace it with another value.

Applying a format to a range of cells in a grouped worksheet will ________.

A(n)________ reference occurs when a formula uses the cell which contains the formula.

How do you group all worksheets?

A destination file is a file that contains original data that you need in another file.

The return for =12/0 will be a(n)________ error.

Which of the following is an example of Pascal Case notation.

Right clicking a sheet tab and selecting Select All Sheets will ________ all worksheets in the workbook.

3-D references must be updated manually when you adjust the reference point.

You can drag a split bar off the window to remove it.

You can apply conditional formatting on grouped worksheets.

________ is not supported in grouped worksheets, but you can apply it to one and Fill it across other worksheets.