3. Exercise 1 - 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

Let's go back to the example of Exercise 2 - Formatting. The values in column F are all inferred from other values on the sheet.

Write the formulas allowing to calculate the values of the column F while using of course the technique of Autofill when it is convenient:

---

Indications Exercise 1 – Calculation, Formulas and Series

---

1 - Formula in cell F5 : « =D5*E5 »

2 - The formula must be copied up to cell F20. But because of the cell fusions at the A12:F12 and A17:F17 ranges, you cannot do this by moving the mouse pointer over to the F20 cell. Proceed as follows:

• Click in cell F5 and click on the Copy button
• Click in cell F13 and click on the Paste button
• Click in cell F18 and click on the Paste button
• Copy the formula by moving the mouse pointer from cell F5 to cell F11
• Copy the formula by moving the mouse pointer from cell F13 to cell F16
• Copy the formula by moving the mouse pointer from cell F18 to cell F20

3 - The formula in cell F21 is: "=SUM(F5:F11,F13:F16,F18:F20)". Here's how to get this formula:

• Enter "=" using the keyboard
• Select the SUM function at the Name Box. The Function Arguments dialog box is open
• Select the range F5:F11
• Click in the Number2 field of the dialog box and select the range F13: F16
• Click in the Number3 field of the dialog box and select the range F18: F20

4 - The formula in cell F22 is "=F21*20%"

5 - The formula in cell F23 is "=F21+F22"

---