|
data table |
You use a ___ to automate data analyses. |
|
amortization schedule |
An ___ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest over a period. |
|
cell protection |
___ ensures that users do not change the values inadvertently that are critical to the worksheet. |
|
the formula checker |
___ examines the formulas in a workbook in a manner similar to the way the spell checker examines a workbook for misspelled words. |
|
entry |
The data ___ section of a worksheet includes data items entered by a user of a worksheet. |
|
borders |
Cell ___ help to set off sections of a worksheet. |
|
name, name |
To print individual sections of a worksheet, ___ these sections then print them by ___. |
|
unprotected |
When considering which cells another worksheet user should be able to manipulate, leave the cells ___. |
|
shift |
You can deselect multiple selected sheets beginning with the Sheet 1 tab by pressing the ___ key and clicking the Sheet1 tab. |
|
name |
A cell ___ often is created from column or row titles. |
|
Home tab | font group |
Which of the following is the path to the borders button? |
|
format cells |
You can add and format a range border by right-clicking the selected range and clicking ___ on the shortcut menu. |
|
name |
You can select a cell or range by typing it’s ___ in the Name Box and pressing the Enter key. |
|
absolute |
Names are ___ cell references. |
|
Formulas tab | Defined Names group |
Which of the following is the path to the Name Manager button? |
|
global |
Names are ___ to the workbook. |
|
Formulas tab | Function Library group |
Which of the following is the path to the Financial button and the PMT function? |
|
one-input |
With a ___ data table you can vary the value in one cell. |
|
unused |
Data tables must be built in an ___ area of a worksheet. |
|
Home tab | Editing group |
Which of the following is the path to the Fill button? |
|
Data Table | Data Tools group |
What is the path to the What-If Analysis button? |
|
As many as you want |
Which of the following is the maximum number off active data tables per worksheet? |
|
pressing the Delete key |
You can delete a data table by selecting the data table and then ___. |
|
Home tab | Styles group |
Which of the following is the path to the Cells Styles button? |
|
PV |
The ___ function returns the present value of an annuity. |
|
round |
To prevent round-off errors, use the ___ functinon. |
|
page |
You can select a worksheet so that it will fit on one page with an option on the ___ tab in the Page Setup dialog box. |
|
sheet |
You can set up a worksheet to print in black and white with an option on the ___ tab in the Page Setup dialog box. |
|
range |
In the accompanying figure, the Print area box accepts a name or a ___ to print. |
|
draft quality |
A check mark in the ___ check box speeds up printing by ignoring formatting and not printing most graphics. |
|
name |
Rather than setting a print are each time you want to print a range, you can ___ the range. |
|
protect |
When building a worksheet for novice users, you should ___ the cells in that worksheet that you do not want changed, such as cells that contain text or formulas. |
|
password |
You should create a ___ when you want to keep others from changing the worksheet from protected to unprotected |
|
hide |
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking ___ on the shortcut menu. |
|
View tab | Window group |
To hide an entire workbook on an unattended computer, click the Hide button on the ___. |
|
background formula checking |
In a process called ___, Excel continually reviews the workbook for errors in formulas as you create or manipulate it. |
|
formula checker |
Similar to the spell checker, Excel has a ___ that check formulas in a worksheet for rule violations. |
|
green triangle |
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. |
|
formulas |
You can choose which rules you want Excel to use by enabling and disabling them in the ___area in the Excel Options dialog box, as shown in the accompanying figure. |
|
trace error button |
If you click the ___, Excel displays a menu; the first item int he menu identifies the error and the remainder of the menu contains commands you can click. |
Share This
Flashcard
