Font size
WorksheetsMS Excel Basic
Total questions: 12
Worksheet time: 7mins
What is the selected part called?
Column
Cell
Row
Sheet
What is the selected part called?
Lin
Sheet
Column
Row
What is the selected part called?
Column
Cell
Sheet
Sheet
What is the selected part called?
A3
B2
B3
A3
What is the formula to get the total sales of items?
=MAX( : )
=TOTAL( : )
=SUM( : )
=MIN( : )
Khin Khin got "ENG-49(A1), MATHS-37(A2), PHYS-89(A3)" on her exam. If we want to know whether she "passed or failed" on her exam, what formula should we use?
IF(OR(A1>=40,A2>=40,A3>=40),"Passed","Failed")
IF(AND(A1>=40,A2>=40,A3>=40),"Failed","Passed")
IF(AND(A1>=40,A2>=40,A3>=40),"Passed","Failed")
IF(OR(A1>=40,A2>=40,A3>=40),"Failed","Passed")
Mg Mg bought 3 (A2) bags. The price of 1 bag is $30 (A1) . If we want to calculate the total amount of bags, which formula should we use?
=(A1*A2)
=(A2/A1)
=(A1/A2)
=(A2*A1)
The total sales amount is 2000(A1) and the quantity is 3(A2). What is the formula to get price per unit?
=(A2/A1)
=(A1*A2)
=(A1/A2)
=(A2*A1)
What is the formula of average?
=AVG( : )
=AVR( : )
=AVRG( : )
=AVERAGE ( : )
What is the formula of maximum?
=MAXIMUM ( : )
=MAX( : )
=MAXI( : )
=MAXM( : )
What is the formula of median?
=MED( : )
=MEDI( : )
=MEDIAN ( : )
=MEDN( : )
What is the formula of minimum?
=MIN( : )
=MINI( : )
=MINIMUM ( : )
=MINIM( : )
