Study your flashcards anywhere!

Download the official Cram app for free >

  • Shuffle
    Toggle On
    Toggle Off
  • Alphabetize
    Toggle On
    Toggle Off
  • Front First
    Toggle On
    Toggle Off
  • Both Sides
    Toggle On
    Toggle Off
  • Read
    Toggle On
    Toggle Off

How to study your flashcards.

Right/Left arrow keys: Navigate between flashcards.right arrow keyleft arrow key

Up/Down arrow keys: Flip the card between the front and back.down keyup key

H key: Show hint (3rd side).h key

A key: Read text to speech.a key


Play button


Play button




Click to flip

36 Cards in this Set

  • Front
  • Back
You use a(n) _____to automate data analyses.
data table
A(n)_____ shows the beginning and ending balances and the amount of payment that is applied to the principal and interest over a period.
amortization schedule
_____ ensures that users do notb change values inadvertently that are critical to the worksheet.
Cell protection
_____ 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
The data _____ section of a worksheet includes data items entered by a user of a worksheet.
Cell _____ help to set off sections of a worksheet.
To print individual sections of a worksheet, _____ these sections and then print them by _____.
name, name
When considering which cells another worksheet user should be able to manipulate, leave the cells _____.
You can deselect multiple selected sheets beginning with the Sheet1 tab by pressing the _____ key and clicking the Sheet1 tab.
A cell _____ often is created from column or row titles.
Which of the following is the path to the Borders button?
(Home tab | Font group)
You can select a cell or range by typing it's _____ in the Name Box and pressing the ENTER key.
Names are _____ cell references.
Which of the following is the path to the Name Manager button?
(Formulas tab | Defined Names group)
Names are _____ to the workbook.
Which of the following is the path to the Financial button and the PMT function?
(Formulas tab | Function Library group)
With a(n) _____ data table you can vary the value in one cell.
Data tables must be built in a(n) _____ area of a worksheet.
Which of the following is the path to the Fill button?
(Home tab | Editing group)
What is the path to the What-If Analysis button?
(Data tab | Data Tools group)
Which of the following is the maximum number of active data tables per worksheet?
As many as you want
You can delete a data table by selecting the data table and then _____.
pressing the DELETE key
Which of the following is the path to the Cell Styles button?
(Home tab | Styles group)
The _____ function returns the present value of an annuity.
To prevent round-off errors, use the _____ function.
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.
You can set up a worksheet to print in black and white with an option on the _____ tab in the Page Setup dialog box.
A check mark in the _____ check box speeds up printing by ignoring formatting and not printing most graphics.
Draft quality
Rather than setting a print area each time you want to print a range, you can _____ the range.
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.
You should create a(n) _____ when you want to keep others from changing the worksheet from protected to unprotected.
To prevent sensitive data from being seen in a worksheet, you can hide the worksheet by clicking _____ on the shortcut menu.
To hide an entire workbook on an unattended computer, click the Hide button on the _____.
(View tab | Window group)
In a process called _____, Excel continually reviews the workbook for errors in formulas as you create or manipulate it.
background formula checking
Similar to the spell checker, Excel has a _____ that checks formulas in a worksheet for rule violations.
formula checker
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