Font size
WorksheetsRevision - Microsoft Excel
Total questions: 17
Worksheet time: 16mins
What will be the answer for this formula: =average(A1,A3)
(a)
What will be the answer for this formula: =count(A1:C2)
(a)
What will be the answer for this formula: =min(B2:D4)
(a)
What will be displayed in cell A2 if you change the format to percent with 1 decimal place?
(a)
Write the correct formula to calculate Shawl predicted sales in April. The predicted sales are 15% more from the sales in March.
(a)
Write the correct formula to calculate Hoodie predicted sales in April. The predicted sales are 23% more from the sales in March.
(a)
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?
(a)
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?
(a)
The formula =C2+D2 is located in cell C5. If this formula is copied and pasted into cell E5, what would be the formula?
(a)
A format painter is used to apply formatting from cell B5 to cell A6. What would be the content of A6 after the formatting?
(a)
Write the result for this formula: =COUNT(B1:D4)
(a)
Write the result for this formula: =AVERAGE(E1:E4)
(a)
Write the result for this formula: =B6-A6+E4^E3
(a)
Write the result for this formula: =MIN(A1:C6)
(a)
Format the following number:
0.0000569 to Scientific with 2 decimal places
(a)
Format the following number:
0.0527 to Percentage with 1 decimal place
(a)
