5. Exercise 3 - Calculation, Formulas and Series

---

Prerequisites

It is advisable to read the Excel 2016 Course up to the 6^th 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".

---