Revision - Microsoft Excel

What will be the answer for this formula: =average(A1,A3)

What will be the answer for this formula: =count(A1:C2)

What will be the answer for this formula: =min(B2:D4)

What will be displayed in cell A2 if you change the format to percent with 1 decimal place?

Write the correct formula to calculate Shawl predicted sales in April. The predicted sales are 15% more from the sales in March.

Write the correct formula to calculate Hoodie predicted sales in April. The predicted sales are 23% more from the sales in March.

C3 contains the value 21, and C5 contains the text ICT0513. When the formula =C3/C5 is evaluated, an error is given. What could possibly be the error?

• #DIV/0!

• #VALUE!

• #REF!

• #NAME?

The formula =B3+C5-D4 has been copied from C7 to D7. What will be the formula in cell E5?

The formula =$C$3*D3 is located in cell B1. If this formula is copied and pasted into cell C1, what would be the formula in C1?

The formula =C2+D2 is located in cell C5. If this formula is copied and pasted into cell E5, what would be the formula?