Enter the data given below into a worksheet.

Enter the data given below into a worksheet.

Calculate the totals for each salesperson and get the grand total:
Format the worksheet as follows: Make all the Totals bold, two decimal places, comma, center the title across columns A-E and make it size 16, bold and Italic.
Put a double border round the whole table and a single line border inside the table.
Save the worksheet as Stationery Analysis.

The Correct Answer and Explanation is:

Stationery Supplies Ltd

Date	SalesPerson	Item	Receipt No	Amount
21-Nov	Carl	Toys	1238	1,782.10
26-Nov	Carl	Stationery	1255	4,853.55
26-Nov	Carl	Toys	1395	51.35
		Carl’s Total		6,687.00
21-Nov	John	Cards	1141	91.15
24-Nov	John	Books	1982	442.60
21-Nov	John	Toys	1885	561.50
26-Nov	John	Toys	1875	62.75
		John’s Total		1,158.00
22-Nov	Judy	Books	1032	234.50
26-Nov	Judy	Sports goods	1920	472.60
		Judy’s Total		707.10
25-Nov	Mary	Toys	1774	364.15
		Mary’s Total		364.15
22-Nov	Susan	Electronics	1160	52.95
23-Nov	Susan	Cards	1075	81.60
23-Nov	Susan	Others	1745	132.95
24-Nov	Susan	Sports goods	1662	2,580.10
		Susan’s Total		2,847.60
		Grand Total		11,763.85

---

Explanation

The table shown is a transactional dataset from a stationery company. It records sales transactions by date, salesperson, item, receipt number, and amount. The first step in working with such a dataset is data entry. The data should be input accurately into a worksheet such as Microsoft Excel.

After entering the raw data, subtotals are calculated for each salesperson using a summation of the “Amount” column for their respective rows. These values are:

• Carl’s Total = 1,782.10 + 4,853.55 + 51.35 = 6,687.00
• John’s Total = 91.15 + 442.60 + 561.50 + 62.75 = 1,158.00
• Judy’s Total = 234.50 + 472.60 = 707.10
• Mary’s Total = 364.15
• Susan’s Total = 52.95 + 81.60 + 132.95 + 2,580.10 = 2,847.60

Then, the Grand Total is calculated as the sum of all individual totals:

6,687.00 + 1,158.00 + 707.10 + 364.15 + 2,847.60 = 11,763.85

Formatting instructions are critical in presenting professional worksheets:

• Totals are bold, formatted with comma separators and two decimal places.
• The title “Stationery Supplies Ltd” is centered across columns A to E, bold, italic, and size 16.
• The table is bordered with a double line around the full table and single lines inside.

This makes the document both visually appealing and easy to interpret, fulfilling both analytical and presentational standards. The worksheet should be saved as “Stationery Analysis”.