MS Excel Basic

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( : )