# 8. Exercise - Working with spreadsheets

## Prerequisites

It is advisable to read the Excel 2016 Course up to the 8^{th} chapter Work with spreadsheets before starting this exercise.

## Question

Let's take the example from Exercise 1 - Calculation, Formulas and Series. We assume that the equipment and training project involves a number of subsidiaries of a parent company and that a price schedule for each subsidiary and an overall price schedule must be drawn up:

We assume the existence of 4 subsidiaries with quantities as follows:

We assume the existence of 4 subsidiaries with quantities as follows:

No. | Designation | Subsidiary 1 | Subsidiary 2 | Subsidiary 3 | Subsidiary 4 |

1 | Server - Xeon 8-Core Processor | 2 | 2 | 2 | 2 |

2 | Laptop PC, Intel Core i5-7200U processor | 50 | 40 | 60 | 32 |

3 | PC de bureau processeur Intel® Core™ i5-7500 | 250 | 200 | 300 | 160 |

4 | Line interactive UPS with AVR | 250 | 200 | 300 | 160 |

5 | Scanners, A4, 4,800 dpi x 4,800 dpi | 60 | 45 | 72 | 40 |

6 | Video projector - Display technology: DLP | 10 | 8 | 12 | 8 |

7 | Monochrome laser printer | 250 | 200 | 300 | 150 |

8 | Windows 10 Prefessional License | 300 | 240 | 360 | 200 |

9 | Microsoft Office 2016 License | 300 | 240 | 360 | 200 |

10 | Design software License | 50 | 40 | 60 | 32 |

11 | Management software License | 40 | 32 | 50 | 24 |

12 | Microsoft Office 2016 Training | 800 | 720 | 880 | 640 |

13 | Design software Training | 100 | 80 | 120 | 72 |

14 | Management software Training | 80 | 72 | 92 | 64 |

## Indications Exercise – Working with spreadsheets

Fill in a sheet as shown in the extract above with the unit prices and with all the formulas in column F (See formulas to be entered in column F in Exercise 1 - Calculation, Formulas and Series.

Then make 4 copies of this sheet. You will have 5 copies which you will name Subsidiary1, Subsidiary2, Subsidiary3, Subsidiary4 and Global.

For the 4 sheets Subsidiary1, Subsidiary2, Subsidiary3 and Subsidiary4, fill in the columns D with the quantities according to the table above.

For the 5th sheet, which you have named Global, enter in cell D5 the following formula

"=Subsidiary1!D5+Subsidiary2!D5+Subsidiary3!D5+Subsidiary4!D5"

Copy this formula to the other cells in column D.