Chapter 4 Flashcards
In the accompanying figure, the Print area box accepts a name or a ____ to print.
Selected Answer
range
A cell ____ often is created from column or row titles.
name
A check mark in the ____ check box speeds up printing by ignoring formatting and not printing most graphics.
draft quality
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.
amortization schedule
Cell ____ can be used to distinguish the different functional parts of a worksheet.
Borders
Data tables must be built in a(n) ____ area of a worksheet.
unused
If you click the ____, Excel displays a menu; the first item in the menu identifies the error and the remainder of the menu contains commands from which you can choose.
Trace error button
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.
unprotected
In a process called ____, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.
background formula checking
Names are ____ cell references.
absolute
Names are ____ to the workbook.
global
Rather than manually setting a print area each time you want to print a range, you can ____ the range.
name
Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.
violations
The ____ function returns the present value of an annuity.
PV
The arguments in ____ in the ScreenTip for a function are optional.
brackets
To hide an entire workbook on an unattended computer, click the Hide button on the ____.
(Viewtab | Window group)
To prevent round-off errors, use the ____ function.
Round
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ____ on the shortcut menu.
Hide
To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.
CTRL
What is the path to the What-If Analysis button?
(Data tab | Data tools group)
When a formula fails to pass one of the rules and background formula checking is enabled, Excel displays a small ____ in the upper-left corner of the cell assigned the formula.
green triangle
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.
protect
Which of the following is the maximum number of active data tables per worksheet?
as many as you want
Which of the following is the path to the Borders button?
(Home tab | Font Group)
Which of the following is the path to the Cell Styles button?
(Home tab | Styles group)
____ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words.
The formula checker
___ ensures that users do not change values inadvertently that are critical to the worksheet.
Cell protections
You use a(n) ____ to automate data analyses.
data table
You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected.
password
You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.
Sheet
You can scale a worksheet so that it will fit on one page with an option on the ____ tab in the Page Setup dialog box.
page
You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the ____ key and clicking the Sheet1 tab.
Shift
You can delete a data table by selecting the data table and then ____.
pressing the delete key
You can choose which rules you want Excel to use by enabling and disabling them in the ____ area in the Excel Options dialog box.
Formulas
You can add and format a range border by right-clicking the selected range and clicking ____ on the resulting shortcut menu.
Format cells
With a(n) ____ data table you can vary the value in one cell.
one-input