Which Excel function returns the smallest value in a set of values?
a) MAX
b) AVERAGE
c) MIN
d) COUNT
What does the COUNT function in Excel do?
a) Counts the number of cells that contain numbers.
b) Counts the number of all cells.
c) Counts the number of empty cells.
d) Counts the number of cells that contain text.
Which function in Excel is used to calculate the average of a group of numbers?
a) SUM
b) MAX
c) MIN
d) AVERAGE
Which Excel function returns the largest value in a set of values?
a) SUM
b) MAX
c) MIN
d) COUNT
To find the total of a range of cells in Excel, you would use:
a) AVERAGE
b) COUNT
c) SUM
d) MIN
If you want to count the number of cells in a range that are not empty, which function would you use?
a) COUNT
b) COUNTA
c) COUNTBLANK
d) COUNTIF
Which function would you use to determine the highest score in a list of test results?
a) MIN
b) AVERAGE
c) MAX
d) SUM
To find the average of the values in cells A1 through A10, you would use:
a) =SUM(A1)
b) =AVERAGE(A1)
c) =MIN(A1)
d) =MAX(A1)
Which function can be used to count the number of numeric entries in a range?
a) COUNT
b) SUM
c) AVERAGE
d) MIN