NEW
Font size
WorksheetsMastering Excel Formulas
Total questions: 20
Worksheet time: 10mins
What is the result of =5+10 in Excel?
10
5
20
15
Which function is used to add a range of cells in Excel?
COUNT
AVERAGE
MAX
SUM
If A1=20 and A2=5, what is the result of =A1/A2?
10
4
5
3
What does the formula =RANK(A1, A1:A10) do?
It calculates the average of the values in A1:A10.
It counts the number of values in A1:A10.
It returns the rank of the value in A1 among the values in A1:A10.
It returns the highest value in the range A1:A10.
What is the result of =15-7 in Excel?
8
7
10
9
Which of the following is the correct syntax for the SUM function?
SUM(number1, number2, ...)
SUM(number1; number2)
SUM(number1 + number2)
SUM(number1, number2, number3)
If B1=30 and B2=10, what is the result of =B1*B2?
300
100
400
200
What is the average of the numbers 10, 20, and 30 in Excel?
15
25
35
20
How do you calculate the rank of a number in a list in Excel?
Sort the list and find the median value
Use the RANK function: =RANK(number, ref, [order])
Use the AVERAGE function: =AVERAGE(number, ref)
Count the total number of items in the list: =COUNT(ref)
What is the result of =A1+A2+A3 if A1=2, A2=3, and A3=5?
12
10
7
8
Which formula would you use to find the sum of cells A1 to A5?
=SUM(A1:A5)
=SUMMATION(A1:A5)
=ADD(A1:A5)
=TOTAL(A1:A5)
If C1=100 and C2=4, what is the result of =C1/C2?
30
50
20
25
What does the formula =RANK(50, A1:A10) return if 50 is the highest number?
0
10
1
5
What is the result of =25-10 in Excel?
20
5
15
10
Which function would you use to calculate the average of a range of cells?
AVERAGE
SUM
MAX
COUNT
If D1=12 and D2=3, what is the result of =D1*D2?
36
9
24
15
What is the result of =SUM(1, 2, 3, 4, 5)?
10
12
20
15
How do you perform division in Excel?
Use the formula '=A1*B1' to multiply values in Excel.
Click on the 'Insert' tab to perform division.
Use the formula '=A1/B1' to divide values in Excel.
Use the formula '=A1+B1' to add values in Excel.
What does the formula =RANK(30, B1:B10) do?
It returns the highest value in the range B1:B10.
It counts how many values are greater than 30 in B1:B10.
It calculates the average of the values in B1:B10.
It returns the rank of 30 among the values in the range B1:B10.
If E1=45 and E2=15, what is the result of =E1/E2?
5
4
3
2
