Scribd
Upload
280 views

End User Applications (Asm452) Tutorial Part C: Microsoft Excel (40 Marks)

The spreadsheet shows sales data for products of Cameron Highlands Coffee House from July to December 2020. The Coffee House wants to analyze sales and identify the sales level of each product as bad, average, good, or outstanding. The tasks involve formatting the spreadsheet, calculating total sales by product and month, and using VLOOKUP to determine the sales indicator based on predefined sales ranges.

Uploaded by

ummi hanisah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
280 views

End User Applications (Asm452) Tutorial Part C: Microsoft Excel (40 Marks)

The spreadsheet shows sales data for products of Cameron Highlands Coffee House from July to December 2020. The Coffee House wants to analyze sales and identify the sales level of each product as bad, average, good, or outstanding. The tasks involve formatting the spreadsheet, calculating total sales by product and month, and using VLOOKUP to determine the sales indicator based on predefined sales ranges.

Uploaded by

ummi hanisah
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
You are on page 1/ 3

END USER APPLICATIONS (ASM452)

TUTORIAL
PART C: MICROSOFT EXCEL (40 MARKS)

The spreadsheet below shows the data for all of the products of Cameron Highlands Coffee
House. The Coffee House wants to run a sales analysis starting from July to December 2020
and also they want to identify the level of sales for each product whether it is in a bad, average,
good or outstanding level.

1. Start Excel then create a new workbook. Then, save the workbook as HANDS ON
TEST EXCEL YOUR NAME GROUP
2. Enter the data as per above figure.
(5 marks)
3. Change the formatting of the numbers to Currency ($) and two decimal
points.
(4 marks)
4. Merge & Center the titles. Please Bold, change the font size to 14 and font type to
Calibri.
6. Ap
ply
5. Find the Total Sales for:
For
a. Each product ma
t
as
b. Each month Ta
ble
an
d use any medium style. (5 marks)

(7 marks)

(6 marks)

(1 mark)
7. Apply Title Style for Total Sales (Month)
(1 mark)
8. Based on the Total Sales for each month, perform the following operations using formula
function:
a. the highest total sales
(2 marks)
b. the lowest total sales
(2 marks)

9. Using data from the Total Sales of every product, determine the Sales Indicator by using
the VLOOKUP function. Use Sales Indicator as stated below:
(7 marks)

Sales less than 30000 (Bad)


Sales from 30001 to 50000 (Average)
Sales from 50001 to 70000 (Good) Sales
more than 70000 (Outstanding)

You might also like