(Tab to RIGHT OPTION to see the answer.)
Which formula correctly locks only the row of cell B3?
Correct!
Wrong!
What is the result of the formula =100-20/5+2*3?
Correct!
Wrong!
Why are nested brackets important in Excel formulas?
Correct!
Wrong!
Which formula correctly calculates the subtotal for row 6 if cost per unit is in B6, packaging charge is in C6, and quantity ordered is in D6?
Correct!
Wrong!
Which of the following is an example of an absolute reference?
Correct!
Wrong!
What is the purpose of brackets in a formula?
Correct!
Wrong!
What is the result of =40/5*2?
Correct!
Wrong!
What is the result of =10^2?
Correct!
Wrong!
What is the result of the formula =((30+20)-(5*2))/2?
Correct!
Wrong!
Which formula correctly calculates the discount if subtotal is in E6 and discount rate is in B3?
Correct!
Wrong!
Which operator does Excel calculate first in the formula =10+5*2?
Correct!
Wrong!
In Excel, multiplication and division are processed?
Correct!
Wrong!
Which result will Excel return for =5+4*3^2?
Correct!
Wrong!
Which Excel feature displays formulas instead of results?
Correct!
Wrong!
What is the result of =30+20-5*2/2 in Excel?
Correct!
Wrong!
In the formula =(25+15)/(5-1), which operation is performed first?
Correct!
Wrong!
Which symbol is used for multiplication in Excel formulas?
Correct!
Wrong!
Which type of reference remains fixed when copied?
Correct!
Wrong!
What is the result of =50-10+5?
Correct!
Wrong!
Which formula forces Excel to subtract first and then divide?
Correct!
Wrong!
Which symbol is used for exponent calculations in Excel?
Correct!
Wrong!
If subtotal is 110.90 and discount is 5%, what is the total after discount?
Correct!
Wrong!
Which of the following formulas calculates 10% of the value in cell A2?
Correct!
Wrong!
FBA-Lab5-Working with Formula MCQs
Super Excellent ****
Excellent ***
Very Good **
Good *
fair
Need Improvement
Share your Results: