Advanced Functions and Formulas

What would be a correct formula for SUM in excel?

• =SUM(B3-B9)

• =SUMB3+B9

• =SUM(B3:B9)

• =SUM[B3:B9]

Which symbol must all formulas begin with?

• +

• =

• /

• -

What text formula joins the text from two or more cells?

• conjoin

• concoct

• concentrate

• concatenate

Which formula will calculate the average of data in a given range?

• AVEDATA

• AVERAGE

• AVERAGEIF

• AVERAGING

Which response best completes the following statement: A formula is used to ____________________.

• add data

• find averages

• make presentations

• perform calculations

Excel follows the ____________________ and first adds the values inside the parentheses.

• Order of Formulas

• Formula Guidelines

• Order of Operations

• Operation Guidelines

How would you write a cell reference formula for cell A1 subtracted by Cell C3?

• A1-C3

• C3-A1

• =A1-C3

• =C3-A1

What is the function of the caret (^) symbol?

• expiration

• extradition

• expedition

• exponentiation

These are used to combine ranges of cells for calculations.

• Text Operators

• Arithmetic Operators

• Reference Operators

• Comparison Operators

These are used to execute basic mathematical operations, to combine numbers, and to produce numeric results.

• Text Operators

• Arithmetic Operators

• Reference Operators

• Comparison Operators