Spreadsheet Functions Quiz

Which function is used to find the maximum value in a range of cells?

• =Max(Range)

• =Min(range)

• =Counta(range)

• =Average(range)

What does the =Counta function do?

• Finds the maximum value in a range

• Counts the number of cells with data in them

• Finds the minimum value in a range

• Counts the number of cells that meet a condition

Which function would you use to count the number of cells that meet a specific condition?

• =Max

• =Min

• =CountIF

• =Average

What does the =IF function do?

• Finds the maximum value in a range

• Counts the number of cells with data in them

• Finds the average of the cells selected

• Checks if a condition is met and returns "Yes" or "No"

What is a "cell" in a spreadsheet?

• A set of cells

• A single block in a spreadsheet

• A true or false statement

• A function

What is a "range" in a spreadsheet?

• A single block in a spreadsheet

• A set of cells

• A true or false statement

• A function

What is a "condition" in a spreadsheet?

• A single block in a spreadsheet

• A set of cells

• A true or false statement

• A function

Which function is used to find the minimum value in a range of cells?

• =Max(Range)

• =Min(Range)

• =Counta(Range)

• =Average(Range)

What does the =Sum function do?

• Finds the maximum value in a range

• Counts the number of cells with data in them

• Adds up all the numbers in a range

• Finds the average of the cells selected

Which function would you use to find the average value of a range of cells?

• =Max

• =Min

• =Counta

• =Average