EXCEL 2

All of the following are valid Excel arithmetic operators except ___

>

You can click the __ button to undo an automatic correction.

Auto Correct Options

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

Auto Fill Options

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

Footer

The ____ Auto Complete list contains those functions that alphabetically match the letters you type following the equal sign.

Formula

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

Function

A ____ is text and graphics that print at the top of each page.

Header

When designing a worksheet, which steps should be taken to ensure that functional consideration supersede visual aesthetics?

Identification of how to format various elements of the worksheet

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

Insert

Which of the following is a method of entering functions?

Keyboard, touch gestures, or pointer The Sum menu The insert function in the formula bar The name box area in the formula bar

The ____ function displays the highest value in a range.

Max

The ____ function determines the lowest number in a range.

Min

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

Print Selection

A company or department may standardize with a specific ___ so that all of their documents have a similar appearance.

Theme

Using the Excel spell checker, you can____.

Check the spelling of words in a selected range Add words to the dictionary

Which of the following happens when you enter the formula =G15 into a cell?

Excel assigns the value in cell G15 to the active cell

When you decrease the row height to ____, the row is hidden.

0

The ____ button lists error-checking options following the assignment of an invalid formula to a cell.

Trace Error

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 multiplies 23 by 0.01?

=23%

Which of the following are valid formulas?

=3^4 =H3/H11 =11+9 =22-F15

The ____ button assigns a fixed dollar sign to the numbers in a selected range, with the dollar sign to the far left with spaces between it and the first digit in the cell.

Accounting number format

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

Average

A ____ Circular reference occurs when a formula in a cell refers to another cell or cells that include a formula that refers back to the original cell.

Indirect

The default view in Excel is called ___ view.

Normal

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

Page Layout

You can use the ___ to check which cells are references in the formula assigned to the active cell.

Range Finder

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

Relative

Excel automatically appends the _____ to complete the average function when you click the enter box or press the enter key.

Right Parenthesis

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

operations