EXCEL / SPREADSHEET WEEK 2

Dear Students,
As we continue with spreadsheets, we will be exploring the following areas;

Learning Objectives;
1. Enter data into Excel and calculate sum and subtractions.
2. Enter business transaction data into Excel and calculate profits.


Task 1

Use the picture below to enter the Souq Supermarket transaction to the spreadsheet.

Calculate the following;
1. Total or sum of the amount spent on buying items.
2. Total or sum of the amount received on selling items.
3. Profits received once the products/items were sold.
4. Format the column for profits to a blue color.
5. Format the row for totals to a green color.

Task 2.

Mr. Abdel bought items from Souq Supermarket as shown in the table below.

Calculate the following;
1. Total or sum of the amount spent by Mr. Abdel on buying items.
2. Total or sum of the amount received as a discount on items bought.
3. Calculate the amount paid for each item after the discount.
4. Format the column for discount to a red color.
5. Format the row for totals to a yellow color.

Enjoy your Excel Journey.
Mr. Wamurwa