Modules 5.1 and 5.2 Review

Excel uses standard operators for formulas, match the operator with the correct term: (1 point)

• Multiplication

• ^

• Exponents

• /

• Addition

• *

• Subtraction

• +

• Division

• -

All formulas in Excel must begin with an ____________ sign. This is because the cell contains, or is equal to, the formula and the value it calculates.

• equals

• plus

• minus

• asterisk

While you can create simple formulas in Excel using numbers (for example, =2+2 or =5*5), most of the time you will use cell addresses to create a formula. This is known as making a ___ ____.

• formula

• headache

• math equation

• cell reference

Using cell references will ensure that your formulas are always accurate because you can change the value of referenced cells without having to rewrite the formula.

• True

• False

If the result of a formula is too large to be displayed in a cell, it may appear as ________ instead of a value. This means the column is not wide enough to display the cell content. Simply increase the column width to show the cell content.

• #######

• ERROR

• NULL

• #####VALUE

Excel will display ________ if a column is not wide enough to display the cell content. Simply increase the column width to show the cell content.

• A. pound signs (########)

• B. left parentheses (((

• C. exclamation mark !!!!

• D. percent sign %%%%%%

Excel will not always tell you if your formula contains an error, so it's up to you to check all of your formulas.

• True

• False

The ________ is the small square at the bottom-right corner of the selected cell(s).

• fill handle

• formula handle

• paste handle

• undo handle

Absolute references change when a formula is copied to another cell. Relative references, on the other hand, remain constant no matter where they are copied.

• True

• False

By default, all cell references are (a)   references. When copied across multiple cells, they change based on the relative position of rows and columns.

• constant

• relative

• absolute

• mixed