1) Returns the largest value in the range B2 to B8 a) =SUM(B2:B8) b) =MIN(B2:B8) c) =MAX(B2:B8) d) =AVERAGE(B2:B8) 2) Returns the smallest value in the range B2 to B8 a) =SUM(B2:B8) b) =AVERAGE(B2:B8) c) =COUNTIF(B2:B8,"Pass") d) =MIN(B2:B8) 3) Returns the total adding up the values in the range B2 to B8 a) =AVERAGE(B2:B8) b) =SUM(B2:B8) c) =MIN(B2:B8) d) =MAX(B2:B8) 4) Returns the mean average of the values in the range B2 to B8 a) =MIN(B2:B8) b) =SUM(B2:B8) c) =MAX(B2:B8) d) =AVERAGE(B2:B8) 5) Returns the number of values in the range B2 to B8 a) =COUNT(B2:B8) b) =AVERAGE(B2:B8) c) =MIN(B2:B8) d) =MAX(B2:B8) 6) Returns the number of values in the range B2 to B8 which contain the word "Pass" a) =SUM(B2:B8) b) =MIN(B2:B8) c) =COUNT(B2:B8) d) =COUNTIF(B2:B8,"Pass")

Excel Functions Quiz Show

Print
Embed

Leaderboard

Visual style

Options

Switch template

Continue editing: ?