Transcribed TextTranscribed Text

Start Excel. Download and open the file named go16_ xl ch03 grader 3g_ hw.x/sx 2 In the Expenses worksheet 8 calculate row totals for each Expense item the range F5:F9 Calculate column totals for each quarter and the Annual Total in the erange B10 F10. 3 In cell G5 construct formula to 12 calculate the Percent Totalb dividing Annual Totalfor and d Benefits by the Annual Total for Totals by Quarter. Use absolute cell references necessary, format the result Percent Style and then Center. Fillthe formula down through cellG9. 4 Usea: -D Pie chart to chart the Annual Total for each item Move the chart new sheet and then name the sheet Annual Expenses Chart 5 For the Chart Title. type Summary of Annual Expenses and for the chart title using WordArt Style Fill Blue. Accen Shadow Change the Chart Title font size 28 6 Remove the Legend from the chart and then add Data Labels formatted so that only Category Name and Percentage display positioned the Center. Change the Data Labels font size 12. and apply Bold and Italic. 7 Format the Data Series using a : -D Format effect Change Top bevel and Bottom bevel Circle. Set the Top bevel Wicht and Height 50 pt and then set the Bottom bevel Width and Height to 256 Change the Material the Standard Effect Metal. Note. the beve name may be Round depending on the version of Office used Display the Series Options and then set the Angle of first slice 125 so that the Salaries and Benefits slice is the front of the pie. Select the Salaries and Benefits slice. and then explode the slice 10% Change the Fill Color of the Salaries and Benefits slice Solid fill using Green, Accent Lighter 40% 9 Format the Chart Area by applying a Gradient using the Preset gradients Light Gradient Accent (fourth column first row) Format the Border o the Chart Area adding a Solid line border using Gold Accent and 10 Display the Page Setup dialog box 4 and then this chart sheet insert a custom footer in the left section with thefile name. 11 Display the Expenses worksheet 10 and then by using the Quarter names and the Totals Quarter insert Line with Marker chart the worksheet Move the chart so that tsupper corner positioned slightly inside the upper left corner of cell A12 Drag the center- right sizing handleso that the chart extends to slightly inside the right borde column Chart Title type City Pacifica Bay Annual Expense Summary 12 Format the Bounds of the Vertical 10 (Value) Axis that the Minimum is 2100000 and the Major unit is at 50000. Forma the Fill o Chart Area with : Gradient fill by applying the Preset, Light Gradient Accent: (third column first row) Format the Plot Area with a Solid llusing White, Background 13 Copy the Annual Totalin cell F10 10 and then use Paste Special paste Values Number Formatting cell B35 Incell C35 construct a formula to calculate the Projected Expenses after the forecasted increase incell B31 applied. Fill the formula through and then use Format Painter to copy the formatting from cell B35 the range C35:F35. 14 Change the Orientation C this 10 worksheet Landscape, and then use the Scale to options to fit the Height to page From Page Setup dialog box. center the worksheet orizontally and insert a custom footer in the left section with thefile name 15 Ensure that the worksheets are correctly named and placed the following order the workbook: Annual Expenses Chart Expenses Save the workbook and exit Excel Submit the file as directed

Solution PreviewSolution Preview

These solutions may offer step-by-step problem-solving explanations or good writing examples that include modern styles of formatting and construction of bibliographies out of text citations and references. Students may use these solutions for personal skill-building and practice. Unethical use is strictly forbidden.

    By purchasing this solution you'll be able to access the following files:

    for this solution

    PayPal, G Pay, ApplePay, Amazon Pay, and all major credit cards accepted.

    Find A Tutor

    View available Software Training (all Microsoft products and more) Tutors

    Get College Homework Help.

    Are you sure you don't want to upload any files?

    Fast tutor response requires as much info as possible.

    Upload a file
    Continue without uploading

    We couldn't find that subject.
    Please select the best match from the list below.

    We'll send you an email right away. If it's not in your inbox, check your spam folder.

    • 1
    • 2
    • 3
    Live Chats