A small shopkeeper in Arusha wants to track monthly sales using a spreadsheet. The sales data is recorded in a CSV file called January_Sales.csv with the following content:
Item,Quantity,Unit_Price,TZS
Rice,50,2500
Sugar,30,3000
Flour,20,2800
Step 1: Import the data
- Open Excel.
- Click Data > From Text/CSV.
- Select
January_Sales.csv and click Import.
- Choose Comma as the delimiter.
- Click Load to put the data in the worksheet.
Excel will display three columns: Item, Quantity, and Unit_Price.
Step 2: Calculate total sales
- In cell D2, type the heading
Total_TZS.
- In cell D3, enter the formula
=B3*C3 and press Enter.
- Copy the formula down to cells D4 and D5.
- The Total_TZS column will now show the sales for each item (Rice: 125,000 TZS, Sugar: 90,000 TZS, Flour: 56,000 TZS).
Step 3: Export the report
- Click File > Save As.
- Save the file as a PDF to share the report with the shop owner.