CS_100 Lab quiz

Which function is used to find the smallest value in a range of numbers?

• MAX

• SUM

• MIN

• MODE

What does the MAX function return?

• The most frequently occurring value

• The smallest value in a range

• The largest value in a range

• The average of all values

Which function calculates the arithmetic mean of a data set?

• MEDIAN

• MODE

• MIN

• None of the above

If you want to count the number of cells in a range that are greater than 10, which function would you use?

• COUNT

• COUNTIF

• SUMIF

• MODE

If the 'COUNTIF' function is used with the condition ">5", what will it do?

• Count all numbers greater than 5

• Sum all numbers greater than 5

• Count all numbers less than 5

• Find the average of all numbers

If you want to find out how many products were sold only in January, which function would you use?

• COUNTIF

• SUMIF

• MAX

• MEDIAN

What does the 'COUNT' function specifically count in a range?

• Only text values

• Only blank cells

• Only numerical values

• Both text and numerical values

How many arguments does the 'SUMIF' function require at a minimum?

• 1

• 2

• 3

• 4