Excel Module 2 Test Review Lesson

Excel Module 2 Test Review Lesson

by Kecia Ferguson

Fill in the Blank

A pre-written formula that is built into Excel is ____

(formula, function, factor, feature)

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 Blank

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

related

relative

pasted

alternative

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

Fill in the Blank

What kind of finder is used to check which cells are referenced in the formula assigned to the active cell?

(Range, Formula, Calculation, Function)

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 Blank

What is the text and graphics that print at the top of each page?

(Header, Footer, Topper, Crown)

Multiple Choice

What is the default view in Excel called?

• Normal

• Values

• Standard

• Basic

Fill in the Blank

What is the text and graphics that print at the BOTTOM of every page called?

(toe, margin, footer, stopper)

Fill in the Blank

According to the order of operations,

8 * 3 + 2 = ?

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