Font size
WorksheetsFunctions in Excel
Total questions: 22
Worksheet time: 10mins
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
Function used to find the largest number in the cell range B4 through J4.
=MAX(B4:J4)
=LARGEST(B4:J4)
=MAX(B4-J4)
@MAX(B4:J4)
Function used to find the smallest number in the cell range B2 through H4
=MIN(B2:H4)
@MIN(B2:H4)
=SMALLEST(B2:H4)
=MIN(B2-H4)
Function used to find the average of the cell range H2 through J2.
@AVE(H2:J2)
=AVE(H2:J2)
=AVERAGE(H2:J2)
=AVERAGE(H2+J2)
Write the formula to get the Total of all orders
(a)
Write the formula to get the Average
(a)
Write the formula to get the Highest Order
(a)
Write the formula to get the Lowest Order
(a)
Write the formula to count the number of Cookie Types
(a)
Using the formula =SUM(B3:B12), the answer is (a)
Using the formula =MAX(B3:B12), the answer is (a)
Using the formula =MIN(B3:B12), the answer is (a)
Using the formula =COUNT(B3:B12), the answer is (a)
