Excel Functions Quiz

What function would you use to total your monthly expenses?

• MIN

• MAX

• SUM

• AVERAGE

Which function finds the highest value in a set of numbers?

• SUM

• COUNT

• MAX

• MIN

What does the AVERAGE function do?

• Rounds numbers

• Finds the maximum

• Adds values and divides counts

• Counts the entries

What is the purpose of a relative cell reference?

• It adjusts automatically when copied

• It stays constant when copied

• It only counts numbers

• It rounds numbers

What does the MIN function return?

• The total count

• The highest value

• The lowest value

• The average value

What is the function of the COUNT function?

• Adds values

• Counts numerical entries

• Finds the average

• Rounds numbers

What does the PERCENTAGE function calculate?

• The total of numbers

• The mean of numbers

• The % of a number

• The highest value

What is the purpose of the formula bar in Excel?

• To enter and edit formulas

• To round numbers

• To display the highest value

• To count entries

What happens to a formula with an absolute cell reference when copied?

• It adjusts automatically

• It counts entries

• It stays constant

• It rounds numbers

What does the Fill Handle do in Excel?

• Finds averages

• Counts numbers

• Rounds values

• Copies formulas