How can we help?

You can also find more resources in our Help Center.

50 terms

The formulas version verifies that you entered formulas, rather than ____, in formula-based cells.

Numbers

____ means that the width of the column will be increased or decreased so the widest entry will fit in the column.

Best Fit

All of the following are valid Excel arithmetic operators except___.

>

In Excel, a number can contain the characters __________.

All of the above

Which comparison operator means "not equal to"?

<>

__________ are a collection of worksheets.

Workbooks

A formula using the ____ cell reference B20 instructs Excel to adjust the cell reference as it copies it to the destination area.

Relative

The arithmetic operator, ^, directs Excel to perform the division operation.

False

If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which the formula depends.

Goal Seeking

If you know the result you want a formula to produce, you can use ____ to determine the value of a cell on which the formula depends.

Sheet1

The ____ function is useful when you want to assign a value to a cell based on a logical test.

IF

Using Excel to scrutinize the impact of changing values in cells that are referenced by a formula in another cell is called ____.

What-if Analysis

The AVERAGE function requires that the argument (the range) be included within parentheses before the function name.

False

The ____ of the worksheet shows the actual formulas you have entered, rather than the resulting values.

Formulas Version

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

26

Which of the following is not a valid format symbol?

semi-colon (;)

The following entries are considered text: 401AX21, 921-231, 619 321, 883XTY

True

To identify a cell, specify the row number first, followed by the column letter.

False

Excel does not allow the contents of a cell to be aligned vertically.

False

Error messages always begin with what symbol?

#

Dividing a cell into more than one cell is called __________.

Splitting

A __________ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.

range

If you drag the fill handle to the left or up, Excel will ____ the series rather than ____ the series.

Dec/Inc

Excel displays #REF! in a cell to indicate the cell is a cross reference.

False

To toggle between the values version and the formulas version of a worksheet, hold down the ____ key.

CTRL key while pressing the ACCENT MARK (`)

In the accompanying figure, if you enter 90 in the Degrees box in the Orientation area, the text will appear ____.

vertically and read from bottom to top in the cell

When assigned to a cell, the ____ function returns a number that corresponds to the system date and time beginning with December 31, 1899.

NOW

A(n) ____ IF function is one in which the action to be taken for the true or false case includes yet another IF function.

Nested

Cell references in formulas must be entered in uppercase, and spaces cannot be added before or after arithmetic operators.

False

Text entered in a cell cannot be realigned.

False

When a formula is copied, Excel adjusts the cell references so the new formulas contain references corresponding to the new location and performs calculations using the appropriate values.

True

Combining two or more cells together is called __________ cells.

Merging

To start a new line in a cell, press ____ after each line, except for the last line, which is completed by clicking the Enter box, pressing the ENTER key, or pressing one of the arrow keys.

ALT+ENTER

A Pie chart with one or more slices offset is called a(n) ____.

Exploded Pie Chart

When using conditional formatting, if the condition is true, then Excel applies the formatting.

True

Copying, deleting, inserting, and moving ranges of cells have the potential to ____.

Render a worksheet useless

A(n) __________ chart is drawn on the same worksheet as the data.

Embedded

When you set up a worksheet, you should use cell references in formulas whenever possible, rather than ____ values.

constant

The NOW function is a date and time function.

True

If a major error is made when typing data into a cell, click the Cancel box in the formula bar or press the ESC key to erase the entire entry, and then reenter the data from the beginning.

True

When you complete a copy, the values and formats in the destination area are replaced with the values and formats of the source area.

True

When you change a value on which a chart is dependent, Excel ____.

immediately redraws the chart based on the new value

If a cell has a two-digit year of 32, Excel automatically changes it to a four-digit year of ____.

1932

Saving the workbook frequently is important for the following reason:

if you lose power, the worksheet could be lost

The paste operation is one of many operations affected by an absolute cell reference.

False

If the contents of cells copied using the fill handle are 430 and 410, then the next three values of an extended series are: 400, 390, 370.

False

Regardless of the length and complexity of a formula, using Point mode to enter formulas always is slower and less accurate than using the keyboard.

False

Excel can display characters in only three font colors: black, red, and blue.

False

If you accidentally delete valuable data, immediately click the Undo button on the Quick Access Toolbar.

True

Excel converts all the formulas from ____.

lowercase to uppercase