Y7 Chapter 5: Data mining revision

Which error is obtained when a formatted number does not fit within a cell?

• #####

• #DIV/0

• #DIV@

• #VALUE!

This function adds all of the values of the cells in the argument

• SUM

• AVERAGE

• MAX

• MIN

What does the AVERAGE function do?

• Returns the median number in a set of values

• Returns the average number in a set of values

Which functioning Excel tells how many numeric entries are there ?

• NUM

• COUNT

• SUM

• None of these

Which formula finds the minimum value among a range of cells from A4, A5, A6, A7 and A8 in MS Excel?

• =MIN(A4 to A8)

• =MIN(A4-A8)

• =MIN(A4:A8)

• All of the above

B2:B6 is called?

• cell address

• sum formula

• cell range

The Count column found on the Grade Count table, can be computed by this function.

• counta

• countif

• count

• countblank

SUM, AVERAGE, IF, MIN and MAX are examples of _______.

• user-defined functions

• online functions

• table functions

• predefined functions

What´s the difference between a formula and a function?

• There is no difference

• Functions are more complicated than formulas

• Formulas are designed by the user and functions are predefined in Excel

• They both start with the =

Looking at the data in the picture, which function can be used to find the youngest and oldest athlete?

• MIN & AVERAGE

• MAX & AVERAGE

• MIN & MAX

• COUNTA & MAX