COMPUTER APPLICATIONS
MICROSOFT EXCEL
1. Create a spreadsheet using the information given below and save as
MART. (Use Arial font, size 12 pt)
2. Using a function, insert today’s date in cell A1. (Insert a row in an
appropriate position that would enable you to complete this
requirement).
3. Save Sheet1 as WORKINGMART.
4. Make a copy of WORKINGMART and rename it FINISHEDMART.
Do the following in FINISHEDMART:
5. Add a subheading in F4 called TOTAL SALES, G4 called AVERAGE
SALES, and H4 called HIGHEST SALES. (Must be placed on two
lines. Adjust column widths where necessary)
6 In A16 place a subheading called COUNT.
7. Use formulas or functions to calculate the following:
Total sales for each month;
Average sales for each month;
Highest sales for each month;
Lowest sales for each month;
No. of Mini Marts for each month;
Total sales for each Mini Mart;
Average sales for each Mini Mart;
Highest sales for each Mini Mart;
The overall total sales; (Place in appropriate cell)
8. Complete the following formatting operations:
Format the headings and subheadings as follows:
First Heading – Title
Second Heading – Heading1
Column Headings – Heading 2
Row Headings – Heading 3
Format all numbers, except COUNT, to Currency and no decimal
places (Auto fit the column width if necessary)
Insert a suitable graphic. The graphic should be appropriately sized
and placed to the left of the Title and Heading1.
9. Perform the following sorts:
Total Sales in ascending order. Name sheet SORTA.
February in descending order. Name sheet SORTB.
Average Sales in ascending order. Name sheet SORTC.
10. Create the following charts:
A Pie Chart to compare the Total Sales for Each Month
Pie Chart Type: Exploded Pie
Title of Chart: Mini Mart Monthly Sales
Place the legend at the top of the chart
Show the value
Place on separate chart called Monthly Sales
A Bar Chart to show the Total Sales for each Mini Mart
Column Chart Type: Clustered Bar in 3D
Title of Chart: Mini Mart Totals
Label the axis: Horizontal (Amount)/Vertical (Mini Marts)
Place on separate chart called Mini Mart Totals
A Column Chart to compare the sales for each month
Column Chart Type: Clustered Column
Title of Chart: Weekly Sales
Switch the row/column information
Label the axis: Horizontal (Months)/Vertical (Amount)
Place the legend at the bottom of the chart
Embed in the spreadsheet A19 – E40.
COMPUTER APPLICATIONS
MICROSOFT EXCEL
1. Create a spreadsheet using the information given below. Save as
COOKIES
A B C D E F G
1
2 B & B BAKERY
3 Cookie Sales by Sales Representatives
4
Chocolate
5 Brownie Pecan Oatmeal Chip TOTAL %AGE
6 Dorothy 100
7 Millie
8 John
9 Steven
10 Barbara
11
12 TOTAL
13 AVERAGE
14 HIGHEST
15 LOWEST
2. Using a function, insert today’s date in cell A1.
3. The following should assist you in entering your numbers:
The amount for Brownie sales has shown an increase in equal
increments of 100.
Cookie sales for Dorothy and Millie have shown an increase in equal
increments of 50.
Cookie sales for John have shown an increase in equal increments of
75.
However, cookie sales for Steven and Barbara have shown a
decrease in equal increments of 25.
4. Use functions to calculate the following:
Total sales for each type of cookie;
Average sales for each type of cookie;
Highest sales for each type of cookie;
Lowest sales for each type of cookie;
Total cookies sold by each representative;
The overall total sales of cookies; and
The percentage of cookies sold by each representative in
relation to the overall total sales on cookies.
5. Complete the following formatting operations:
Format all numbers to Currency and no decimal places;
Format the headings and subheadings as follows:
First Heading – Title
Second Heading – Heading1
Column Headings – Heading 2
Row Headings – Heading 3
6. Perform the following sorts:
Total in descending order. Name sheet SORTA.
Oatmeal in ascending order. Name sheet SORTB.
7. Create the following charts:
A Pie Chart to compare the total sales on each type of cookie; and
A Column Chart to show the total sales by each representative.
