5. Exercise 3 - Calculation, Formulas and Series
Prerequisites
It is advisable to read the Excel 2016 Course up to the 6th chapter Use of calculations before starting this exercise.
Question
Consider the following excerpt from the spreadsheet:
Reproduce this excerpt from a spreadsheet and fill in the values in columns F, G and H using appropriate formulas and using the technique of Autofill appropriately. For the VAT calculation, use the values in cells H3 and H4.
The extract after filling in the values:
Indications Exercise 3 – Calculation, Formulas and Series
1 - Formula in cell F10: "=D10*E10".
Formula in cell G10: "=F10*H$3". Notice the "$" sign in front of the line number. This is so that Excel does not switch to cells below cell H3 during Autofill.
Formula in cell H10: "=F10+G10".
2 - Select the range of cells F10:H10 and copy by moving the mouse pointer to H15
3 - Select cell range F10:H10 again and copy it to range F19:H19 using Copy/Paste. Modify the formula in cell G19 by "=F19*H$4" to apply VAT at 10%.
4 - Select the range of cells F19:H19 and copy by moving the mouse pointer to H21
5 - Formula in cell F16: "=SUM(F10:F15)". Copy this formula by moving the pointer to H16
6 - Formula in cell F22: "=SUM(F19:F21)". Copy this formula by moving the pointer to H22
7 - Formula in cell F24: "=F16+F22". Copy this formula by moving the pointer up to H24
8 - Formula in cell H26: "=H24-H25".