38 questions
Cell ____ can be used to distinguish the different functional parts of a worksheet.
ranges
values
indices
borders
You can set up a worksheet to print in black and white with an option on the ____ tab in the Page Setup dialog box.
Page
Sheet
Margins
Header/Footer
Rather than manually setting a print area each time you want to print a range, you can ____ the range.
lock
manipulate
name
validate
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.
hide
protect
code
delete
If you wish to allow another worksheet user to be able to manipulate some cells, leave those cells ____.
locked
indexed
unprotected
hybrid
You should create a(n) ____ when you want to keep others from changing the worksheet from protected to unprotected.
password
authorized user
manager account
administrative account
In a process called ____, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.
background formula checking
workbook formula checking
foreground formula checking
background function checking
Similar to the spell checker, Excel has a formula checker that checks formulas in a worksheet for rule ____.
repetitiveness
brevity
violations
consistency
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.
blue square
red circle
green triangle
green diamond
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.
cell boundary
Error Checking button
fill handle
Trace Error button
Names are ____ to the workbook.
national
international
global
inclusive
With a(n) ____ data table you can vary the value in one cell.
one-input
two-input
three-input
unlimited-input
Data tables must be built in a(n) ____ area of a worksheet.
used
unused
upper-left
lower-right
Which of the following is the maximum number of active data tables per worksheet?
5
20
50
As many as you want
You can delete a data table by selecting the data table and then ____.
clicking the Delete command in the Clipboard group on the Home tab
pressing the DELETE key
clicking the DELETE DATA TABLE command on a shortcut menu
pressing the OVERTYPE key
The FV function returns the future value of an investment based on periodic, constant payments and a constant interest rate.
True
False
You can double-click a cell with a formula and Excel will use Formula Seek to highlight the cells that provide data for the formula.
True
False
To include additional formulas in a one-input data table, enter them in adjacent cells in the same row as the current formulas and then define the entire new range as a data table.
True
False
Data tables have one purpose: to organize the answers to what-if questions.
True
False
In a data table, the formula(s) you are analyzing must include a cell reference to the output cell.
True
False
The ____ function returns the present value of an annuity
FV
PMT
PV
VDB
To prevent round-off errors, use the ____ function.
RAND
ROUND
RADIANS
ROMAN
To select noncontiguous ranges, after selecting the first range, hold down the ____ key an drag through the additional ranges of cells to select them.
ALT
F3
CTRL
F10
An amortization schedule summarizes loan information over the life of the loan.
True
False
A column border is an unused column with a significantly reduced width.
True
False
You can use the ROUND function to determine how much the borrower of a loan still owes at the end of each year.
True
False
A(n) index is a series of fixed payments made at the end of each of a fixed number of periods at a fixed interest rate.
True
False
Bill would like to borrow $50,000 and pay it off in 10 years. What components will he need to identify for a loan amortization schedule created on an Excel worksheet?
beginning and ending loan balance
year, rate, monthly interest
beginning and ending loan balance and the amount of payment that applies to the principal and interest per year
interest paid at the beginning and end of the year
You use a(n) ____ to automate data analyses.
data table
formula checker
amortization schedule
IF function
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.
dialog box
amortization schedule
formula check
data table
A cell ____ often is created from column or row titles.
function
name
formula
data table
Which of the following is the path to the Name Manager button?
(FORMULAS tab | Function Library group)
(FORMULAS tab | Defined Names group)
(FORMULAS tab | Names group)
(FORMULAS tab | Calculation group)
Names are ____ cell references. (Hint: Can the cell name RATE change when copied to other cells?)
absolute
mixed
relative
formatted
Two of the more powerful aspects of Excel are its wide array of functions and its capability of organizing answers to what-if questions.
True
False
You cannot use column and row titles within formulas when you want to refer to the related data by name.
True
False
Assigning names to a cell or range of cells allows you to select them quickly.
True
False
When you format a cell to display percentages, Excel assumes that whatever you enter into that cell in the future will be a percentage.
True
False
If you enter a formula using Point mode and click a cell that has an assigned name, then Excel will insert the name of the cell rather than the cell reference.
True
False