question

Clicking the Create Function box opens the Function Arguments dialog box.

answer

False

question

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

answer

26

question

The Insert Options button lists formatting options.

answer

True

question

Which of the following is the path to the Sum arrow?

answer

(HOME tab I Editing group)

question

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

answer

relative

question

With the accounting number style, a floating dollar sign appears immediately to the left of the first digit in a dollar value with no spaces.

answer

True

question

Which of the following is the path to the Conditional Formatting button?

answer

(HOME tab I Styles group)

question

A company of department may standardize with a specific_______ so that all of their documents have a similar appearance

answer

theme

question

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

answer

(HOME tab I Number group)

question

You can click the Format Cells Dialog Box Launcher to open the Format Cells dialog box.

answer

True

question

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

answer

Insert

question

To paste copied cel contents, you can press the ____keys.

answer

CTRL +V

question

_____ view allows you to create or modify a worksheet while viewing how it will look in printed format.

answer

Page Layout

question

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.

answer

True

question

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

answer

False

question

The most common error when entering a formula is o reference the wrong cell in the formula.

answer

True

question

A ______ is text and graphics that print at the bottom of every page.

answer

footer

question

You can choose from 12 categories or formulas in the Format Cells dialog box.

answer

True

question

While holding down the ALT key, you can select nonadjacent ranges and cells.

answer

False

question

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

answer

False

question

The _____ function displays the highest value in a range.

answer

MAX

question

The range automatically selected by Excel is always correct.

answer

False

question

Which of the following calculations multiples 23 by 0.01?

answer

=23%

question

In designing a worksheet, visual aesthetics should come first.

answer

False

question

Point mode allows you to ____, as shown in the accompanying figure. (see worksheet)

answer

select cells for use in a formula using the mouse pointer

question

The Sum button menu allows you to enter one of fie often-used functions easily into a cell.

answer

True

question

As in algebra, yo can use brackets to override the order of operations Excel follows to perform formula calculations.

answer

False

question

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

answer

False

question

You can use the _____ to check which cells are referenced in the formula assigned to the active cell.

answer

Range Finder

question

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

answer

False

question

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

answer

function

question

When more than one arithmetic operator is involved in a formula, Excel follows the same basic order of ______ that you use in algebra.

answer

operations

question

If you do not assign a format to a cell or cells in a column, the column width will remain _____ characters.

answer

8.43

question

Moving for left to right, the first calculation in the order of operations is negation (-).

answer

True

question

You can use the arrow keys to complete an entry in Point mode.

answer

False

question

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

answer

CTRL+C

question

You cannot format an entire column at once.

answer

False

question

Clicking the _______ opens the Insert Function dialog box.

answer

Insert Function box in the formula bar

question

Which of the following Option buttons gives options for filling cells following a fill operation?

answer

Auto Fill Options

question

The _____ AutoComplete list contains those functions that alphabetically match the letters you type following the equal sign.

answer

Formula

question

Using Point mode to enter formulas often is faster and more accurate than using the keyboard to type the entire formula.

answer

True

question

Excel has more than 400 functions that perform just about every type of calculation you can imagine.

answer

True

question

A _____ is text and graphics that print a the top of each page.

answer

header

question

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

answer

AVERAGE

question

To print a range of cells in the active worksheet, click _____ in the Settings area in the Print gallery.

answer

Print Selection

question

Which of the following happens when you enter the formula =G15 to the active cell?

answer

Excel assigns the value in cell G15 to the active cell

question

When you click the Decrease Font Size button, Excel assigns the next highest font size in the Font Size gallery.

answer

False

question

Excel automatically appends the ______ to complete the AVERAGE function when you click the Enter box or press the ENTER key.

answer

right parenthesis

question

The default font for the Basis theme is different than the default font for the Office theme.

answer

True

question

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

answer

double-click or double-tap