+
Related Flashcards
Related Topics
Cards In This Set
| Front | Back |
|
To control the color and thickness of a border outlining a range, Excel requires that you use the Border sheet in the ____ dialog box.
|
Format Cells
|
|
You can set a specific range of data to print each time you print a worksheet by using the ____ command.
|
Set Print Area
|
|
Names are ____ cell references.
|
absolute
|
|
When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a ____
|
small green triangle in the upper-left corner of the cell
|
|
Data tables have one main purpose, ____
wi |
to organize the answers to what-if questions
|
|
To bold the font of the entire worksheet, click the ____ button immediately above row heading 1 and left of column heading A, then click the Bold button on the Home tab.
|
Select All
|
|
A(n) ____ shows the beginning and ending balance and the amount of payment that applies to the principal and interest for each year over the life of a loan.
|
amortization schedule
|
|
The ____ checks the formulas in a workbook in a manner similar to the way the spell checker checks for misspelled words.
|
formula checker
|
|
You can add up to ____ different conditional formats to a range.
|
as many as you like
|
|
You can double-click a cell with a formula and Excel will use ____ to highlight the cells that provide data to the formula.
|
Range Finder
|
|
You should create a(n) ____ to prevent others from changing the worksheet from protected to unprotected.
|
password
|
|
You vary the value in one cell with a(n) ____
oidt |
one-input data table
|
|
Cells whose values you can change at any time are called ____
|
unprotected cells
|
|
The ____ function calculates the payment for a loan based on constant payments and constant interest rates.
|
PMT
|
|
The ____ check box in the Page Setup dialog box instructs Excel to print gridlines.
|
Gridlines
|
