Excel - Module 4 - Day 1 Quick Check

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