Excel UNV 504 Topic 3

Feb 3rd, 2012
Studypool Tutor
Grand Canyon University
Price: $10 USD

Tutor description

This assignment is in Microsoft Excel 1. Excel tutorial links 2. Excel Instruction 3. ExcelWorksheet (Microsoft Excel) If you have any questions please contact me.... Need this assignment back by 9/17/2014 at Central Chicago time 10.00am Excel Instructions Sheet 1 A. A. Open the Excel Workbook found with these instructions in “Excel Assignment” in Topic 3. B. B. Type your first and last name in cell A1. ( Brigett Stokes) C. C. Type “UNV-504” in cell A2. D. D. Type “Topic 3 Excel Assignment” in cell A3. E. E. Activate the Data Analysis Add-in. a. Use the “Activating the Data Analysis Add-in” video link in cell B6 of the Excel Tutorial Links from the Topic 3 Materials for help with these steps. F. Double click Sheet 1 in the bottom left corner and rename Sheet 1 as “Title Sheet.” Sheet 2 A. A. Open Sheet 2 by clicking the Sheet 2 tab at the bottom of the Excel Workbook. B. B. In cell D1 type “Total Unit Sa

Word Count: 341
Showing Page: 1/9
Brigett StokesUNV-504Topic 3 Excel AssignmentProductLawn mowerRakeShovelGarden hoseWeed sprayHedge trimmersPrunersSprinklerPlastic BucketGlovesAveragePrice per unit Units sold Total Unit Sales.$230.27179 $41,218.33$17.90413 $7,392.70$31.311136 $35,568.16$24.99267 $6,672.33$26.061025 $26,711.50$50.75842 $42,731.50$28.44354 $10,067.76$19.99571 $11,414.29$8.64359 $3,101.76$7.502641 $19,807.50$44.59778.7 $20,468.58Total Sales$ 204,685.83Instrument Number of musiciansViolin12Viola10Cello9Double bass3Trumpet3Tuba4Trombone4French Horn3Bassoon3Flute2Clarinet4Oboe3Percussion7Instrument FamilyBrassPercussionStringsWoodwindsNumber of Musicians1473412Number oNumber of MusiciansWoodwinds18%Brass21%Percussion10%Strings51%DivisionNortheast SalesSoutheast SalesCentral SalesNorthwest SalesSouthwest SalesJanuary7572635484FebruaryMarchApril105100951012210562808895May9027998593June121981079363105871048297140140120120100100808060Northeast Sales6040Southeast Sales40202000JulyAugust899391105107369792110111September OctoberNovember December10511467971071155910110910781871411592941101129789Northwest SalesSouthwest Sales`Temperature Soft drinks sold96-10519486-9518576-8521066-7520556-6517546-5512036-4511026-3510716-25100Soft drinks

Review from student

Studypool Student
" Excellent work as always thanks so much "
Ask your homework questions. Receive quality answers!

Type your question here (or upload an image)

1821 tutors are online

Brown University

1271 Tutors

California Institute of Technology

2131 Tutors

Carnegie Mellon University

982 Tutors

Columbia University

1256 Tutors

Dartmouth University

2113 Tutors

Emory University

2279 Tutors

Harvard University

599 Tutors

Massachusetts Institute of Technology

2319 Tutors

New York University

1645 Tutors

Notre Dam University

1911 Tutors

Oklahoma University

2122 Tutors

Pennsylvania State University

932 Tutors

Princeton University

1211 Tutors

Stanford University

983 Tutors

University of California

1282 Tutors

Oxford University

123 Tutors

Yale University

2325 Tutors