Study Guide Microsoft Excel

____ checks which cells are referenced in the formula assigned to the active cell.

Range Finder

The ____ box allows you to specify the percentage of reduction or enlargement in the printout of a worksheet.

Adjust to

A dot on the screen that contains a color is called a ____.

pixel

A(n) ____ is a prewritten formula that is built into Excel.

function

You can assign a ____ to a cell, and Excel will calculate the result.

formula

A(n) ____ is text and graphics that print at the top of each page.

header

The ____ version of a worksheet shows the results of formulas.

values

The arithmetic operator for multiplication is ____

*

The Accounting Number Format button assigns a ____ dollar sign to the numbers in the ranges.

fixed

If you enter a formula in cells, Excel ____ the product whenever new values are entered into those cells.

recalculates

The ____ button lists formatting options following the insertion of cells, rows, or columns.

Insert Options

A formula in a cell that contains a reference back to itself is called a ____ reference.

circular

cells is a technique you can use to hide data that might be sensitive or not relevant to a report.

Hiding

When you tap or click the ____ button, Excel assigns the next highest font size in the Font Size gallery to the selected range.

Increase Font Size

The ____ dialog box can be used to apply formatting that is not available directly on the ribbon.

Format Cells

To override the order of operations, use ____.

parentheses

colors tend to reach towards your worksheet's reader.

Warmer

When performing copying operations in Excel, the ____ area is the cell, or range, from which data or formulas are being copied.

source

allows you to select cells for use in a formula by using your finger or the pointer.

Point mode

To check the spelling of the text in a single cell, double-tap or double-click the cell to make the formula bar active and then tap or click the Spelling button (____ tab | Proofing group).

REVIEW

The ____ function sums the numbers in a specified range and then divides the sum by the number of cells with numeric values in the range.

AVERAGE

A ____ is defined as a letter, number, symbol, or punctuation mark in 11-point Calibri font, the default font used by Excel

character

When you decrease a column width to ____, the column is hidden.

0

You can print portions of the worksheet by selecting the range of cells to print and then tapping or clicking the ____ option button in the Print what area in the Print dialog box.

Selection

To ensure that Excel interprets year values the way you intend, use ____.

four-digit years

The default view for a worksheet is ____.

Normal View

To display your worksheet in formula view, press ____.

CTRL+ACCENT MARK

The formula ____ multiples the contents of cell B4 by 18.5. Group of answer choices

18.5*B4

The ____ dialog box can be used to apply formatting that is not available directly on the ribbon.

Format Cells

Use the ____ function to determine the lowest number in a range.

MIN

To override the order of operations, use ____

parentheses

A(n) ____ is text and graphics that print at the bottom of each page.

footer

When you tap or click the ____ button, Excel assigns the next lowest font size in the Font Size gallery to the selected range.

Decrease Font Size

To apply a percent style format to a cell using shortcut keys, press ____.

CTRL+SHIFT+%

The ____ alerts Excel that you are entering a formula or function and not text.

equal sign

As you enter a PMT function, the ____ shows the general form of the function.

ScreenTip

A ____ is an unused column with a significantly reduced width.

column border

To use a name that consists of two or more words in a formula, you should replace any space with the ____ character, as this is a commonly used standard for creating cell names.

underscore

A(n) ____ shows the beginning and ending balances of a loan and the amount of payment that is applied to the principal and interest during each payment period.

amortization schedule

You can define descriptive names for which of the following?

All of the above

cells are cells whose values you cannot change.

:Protected

The ____ examines the formulas in a workbook.

:formula checker

You can use the ____ function to ensure totals are exactly correct.

ROUND

You can have up to ____ data tables in a worksheet.

as many as you want

You can define a range as a data table by using the Data Table command on the ____ menu.

What-If Analysis

While only one value can vary in a one-input data table, the data table can analyze ____ formulas from that one value change.

unlimited

A(n) ____ shows the beginning and ending balances of a loan and the amount of payment that applies to the principal and interest for each year of the loan.

amortization schedule

To undo formats that you assigned, tap or click the Cell Styles button and then tap or click ____ in the Cells Styles gallery.

Normal

If you want to assign a name that is not a text item in an adjacent cell, use the ____ button or select the cell or range and then type the name in the Name box in the formula bar.

Define Name

When a formula fails to pass a rule and background formula checking is enabled, Excel displays a ____ in the upper-left corner of the cell.

small yellow exclamation mark

To select two or more nonadjacent ranges, select the first range, hold down the ____ key and drag through the additional ranges.

CTRL

The ____ function calculates the payment for a loan based on the loan amount, constant payments, and a constant interest rate.

PMT

The ____ function returns the present value of an investment.

PV

If you enter .25 in a cell that is formatted to display percentages, which of the following will display?

.25%

cells are cells whose values you can change at any time.

Unprotected

Cell names can be a maximum of ____ characters.

255

With a ____ data table, you can vary the value in two cells of a worksheet, and Excel calculates the results of a formula.

two-input

The ____ can help add clarity to your formulas by allowing you to assign names to cells.

Name Manager

A cell name cannot begin with a ____.

period

You can add ____ conditional formats to a range.

as many as you like

portions of a worksheet lets you show only the parts of the workbook that a user needs to see.

Hiding

The Borders button (HOME tab | Font group) offers a limited selection of border thicknesses, so to control the color and thickness, you must use the Border sheet in the ____ dialog box.

Format Cells

formatting is assigning a format to all the cells of all the worksheets.

Global

To delete a data table from a worksheet, select the table and press ____.

the DELETE key

Cell references with ____ are absolute cell references.

$

With a ____ data table, you can vary the value in one cell of a worksheet, and Excel calculates the results of a formula.

one-input

You can create a series by dragging the ____.

fill handle

ensures that users do not change values inadvertently that are critical to the worksheet.

Cell protection

To add conditional formatting to a range, click the Conditional Formatting button, and then click ____.

New Rule

The PV value returns the present value of a(n) ____.

annuity

The PMT function has all of the following arguments EXCEPT __

accrued interest

You use a ____ to automate data analyses and organize the answers returned by Excel.

data table