Excel Functions and Formulas

By default, all cell references are _________ references. 

• Absolute
• Relative

If you don't want a cell reference to change when copied to other cells, use _________ references

• Absolute
• relative

What does the Average formula return?

• Returns the lowest argument.

• Returns the middle argument.

• Returns the three highest arguments.

• Returns the mean of all its arguments.

What does the Max function do?

• Returns the highest three values in a set of values and ignores text.

• Returns the largest value in a set of values and ignores text.

• Returns the text that you are searching for.

• Returns the smallest value in a set of values and ignores text.

What does the Min function return?

• Returns the smallest three numbers form a set and ignores text.

• Returns the smallest value in a set of values and ignores text.

• Returns the largest three numbers form a set and ignores text.

• Returns the largest value in a set of values and ignores text.

What does the Countif function return?

• Counts the number of cells within a range that meets the given condition.

• Counts the number of words within a range that meets the given condition.

• Counts the number of columns within a range that meets the given condition.

• Counts the number of letters within a range that meets the given condition.

Excel will display _______________________ if the cell is not wide enough.

• ******

• ^^^^^

• ######

• >>>>>

What is the syntax for the sum function in excel that sums a range from B1 to E1?

• Sum(B1:E1)

• Sum( B1:E1)=

• =( B1:E1)Sum

• =Sum(B1:E1)

For multiplying numbers in A1 AND B1,you use the following formula

• =A1/B1

• =A1*B1

• A1%B1

• A1*B1

Formula =A3+B4 is copied from C1 to D1. The changed formula in D1 is

• =A4+B5

• =A3+B4

• =B4+B5

• =B3+C4