Exam 9: Multiple-Sheet Workbook Management

Camel Case notation capitalizes the first letter of all words except the first and removes spaces

The user can define an optional ________ that appears when the mouse pointer hovers over a hyperlink.

How do you determine if a worksheet is grouped?

If you're presenting a large workbook with many worksheets,you may want to ________ some of the worksheets to provide a more streamlined appearance.

In a 3-D Reference,the ________ name is enclosed in single quotes and followed by an exclamation point.

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

What happens to an open destination file if the source file is edited while both are open?

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.

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

Which character or characters notes the file path in an external reference?

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

What do blue arrows mean when tracing precedents?

A logic error happens mostly because a user makes a mistake by using an incorrect value or reference in a formula.

________ is the process of dividing a worksheet window into two or four resizable panes so you can view separate parts of a worksheet at the same time.

When using the tracer arrows,cell with errors have ________ arrows.

A(n)________ accepts invalid data but warns the user that the data are invalid.

All of the following could produce a #NAME? Error except ________.

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