Excel - Lect 2

Which tool help you create the Email Address list as shown?

• AutoFill

• Flash Fill

• Formula

• Create New sheet

The highest Profit can be calculated from :

• =Max(E3:E11)

• =Min(E3:E11)

• =Max(E11)

To get the Lowest Monthly Installment, use the function of .....

• =MIN(D4)

• =MINIMUM(D3:D8)

• =MIN(D3:D8)

How many Items will have NO Taxes?

This question can be answered using this function .....

• =COUNT(E3:E8)

• =COUNTBLANK(E3:E8)

• =COUNTA(E3:E8)

How many Items are there in the list?

This question can be answered using this function .....

• =COUNTBLANK(A3:A8)

• =COUNT(A3:A8)

• =COUNTA(A3:A8)

Based on the results shown, what is the correct IF function were applied?

• • If age >= 6 , order size is Medium

  • Otherwise, order size is Small

• • If age >= 6 , order size is Small

  • Otherwise, order size is Medium

Based on the given sheet, which function is correctly applied to achieve this rule:

If park >3 hours, pay the fare pr hr, otherwise parking is free

• =IF(B4>3,B4*F7,"Free")

• =IF(B4>3,B4*$F$7,"Free")