Excel and instructions are attached. It is for a computer class. If you’re good I may have more assignments for you. see attachments to be sure you can complete the assignment correctly !
Office 2010 – myitlab:grader – Instructions Skills Series Vol. 1 (Capstone)
Aspen Falls Restaurants
Project Description:
In this project, you will modify a workbook to track taxes generated by restaurants in the Aspen Falls area. To complete the project, you will enter and format data, create formulas and functions, create and format a pie chart and a clustered column chart, apply conditional formatting, use Find and Replace to edit data, and finally create page footers.
Instructions:
For the purpose of grading the project you are required to perform the following tasks:
Step Instructions Points Possible
1 Start Excel. Download, save, and open the Excel file named Skills_eV1_Grader_CAP. 0
2 On the Taxes worksheet, center the title, Aspen Falls Restaurants, across cells D2:F2. 2
3 In cell J3, type Annual. In cell J4, type Federal Taxes. Center the text in each cell. 4
4 In cell J5, insert a formula that will add the numbers in cells F5:I5. Use the fill handle to copy the formula into cells J6 through J8. 5
5 In cell D2, apply the cell style Heading 1. 3
6 In cell J9, insert the SUM Function to total the values in the range J5:J8. Apply the Total cell style to the cell. 3
7 In cell C5, type Cafe after Giorno’s. In cell J2, type Tax Rebate and in cell K2, enter the value 3000 as the rebate amount. In cell K4, type After Rebate. 4
8 In cell K5, use an absolute cell reference to construct a formula that subtracts the rebate from the Annual Federal Taxes. Copy the formula down through cell K8. 5
9 Apply the accounting number format to the range F5:K9. 3
10 Select the nonadjacent ranges C5:C8 and J5:J8, and create a clustered column chart. 4
11 Change the fill color of the data series to Red, Accent 2. 3
12 Remove the legend and insert the title Annual Federal Taxes above the chart. 5
13 Reposition the clustered column chart so that the top left corner of the chart area aligns with the top left corner of cell E11. 3
14 Select the nonadjacent ranges K5:K8 and C5:C8 and create a Pie in 3-D chart in a new chart sheet named Rebate Taxes. 7
15 For all the slices, change the 3-D rotation of X to 30, and then change the point explosion of the Giorno’s Café slice by 40%. 4
16 In the pie chart, insert the chart title Taxes After Rebate above the chart, and then apply the Style 42 chart style. 5
17 Display the legend at the bottom of the chart area and increase the font size to 24. 4
18 On the Taxes worksheet, clear the formatting in the range F4:I4, and then right-align the text. In the range F3:I3, use the Date Format to change the dates to show as 3/31, 6/30, 9/30 and 12/30. 4
19 On the Revenue worksheet, in cell G5, insert a formula that subtracts the Local Taxes and Federal Taxes from the revenue and then divides that remainder by the number of branches for Giorno’s Café indicated in the Taxes worksheet (use the cell reference, not the number). Use the fill handle to copy the formula into cells G6:G8. 5
20 On the Meal Deal Sales Winners worksheet, in cell J6, use the MIN function to find the lowest number of Meal Deals sold. 3
21 In cells F5:F26, use the three triangles icon set in the directional style of conditional formatting to indicate where each manager falls among the group in terms of sales. 3
22 Add a new conditional formatting rule to format the range F5:F26 using a three-color scale. Keep the default values. 3
23 In column E, use Find and Replace to change all occurrences of AM Shift to Morning. 4
24 In cell I2, use the NOW function to insert the current date and time. 3
25 In cell J7, use the SUM function to insert the total number of Meal Deals sold. In cell J8, use the MAX function to find the most Meal Deals sold. 6
26 Group all of the worksheets together. Insert the file name in the center section of the footer for all of the worksheets in the workbook. Keep the worksheets grouped together. 5
27 Ensure that the worksheets are correctly named and placed in the following order in the workbook: Rebate Taxes; Taxes; Revenue; and then Meal Deal Sales Winners. Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0
Total Points 100
Updated on: 5/2/2011 2 E2010_SKLV1_CAP_Instructions x
> Falls s
/3 / / /12
/30/12
Taxes Taxes Taxes Taxes 12 9 0
39
9
39
Italian 9 1
40
8
Revenue ,309.00
Giorno’s Café 10 Giorno’s Café 6 Giorno’s Café Afternoon Giorno’s Café Giorno’s Café AM Shift 6 Giorno’s Café Evening 9 River Falls Inn Afternoon River Falls Inn Evening 22 River Falls Inn Evening 13 River Falls Inn 22 River Falls Inn AM Shift 20 River Falls Inn Afternoon 14 River Falls Inn Afternoon Pizza Alforno AM Shift 5 Pizza Alforno Evening 7 Pizza Alforno Afternoon 2 Pizza Alforno Afternoon 9 Taco City Evening 30 Taco City Evening 34 Taco City AM Shift 14 Taco City AM Shift 22 Taco City Afternoon 282
Taxes
Aspen
Restaurant
3
1
12
6
30
9
12/30/12
Name
Type
Number of branches
Giorno’s
Italian
7
4
8
7
20
7981
73
21
River Falls Inn
American
24
2749
22
2
10
28
Pizza Alforno
9
34
8341
8379
8
5
Taco City
Mexican
15
3210
3
19
3335
3566
Revenue
Name
Federal Taxes
Local Taxes
After-Tax Revenue by Branch
Giorno’s Café
$ 30,000.00
$ 1,512.00
$ 945,981.00
River Falls Inn
$ 9,936.00
$ 647.00
$ 194,094.00
Pizza Alforno
$ 34,601.00
$ 953.00
$ 745,209.00
Taco City
$
13
$ 800.00
$ 481,294.00
Meal Deal Sales Winners
Aspen Falls Restaurant Managers Bonus Award
Restaurant
Shift Assignment
Sales of “Meal Deals”
Statistical Analysis
1
Tom Brennan
AM Shift
2
Sue Jenkins
Afternoon
Lowest sales number
3
Anne Hathaway
14
Total Sales of all restaurants
4
Nicolas Schwartz
Evening
18
Highest sales number
5
Sally Tompkins
6
George Hanson
7
Peter Johnson
26
8
David Lesix
9
Austin Winters
10
Samantha Holden
Morning
11
Amanda Gowen
12
Brian Peters
13
Paul Luther
25
14
Melissa Adams
15
Mike McGraw
16
Wyng Hu
17
Audra Bolton
18
Chantal Williams
19
Nathan Edge
20
Bob Guitmeier
21
Elliot Podolsky
22
Leon Eddings
Order your essay today and save 25% with the discount code: STUDYSAVE
