Exam 5: Working With Multiple Worksheets and Workbooks

You can use ____________________ to indicate to Excel to leave the cell blank if an IF function's logical test is false.

Case 4-1 Bill has a bicycle repair shop in his basement. He would like a larger workshop so he investigates taking out a loan to convert his garage to a workshop. He uses Excel to create an amortization schedule. -After Bill creates the amortization schedule, he decides to add a calculator section to the worksheet. How would he create a column border to separate the calculator from the amortization schedule section?

You can start over with formatting a range by clicking the Cell Styles button (Home tab | Styles group) and tapping or clicking ____________________ in the Cell Styles gallery.

The PMT function has two arguments: rate and payment.

____________________ portions of a workbook lets you show only the parts of the workbook that the user needs to see.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Cannot be used to begin a cell or range name.

Cell ____________________ ensures that users do not change values inadvertently that are critical to the worksheet.

A(n) ____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest during each payment period.

The best alternative to define the formulas in a data table involves using the cell references preceded by an equal sign.

Which of the following is the maximum number of active data tables per worksheet?

Which of the following are financial functions?

Which of the following is the path to the Fill button?

Cell ____ can be used to distinguish the different functional parts of a worksheet.

If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.

Which of the following functions have these three arguments: rate, periods, payment?

You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.

A name cannot be assigned to two or more nonadjacent ranges.

MATCHING Identify the letter of the choice that best matches the phrase or definition. -Fixes round-off errors.

Names are ____ cell references.

When building a worksheet for novice users, you should ____ the cells in the worksheet that you do not want changed, such as cells that contain text or formulas.