Complete this powerpoint. Same as before.

Good Luck

Ofce 2013 – myitlab:grader – InstructionsExcel ProjectGO E Capstone 1 - Front Range Action Sports 2.4Project Description:In this project, you will work with multiple worksheets and enter formulas and functions to calculatetotals, averages, maximum values, and minimum values. Additionally, you will create a summarysheet, format cells, insert charts, insert sparklines, and create a table in a workbook.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Start Excel. Open the downloaded Excel file namedGO_eV1_Grader_CAP.xlsx.0.0002On the Net Sales worksheet, in the range F4:F8, calculate the annual total sales for each state.4.0003In the range B9:F9, calculate totals.4.0004Using absolute cell references as necessary, in cell G4, construct a formula to calculate the percent thatthe Colorado Total is of Total Sales, and then fill the formula down through the range G5:G8.4.0005Apply the Total cell style to the range B9:F9.4.0006In cell H4, insert a Line sparkline using the data range B4:E4. Format the sparkline by applying theSparkline Style Accent 2 (no dark or light). Copy the sparklines down to cell H8.4.0007Insert a 3-D Pie chart using the nonadjacent ranges A4:A8 and G4:G8. Change the chart style to Style 7.Reposition the chart so that the top left corner of the chart is centered in cell A10. Change the width ofthe chart to6.5inches.4.0008Change the chart title toAnnual Net Sales by Stateand add data labels to the chart that display onlythe Category Name and Percentage positioned in the Center. Change the data labels Font color to Black,Text 1 and apply Bold Italic. Remove the Legend from the chart.5.0009Change the angle of the first slice of the pie to200, and then explode the red New Mexico slice of thepie by10%. Change the solid fill color of the orange Colorado slice to Tan, Accent 6.5.00010On the Seattle Inventory worksheet, in cell G14, enter an IF function to determine the items to beordered. If the Quantity in Stock is less than50, then the cell should displayOrder. If not, then the cellshould displayOK. Copy the function down through cell G19.4.000Updated: 04/14/20151Current_Instruction.docx

Front Range Action SportsAnnual Net Sales 2016Quarter 1Quarter 2Quarter 3Quarter 4TotalTrendColorado$48,123,789 $42,468,256 $45,159,681 $49,452,695New Mexico25,783,51621,985,36519,987,26922,252,487Oregon35,658,49834,689,52637,986,36939,456,899California58,123,78964,468,25665,159,68168,452,695Washington42,143,25846,598,45644,874,33250,546,222Total SalesPercent ofTotal Sales

• 1496725283-GO_eV1_Grader_CAP 1.xlsx
• 1496725284-GO_E_Capstone_1_-_Front_Range_Action_Sports_24_Instructions.docx

ComputerScienceExpert

(11)

Status NEW Posted 06 Jun 2017 04:06 AM My Price 11.00

-----------

Attachments

file 1496725291-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer