Excel Exam

Here is an Excel spreadsheet that you can use as a starting point for your exam, so you don't have to type all those numbers. Check the Sheet 1 and 2.

Exercise 1:

Please create the spreadsheet as given here.

a- Product, value and quantity should be the values given in the tables.
b- Purchase = value * quantity
c- With discount 1 is applying a discount of 11% to the Purchase value.
d- With discount 2 is applying a discount of 33% to the Purchase value.
e- Note that both discount values (11 and 33) should be taken FROM THE spreadsheet, so that if when I grade I change those values manually, they should immediately reflect a change in the corresponding columns.
f- After you created the table and formatted it as shown, please create a pie chart that replicates the one I gave you.

Exercise 2:

Please create the spreadsheet as given here.

a- The values for rice, flour, sugar and milk for the months from January to June should be entered by you directly.
b- The total, average, median, min and max should be created by using FORMULAS.
c- Generate the bar chart showing the evolution of the four products through the months, in the format given.
d- Then generate a line chart that ONLY SHOWS two of the series (flour and rice) and format it as given.