Excel Module 2 Test Review Lesson

Excel Module 2 Test Review Lesson

by Kecia Ferguson

Fill in the Blanks

Multiple Choice

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

• placement

• operations

• positioning

• selections

Multiple Choice

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

• Excel recalculates all formulas in the worksheet

• Excel assigns the sum of the values in the previous 15 cells to the active cell

• Excel assigns the value in cell G15 to the active cell

• Nothing; =G15 is an invalid formula

Fill in the Blanks

Multiple Choice

The ____ function displays the highest value in a range.

• MIN

• SUM

• MAX

• AVERAGE

Multiple Choice

The ____ function determines the lowest number in a range.

• LOW

• BASE

• LEAST

• MIN

Multiple Choice

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.

• DIVSUM

• RANGEAVG

• AVERAGE

• MAX

Multiple Choice

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.

• Comma Style Format

• Accounting Number Format

• Percent Style Format

• Currency Style Format

Fill in the Blanks

Multiple Choice

What is the default view in Excel called?

• Normal

• Values

• Standard

• Basic

Fill in the Blanks

Multiple Choice

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

• Normal

• Page Layout

• Page Break Preview

• Full Screen

Multiple Choice

The equal sign (=) precedes a formula.

• TRUE

• FALSE

Multiple Choice

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

• TRUE

• FALSE

Multiple Choice

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

• TRUE

• FALSE

Multiple Choice

The range automatically selected by Excel is always correct.

• TRUE

• FALSE

Multiple Choice

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

• TRUE

• FALSE

Multiple Choice

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

• TRUE

• FALSE