Excel Ch.2 Study Guide for ITE 115

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

(HOME tab I Editing group)

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

(HOME tab I Number group)

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

(HOME tab I Styles group)

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

26

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

8.43

Which of the following calculations multiples 23 by 0.01?

=23%

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.

AVERAGE

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

Auto Fill Options

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

CTRL +V

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

CTRL+C

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

False

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

False

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

False

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

False

In designing a worksheet, visual aesthetics should come first.

False

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

False

The range automatically selected by Excel is always correct.

False

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.

False

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

False

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

False

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

False

You cannot format an entire column at once.

False

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

Formula

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

double-click or double-tap

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

footer

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

function

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

header

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

operations

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

relative

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

right parenthesis

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

select cells for use in a formula using the mouse pointer

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

theme

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

Excel assigns the value in cell G15 to the active cell

The Insert Options button lists formatting options.

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.

True

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

True

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

True

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

True

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

True

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.

True

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

True

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

True

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

Insert

Clicking the _______ opens the Insert Function dialog box.

Insert Function box in the formula bar

The _____ function displays the highest value in a range.

MAX

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

Page Layout

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

Print Selection

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

Range Finder

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

True

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

True