WorksheetsExcel Function and Formulas
Total questions: 40
Worksheet time: 30mins
Imagine that the function =COUNT(C4:D14) has been applied to the sheet, what will it return as the answer?
11
22
14
28
A(n) _________ is a predefined formula that is built into EXCEL.
Which are the three essential elements to enter a function?
Equal sign, function name and cell reference.
Function name, data and cell reference.
Equal sign, cell reference and formula.
=C4+C5
What is the result?
32
12
17
The cash is missing for 'Computers For Dummies'. Write a formula to calculate it.
The store manager changed the content of cell B4 to Flying Boys and cell B5 to Middle way. What effect will the changes have on the content (value) of cell D16?
The value in cell D16 will increase.
The value in cell D16 will decrease.
The value in cell D16 will remain the same.
The value in cell D16 will double.
Look at the data table below carefully. Which cell contents will change if you change the price of Internet for Dummies from $20.00 to $25.00?
C15 and D16
C16 and D16
D15 and D16
C15, C16, D15, D16
SUM, AVERAGE, IF, MIN and MAX are examples of _______.
user-defined functions
online functions
table functions
predefined functions
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)
Write the function to get the Total of all orders
(a)
Write the function to get the Average
(a)
Write the function to get the Highest Order
(a)
Write the function to get the Lowest Order
(a)
Write the function to count the number of Cookie Types
(a)
Using the function =SUM(B3:B12), the answer is (a)
Using the function =MAX(B3:B12), the answer is (a)
Using the function =MIN(B3:B12), the answer is (a)
Using the function =COUNT(B3:B12), the answer is (a)
1) What is the correct cell range for the part of the cell colored yellow?
a) B:21, C:28, D:22, E:26 and F:25.
b) row 15, column F
c) F4:F5
d) B15:F15
Values are aligned to the _______ in a cell.
right
left
center
bottom
A Column goes…
Verticle
horizontal
Towards row
Displays the name or location of the active cell
Formula bar
Name box
Column
Row
From the options below all of them are spreadsheets except one.
Which one is a presentation software?
a) Open Office Impress
b) Zoho sheet
c) Microsoft Excel
d) Apple Numbers
How many values and labels are in the picture shown?
a) 10 values, 25 labels
b) 30 values, 16 labels
c) 25 values, 10 labels
d) 16 values, 30 labels
Which formula has been entered into cell D10?
=2*£0.25
=D10*C10
=B10*C10
Which function is being used in cell D11?
SUM(D10 to D2)=
=SUM(D2,D10)
=(D2:D10)SUM
=SUM(D2:10)
What is the cell range for A?
B2 to B6
A4:A5
A4,A5
A4 to A5
Looking at the image, which of them has the highest average?
Ian Ventor
Fi Ting
Mark Sman
Eliza Body
Looking at the image, using a formula, how would you calculate the average of the cell range B5 to D5?
(a)
