Excel

true or false: When text is longer than the width of a column, Excel displays the overflow characters in adjacent cells to the right as long as those adjacent cells contain no data.

true

true or false: You can nest IF functions as deep as you want, but after you get beyond a nest of three IF functions, the logic becomes difficult to follow.

true

AND, OR, and NOT are called ____________________ operators

exact match

true or false: An asterisk (*) following a cell reference in a formula is the arithmetic operator that directs Excel to perform the division operation.

false

true or false: The arithmetic operator, ^, directs Excel to perform the division operation

false

true or false: A thin red border indicates the active cell.

false

true or false: As in algebra, you can use brackets to override the order of operations Excel follows to perform formula calculations.

false

true or false: You can replace a formula with its function so it remains constant.

false

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

relative

true or false: With bar charts, you can drag the bar in the chart in one direction or another to change the corresponding value in the worksheet.

true

true or false: A date stamp shows the date a workbook, report, or other document was created or the time period it represents.

true

true or false: Excel recognizes the following as text: 401AX21, 921-231, 619 321, 883XTY.

true

true or false: The equal sign (=) precedes a formula.

true

true or false: When Excel cannot calculate a formula, it displays an error message in a cell.

true

Clicking the ____ box completes an entry

enter

Error messages begin with the ____ symbol

#

If formulas located in other cells reference cells in a deleted row or column, Excel does not adjust these cell references but instead displays the ____ error message.

#REF!

Which of the following are formatting symbols?

$,%

When you first enter text, its angle is ____ degrees, and it reads from left to right in a cell.

0

In Excel, a number can contain the characters ____.

0 1 2 3 4 5 6 7 8 9 + - ( ) , / . $ % E e

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

26

Which of the following patterns extends the fill series to 575, 550, 525?

625, 600

Which of the following formulas contains an absolute cell reference?

=$b$4

The ____ area on the status bar includes six commands as well as the result of the associated calculation on the right side of the menu.

AutoCalculate

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

IF

The ____ function displays the highest value in a range.

MAX

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

NOW

Cell references in a formula are called ____.

assumptions

A(n) ____________________ conveys a visual representation of data

chart

You should use a ____ chart to compare values side by side, broken down by category.

clustered column

The range of cells receiving the content of copied cells is called the ____.

destination area

Using the mouse to move or copy cells is called ____.

drag and drop