WorksheetsY9-BODMAS and Excel Quiz
Total questions: 25
Worksheet time: 13mins
What does BODMAS stand for?
Brackets, Orders, Division, Multiplication, Addition, Subtraction
Brackets, Operations, Division, Multiplication, Addition, Subtraction
Brackets, Orders, Division, Multiplication, Addition, Summation
Brackets, Orders, Division, Addition, Multiplication, Subtraction
Which operator represents multiplication in Excel?
/
*
-
+
What is the result of the formula =(5+3)*2?
10
12
8
16
Which of the following is NOT a basic operator in Excel?
-
+
!
/
What is the first step in the calculation =(10+5)*2-8/4?
2
30
15
28
What is the syntax of the IF function in Excel?
=IF(VALUE_IF_TRUE, CONDITION, VALUE_IF_FALSE)
=IF(VALUE_IF_FALSE, VALUE_IF_TRUE, CONDITION)
=IF(CONDITION, VALUE_IF_FALSE, VALUE_IF_TRUE)
=IF(CONDITION, VALUE_IF_TRUE, VALUE_IF_FALSE)
In the formula =IF(A1>50, 'PASS', 'FAIL'), what does 'PASS' represent?
Operator
Value if false
Value if true
Condition
What is the result of the formula =IF(B2>=60, 'MERIT', 'STANDARD') if B2 is 70?
MERIT
STANDARD
PASS
FAIL
Which of the following formulas uses a nested IF function?
=IF(B2>=80, 'DISTINCTION', IF(B2>=50, 'PASS', 'FAIL'))
=IF(B2>=50, 'PASS', 'FAIL')
=IF(B2<100, B2*1.1, B2)
=IF(D4='YES', 10, 0)
What is the result of the formula =((20-5)^2)/5?
15
25
75
5
What should you do to ensure accurate results in Excel formulas?
Use only one operator
Avoid using BODMAS
Ignore errors
Test and troubleshoot formulas
In the formula =(12+8)*3-4^2, what operation is performed last?
Addition
Multiplication
Exponentiation
Subtraction
What is the purpose of the IF function in Excel?
To perform basic calculations
To create complex formulas
To format cells
To perform conditional calculations
Which of the following is a correct formula for adding two numbers in Excel?
=A1 * A2
=A1 - A2
=A1 + A2
=A1 / A2
What is the result of the formula =IF(D4='YES', 10, 0) if D4 is 'NO'?
NO
10
0
YES
What is the first step to apply BODMAS rules in Excel?
Calculate brackets
Calculate orders
Perform multiplication
Perform addition
In the formula =((50-20)/5)+6*3, what is the result of (50-20)/5?
6
2
5
3
What is the correct way to write a formula that adds the first two numbers, multiplies by the third, subtracts the fourth, and divides by the fifth?
=(A1 + A2) * A3 - A4 / A5
=(A1 + A2) * A3 - A4 + A5
=(A1 + A2) * A3 + A4 - A5
=(A1 + A2) / A3 - A4 * A5
What is the result of the formula =IF(C3<100, C3*1.1, C3) if C3 is 90?
100
99
90
91
What is the result of the formula =IF(A1<50, 'FAIL', 'PASS') if A1 is 45?
PASS
FAIL
NOT GRADED
ERROR
Which function is used to find the maximum value in a range of cells in Excel?
SUM()
MIN()
AVERAGE()
MAX()
What is the result of the formula =((3+7)*2)/5?
4
5
6
8
What is the result of the formula =IF(E1>100, 'EXCEEDS', 'WITHIN LIMITS') if E1 is 120?
NOT GRADED
ERROR
EXCEEDS
WITHIN LIMITS
Which function is used to count the number of cells that contain numbers in a range in Excel?
COUNT()
COUNTA()
SUM()
AVERAGE()
What is the result of the formula =SUM(A1:A3) if A1=5, A2=10, and A3=15?
30
20
10
15
