Exam 5: Working With Multiple Worksheets and Workbooks

When a cell is formatted for a percent, if you enter the number .5 Excel translates the value as 50%.

Rather than manually setting a print area each time you want to print a range, you can ____ the range.

You should create worksheets as if you are going to use them only once.

You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.

In a data table, the ____________________ you are analyzing must include a cell reference to the input cell.

Names are ____ to the workbook.

A column border is an unused column with a significantly reduced width.

You cannot use column and row titles within formulas when you want to refer to the related data by name.

-____________________ like the kind shown in the accompanying figure have one purpose: to organize the answers to what-if questions.

Define a data table and explain the difference between a one-input data table and a two-input data table.

You can define descriptive names that are not column titles or row titles to represent cells, ranges of cells, formulas, or constants.

In a process called ____, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.

Assigning names to a cell or range of cells allows you to select them quickly.

To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.

An amortization schedule summarizes loan information over the life of the loan.

The arguments in ____ in the ScreenTip for a function are optional.

Which of the following is the path to the Name Manager button?

Smart worksheet design starts with visualizing the results you need.

A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.

Case 4-2 Ruth has a home office that she shares with her husband, Barret. She keeps track of her business profits and expenses in several worksheets. -Barret decides he wants to unprotect one of the protected cells so he can replace one of the formulas. What did Ruth do to cause an error message to appear when Barret tries to change the protection?