MABS 101 mid-term instructions, Canvas
docx
keyboard_arrow_up
School
City College of San Francisco *
*We aren’t endorsed by this school
Course
101
Subject
Industrial Engineering
Date
Feb 20, 2024
Type
docx
Pages
2
Uploaded by HighnessPolarBear3564
Mid-term Exam - Part 1
You work as a spreadsheet specialist for Katie’s Kicks, which has four regional shops in the state of Florida. Your manager has asked you to prepare a first quarter revenue analysis similar
to the one shown in Figure 1-75 (on the second page).
Perform the following tasks:
Table 1-7
North
South
East
West
Sneakers
72714.58
77627.29
76607.31
49008.32
Shoes
45052.23
69165.66
76243.41
84844.01
Sandals
77630.94
78684.24
56601.25
72716.68
Accessories
65423.73
77690.69
58383.67
54433.07
Miscellaneous
55666.92
78618.97
47317.09
68594.4
1.
Open the Mid-term file and create the spreadsheet on the Sheet1 tab. Enter the worksheet title, Katie’s Kicks in cell A1 and the worksheet subtitle, First Quarter Revenue Analysis, in cell A2. Beginning in row 4 enter the region data shown in Table 1-7 (above).
2.
Create totals for each region, product, and company grand total.
3.
In A12:A14 type in the labels Average, Minimum and Maximum and add the corresponding functions in B12:B14 for the totals in F5:F9.
4.
Format the worksheet total and center the title across columns A through F.
5.
Format the worksheet subtitle to 16-point Calibri Light, and change the font color to a color of your choice, Center the subtitle columns A through F.
6.
Create cell style in ranges A4:F4, B4:F4, and A10:F10 that are similar to the picture. You can be creative, but tasteful.
7.
Center the column titles in row 4. Apply the accounting number format to the ranges
B5:F5 and B10:F10. Apply the comma style format to the range B6:F9. Adjust any column widths to the widest text entry in each column.
8.
Select the ranges B4:E4 and
B10:E10 and then insert a 3-D pie chart. Apply the Style 3 chart style to the chart. Move the chart to a new worksheet named Revenue Analysis Chart. Change the chart title to First Quarter Revenue Analysis.
9.
Apply Green color to the Chart sheet tab.
10.
Add your name as a left footer and the date as a right footer to the worksheet and set to landscape orientation.
11. It is recommended that you Spell Check and Proofread your work carefully.
12. Click on the other sheet tab (IF Function,) for Part 2 and follow the instructions. Submit the file when you have finished all the work.
Figure 1-75
Katie's Kicks
First Quarter Revenue Analysis
North
South
East
West
Total
Sneakers
$ 72,714.58 $ 77,627.29 $ 76,607.31 $ 49,008.32 $ 275,957.50 Shoes
45,052.23 69,165.66 76,243.41 84,844.01 275,305.31 Sandals
77,630.94 78,684.24 56,601.25 72,716.68 285,633.11 Accessories
65,423.73 77,690.69 58,383.67 54,433.07 255,931.16 Miscellaneous
55,666.92 78,618.97 47,317.09 68,594.40 250,197.38 Total
$ 316,488.40 $ 381,786.85 $ 315,152.73 $ 329,596.48 $ 1,343,024.46 The gridlines are only a guide. Please do not include them.
Please notice how all the numbers are formatted with 2 decimal places and the commas and decimals line up.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help