Excel Ch.2 Study Guide For ITE 115

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

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

The Insert Options button lists formatting options.

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

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

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.

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

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

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

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

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

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

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

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.

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

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

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

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

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

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

The _____ function displays the highest value in a range.

The range automatically selected by Excel is always correct.

Which of the following calculations multiples 23 by 0.01?

In designing a worksheet, visual aesthetics should come first.

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

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

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

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

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

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.

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

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

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

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

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

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

You cannot format an entire column at once.

Clicking the _______ opens the Insert Function dialog box.

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

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

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

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

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

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.

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

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

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

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

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

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