Excel Ch. 2 Review

Pixel

A ___ is a dot on the screen that contains a color.

Theme

A ___ is a predefined set of colors, fonts, chart styles, cell styles, and fill effects.

Function

A ____ is a prewritten formula that is built into Excel.

Blank

A ______ cell in Excel has a numerical value of zero.

True

A floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces. (True or False)

Circular Reference

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

False

An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation (True or False)

False

As in algebra, you can use brackets to override the order of operations Excel follows to perform the formula calculations. (True or False)

True

Formatting that appears only when the value in a cell meets conditions that you specify is called conditional formatting. (True or False)

>

Is not a valid excel arithmetic operator.

Division

The / arithmetic operator indicates ____.

True

The Insert Options buttons lists formatting options. (True or False)

True

The Percent Style button instructs Excel to display a value as a percentage, determined by multiplying the cell entry by 100, rounding the result to the nearest percent, and adding a percent sign. (True or False)

True

The Sum button menu allows you to enter on of five often-used functions easily into a cell. (True or False)

Insert

The ___ Option button lists formatting options following an insertion of cells, rows, or columns.

MAX

The ___ function displays the highest value in a range.

AVERAGE

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

Trace Error

The ____ Options button lists error-checking options following the assignment of an invalid formula to a cell.

Excel assigns the value in cell G15 to the active cell

What happens when you enter the formula =G15 into a cell?

Home tab - Editing Group

What is the path to Sum Button?

26

When Excel follows the order of operations, the formula, 8*3+2, equals ____.

CTRL+C

To copy cell contents, you can select the cell and then press the ___ keys.

True

Excel has more than 400 additional functions that perform just about every type of calculation you can imagine. (True or False)

Spell Checker

Excel includes a _____ you can use to check a worksheet for spelling errors.

CTRL+V

To paste copied cell contents, you can press the ____ keys.

Print Selection

To print a range of cells in the active worksheet, click ____ in the Settings area in the Print gallery, as shown in the accompanying figure.

Double Click

To set row height to best fit, _____ the bottom boundary of the row heading.

ALT+ENTER

To start a new line in a cell, press the ____ keys.

False

To use Range Finder to verify that a formula contains the intended cell references, click the cell with the formula you want to check. (True or False)

Rows

Worksheet ___ typically contain items analogous to items in a list.

True

You can choose a category in the Number tab in the Format Cells dialog box and then select the number of decimal places, whether or not a dollar sign should be displayed, and how negative numbers appear. (True or False)

ESC (Escape)

You can press _____ key to quit rangefinder.

F8

You can select a range using the keyboard by pressing the ___ key and then an arrow key.

Range Finder

You can use the ____ to check which cells are reference in the formula assigned to the active cell.

False

You cannot format an entire column at once. (True or False)

Double-Click

You should ____ a function name in the Formula AutoComplete list to select the function.

Hiding Cells

____ is a technique that can be used to conceal data that might not be relevant to a particular report or sensitive data that others should not see.

Formulas

Always take time to check the ______ of a worksheet before submitting it to your supervisor.

False

Best fit means that the width of the column will be increased or decreased by a percentage you specify. (True or False)

Addition and Subtraction

In the order of operations, the last operation Excel performs is _____.

Formula

One of the reasons Excel is such a valuable tool is that you can assign a ____ to a cell, and Excel will calculate the result.

Accounting Number Format

The ____ displays numbers with a fixed dollar sign to the left of the number, a comma every three positions to the left of the decimal point, and displays numbers to nearest cent.

MIN

The ____ function determines the lowest number in a range.

Relative

The adjusted cell references in a copied and pasted formula are called ____ references.

False

The arithmetic operator,^, directs Excel to perform the division operation. (True or False)

True

The equal sign (=) precedes a formula (True or False)

False

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery. (True or False)

0

When you decrease the row height to ____, the row is hidden.

20xx

When you enter a two-digit year that is less than 30, Excel changes the year to _____.

Home tab - Number group

Which of the following is the path to the Comma Styles button?