Review Modules 1 and 2 Excel

This bar located at the bottom of the Excel window provides information about the worksheet.

• Ribbon bar

• Quick Access toolbar

• Formula bar

• Status bar

Which of the following terms describes how a cell appears (font, font color, background fill, etc.) based on the value of the cell?

• Conditional formatting

• Relative formatting

• Cell formatting

• Document formatting

Using the image at the left as an example, Excel always selects the correct range.

• True

• False

Answer explanation

In most cases, Excel will determine the range correctly. In the example, you do not want Excel to include the Total (B8) in the average calculation.

Select two of the below responses that Excel spell checker (Review tab > Proofing group) will allow you to do.

• Correct numeric values

• Check the spelling

• Add words to the dictionary

• Add additional formatting

This version is useful for debugging a worksheet which allows the user to display and print formulas and functions. A user can assess this version by CTRL Tilda (~).

• Values version

• Formulas version

• Print version

• Text version

Which of the following terms describes the small black square in the lower-right corner of the active cell or active range? It turns into a thin cross-hair when selected.

• square handle

• copy handle

• fill handle

Which of the following formulas multiplies 23 X 5?

• =23-5

• =23*5

• =23+5

• =23/5

When Excel follow the order of operations, the formula =8*3+2 = ?

• 13

• 26

• 40

• 48

Answer explanation

Excel will always do multiplication or division first before addition and subtraction. If a calculation is placed in parentheses ( ), Excel will perform first what is in parentheses ( ); then the outside calculation.

With this example, Excel multiplied 8 * 3 first which = 24. Then Excel added 24 + 2 which = 26.

An Excel user wants the total sales numbers to look different (font, font color, background fill) for each month that exceeds $5,000. What Excel feature will the user use?

• Spell checker

• Point mode

• Formulas version

• Conditional formatting

This function sums the numbers in a specified range and then divides by the sum by the number of cells with numeric values in the range.

• DIVSUM

• RANGEAVG

• AVERAGE

• MAX