Challenge 1 Math Addition45 10 XXXXXXXXXX 4.5 30 Answer Subtraction12 XXXXXXXXXX 10 60 68 Answer Multiplication20 20 x 32x3 32 3 Answer Divicion 66 / 35 / 2 66 35 2 Answer 150 Average250 220...

在此处复制并粘贴您的作业


Challenge 1 MathAddition45 10 45 + 10 + 4.5+304.5 30 Answer Subtraction12 12 - 10 - 60 - 68 10 60 68 Answer Multiplication20 20 x 32x332 3 Answer Divicion 66 / 35 / 266 35 2 Answer 150 Average250 220 (150 + 250 + 220 + 175)/4175 Answer Prof Wilson Alex Rod stepsBasic Math 1In G32 type your initials - press enter 2Select G32 and H32 - Apply Merge and center 3Select the new cell G32, increase the row size to 32 4Remove columns, D, E, F 5Adjust the table columns to 20 6Adjust the table rows height to 30 7Add a background color to cells D2 Addition, D8 Multiplication, D14 Divicion, D19 Average 8Select the range E2: E30 - format the data to 2 decimal places 9Select the entire table and add borders 10Save the project to your flash drive 11Print the project using the print format 12Submit your Project via email to: prof Wilson Email: [email protected] Prof Wilson Alex Rod Challenge 2 SubwayBusPath Mon200.00150.00500.00 Tue150.00150.00340.00 Wed130.00150.00200.00 Thu120.00150.00250.00 Fri120.00150.00200.00 Sat100.00150.00215.00 Sun90.00150.00190.00 Total Average Max Min stepsIn B18 type your initials - press enter 2Select C18 - Type your first & last name 3Sele Cells C18 and D18 and apply Merge & Center 4Adjust the table columns to 20 5Adjust the table rows height to 30 6Add a style background color to the table 7Insert the formulas for the totals in C12, D12, E12 8Insert the formulas for the average in C13, D13, E13 9Insert the formulas for the Maximun in C14, D14, E14 10Insert the formulas for the Minimum in C15, D15, E15 11Select the table and format the data with Currency 12Save the project to your flash drive 13Print the project using the print format 14Submit your Project via email to: prof Wilson Email: [email protected] Prof Wilson Alex Rod Challenge 3 Weekly Workout Log  Day ActivityTime SpentTime PlannedDifference Swimming45505 Yoga 4060 Jogging3040 Jogging2030 Weights3040 Biking90120 Pilates6075 TOTAL  AVERAGE steps 1In B15 type your initials - press enter 2Adjust the table columns to 25 3Adjust the table rows height to 36 4In Column A add the week days 5Get the totals in Rows 12 6Get the Averages in Row 13 7In column G5: G13 Type the formula that will give the Difference between Time Spend and Time Planned 8Add a background color - Apply Styles 9Select the entire table and add borders 10Save the project to your flash drive 11Print the project using the print format 12Submit your Project via email to: prof Wilson Email: [email protected] Prof Wilson Alex Rod Challenge 4 Item CategoryProjected CostActual CostDifference GasHousing403010 RentHousing120012000 GroceriesFood6006000 ConcertsEntertainment025-25 PhoneHousing50500 Investment AccountSaving and Investments5005000 Credit Card Loans500400100 ElectricityHousing3040-10 CableHousing40400 Savings AccountSaving and Investments2002000 GasTransportation100125-25 Dining OutFood502525 ClothingMiscellaneous 040-40 MaintenanceTransportation50050 Dry CleaningMiscellaneous 20155 MoviesEntertainment20200 StudentLoans2502500 Car PaymentTransportation3503500 steps 1In C25 type your initials - press enter 2Adjust the table columns to 25 3Adjust the table rows height to 36 4Type the formula in Column G That will tell the difference between Projected and Actual 5Format Columns D & E - to Two decimal places 6Select the entire table and add borders 7Insert a Chart - 3 D Columns 8Save the project to your flash drive 9Print the project using the print format 10Submit your Project via email to: prof Wilson Email: [email protected] Prof Wilson Alex Rod Challenge 5 Monthly Budget - January BillsPaymentDate DueDueNew Balance Fixed Expenses Cable / Internet89.991/15/1012030 Car Insurance1201/15/10200 Car Payment2201/22/08250 Cell Phone Service69.81/28/0890 Gym Membership251/28/080 Rent6501/1/101,300 Variable Expenses Power64January-1064 Gas160January-10200 Pets65January-1090 Water28.23January-1050 Other Clothes18.548-Jan-1025 Misc.98.066-Jan-10120 Restaurants156.716-Jan-10160 Credit Payment Discover1108.316-Jan-10120 Store Credit Card18.548-Jan-1025 Visa657.0210-Jan-10700 steps 1In C25 type your initials - press enter 2Adjust the table columns to 25 3Adjust the table rows height to 36 4Format Columns B - to Two decimal places 5Select the entire table and add borders 6Format the table - Apply styles - Notes 7Format the dates in the table - Use long format - Friday, November 30, 2015 8Click cell A24 - Insert a Column 9Type the formula in column F, for the new balance 10Save the project to your flash drive 11Print the project using the print format 12Submit your Project via email to: prof Wilson Email: [email protected] Prof Wilson Alex Rod Challenge 6 Microsoft Office StudentQuiz 1Quiz 2Quiz 3TotalMaxMinAvg MS WordMS Excel Web Peraza, Brian456575185754561.6666666667 Swensen, Liz505560 Harris, Jane554545 Lewty, Alice603530 Olvera, Emily K.552515 Wodal, Matthew70150 McMillan, J.E.756070 Dees, Robert806575 Wimblet, Grace857080 Salter, Joe Ann907585 Olds, Hannah958090 Strickler, Theodore 1008595 Merrill, Olivia10590100 war808590 steps 1In C18 type your initials - press enter 2Adjust the table columns to 20 3Adjust the table rows height to 36 4Fill in the formulas in Columns E, F, G, H 5Format the range B5:H18 - to Two decimal places 6Select the entire table and add borders 7Format the table - Apply styles - Notes 8Insert a Chart - Pie of a Pie 9Save the project to your flash drive 10Print the project using the print format 11Submit your Project via email to: prof Wilson Email: [email protected] Prof Wilson Alex Rod Challenge 7 Chart Worldwide Sporting Goods Sales RepJanFebMarTotal SalesExpensesNet SalesAverage Sales Smith, S1,8191,7671,9435,5291,2414,2881,843 Brown, N1,7041,8091,6505,1641,1653,9991,721 Shultz, J2,0102,1952,1596,3641,6504,7142,121 Adams, O1,9481,7261,8705,5441,3454,1991,848 Total steps 1In B13 type your initials - press enter 2Adjust the table columns to 20 3Adjust the table rows height to 30 4Select B4 - Wrap Textr 5Add the Totals in Row 10 6Select the range C6: I10 - format the data to 2 decimal places 7Add a background color to table 8Insert a chart - Pie 9Select the entire table and add borders 10Save the project to your flash drive 11Print the project using the print format 12Submit your Project via email to: prof Wilson Email: [email protected] Prof Wilson Alex Rod Challenge 8 Sparkilines Worldwide Sporting Goods District Sales Report Summary JANFEBMARQTR 1APRMAYJUNQTR 2JULAUGSEPQTR 3OCTNOVDECQTR 4TOTALS Column1Column2Column3Column4Column5Column6Column7Column8Column9Column10Column11Column12Column13Column14Column15Column16Column17Column18 District North Golf55256140655918224724376008100229437967.38360891025237.39560.76100321069230284.7696689.06 Tennis32453687420011132440153015664153664841.15831.16230.416902.65809.326997.327476.4820283.1263683.72 Football89769234756825778650453453546153957154.45879.53900.616934.58585.287055.44680.7220321.478428.9 Baseball37624571682315156835498568650268609189.410841.695152954611027.2813009.921141835455.2107017.2 District West Golf7182.579828526.723691.29415.998801053029825.910357.49108681158332808.4912428.98813041.613899.639370.188125695.778 Tennis4218.54793.1546014471.65721.36891.37363.219975.86293.437580.438099.5221973.387552.1169096.5169719.42426368.05682788.836 Football11668.812004.29838.433511.48455.26948.54609.820013.59300.727643.355070.7822014.8511160.8649172.026084.93626417.82101957.57 Baseball4890.65942.38869.919702.810860.212812.8112453491811946.2214094.0812369.538409.814335.46416912.89614843.446091.76139122.36 District South Golf5386.8755986.56395.02517768.47061.92574107897.522369.4257768.117581518687.2524606.36759321.7419781.210424.729527.64194271.8335 Tennis3163.8753594.825409510853.74290.9755168.4755522.414981.854720.07255685.32256074.6416480.0355664.0876822.3877289.56819776.04262091.627 Football8751.69003.157378.825133.556341.45211.3753457.3515010.1256975.545732.51253803.08516511.13758370.6486879.0154563.70219813.36576468.1775 Baseball3667.954456.7256652.42514777.18145.159609.68433.7526188.58959.66510570.569277.12528807.3510751.59812684.67211132.5534568.82104341.77 District East Golf6194.906256884.4757354.2787520433.668121.213758521.59082.12525724.838758933.3351259373.659990.337528297.32262510720.0021511248.3811988.40533956.78715108412.608525 Tennis3638.456254134.048754709.2512481.7554934.621255943.746256350.7617229.12755428.0833756538.1208756985.83618952.040256513.700057845.745058383.003222742.448371405.37105 Football10064.3410353.62258485.6228903.58257292.615993.081253975.952517261.643758021.8716592.3893754373.5477518987.8081259626.24527910.867255248.257322785.3697587938.404125 Baseball4218.14255125.233757650.2887516993.6659366.922511051.049698.812530116.77510303.6147512156.14410668.6937533128.452512364.337714587.372812802.432539754.143119993.0355 stepsChallenge 8 Sparkilines 1B34 type your initials - press enter 2Select The Column Headings add apply Styles color 3Adjust the table columns to 20 4Adjust the table rows height to 30 5Select the table headings - Apply a color style 6Select F8 : F11 & J8 : J11 & N8 : N11 & R8 : R11 & S8:S11 and insert a chart - Columns 7Select F14 : F17 & J14 : J17 & N14 : N17 & R14 : R17 & S14:S17 and insert a chart - lines 8Select F20 : F23 & J20 : J23 & N20 : N23 & R20 : R23 & S20:S23 and insert a chart - Area 9Select F26: F29 & J26 : J29 & N26 : N29 & R23 : R29 & S23:S29 and insert a chart - Pie 10Reposition the 4 Charts at the bottom of the table 11Select the range C8 : S29 - format the data to currency 12Select the entire table B7 to S30 apply Styles 13Save the project to your flash drive 14Print the project using the print format 15Submit your Project via email to: prof Wilson Email: [email protected] Prof Wilson Alex Rod Challenge 9 Filters SalespersonMayJuneJulyAug.Sept.Oct.Sparkilines Moss, Pete5,714.004,960.0011,507.001,010.006,599.0011,626.00 Ford, Victor5,541.004,931.008,283.001,054.009,543.0011,967.00 Altman, Zoey2,521.003,072.006,702.002,116.0013,452.008,046.00 Walters, Chris5,529.004,925.003,122.001,629.0014,684.0020,871.00 Collman, Harry3,967.004,906.009,007.002,113.0013,090.0013,953.00 Carlson, David2,327.004,056.003,726.001,135.008,817.0018,524.00 Hodges, Melissa5,667.004,798.008,420.001,389.0010,468.0012,677.00 Smith, Harold5,421.004,728.007,158.001,116.004,276.0013,907.00 Jameson, Robinson4,269.004,459.002,248.001,058.006,267.0014,982.00 Kellerman, Frances3,502.004,172.0011,074.001,282.002,365.009,380.00 Paul, Henry David5,347.004,060.007,056.001,555.005,439.0015,285.00 Thompson, Shannon2,943.003,943.0011,987.001,183.003,071.0011,292.00 Ferguson, Elizabeth4,685.001,913.004,596.001,126.005,503.0010,686.00 Bittiman, William4,752.003,755.004,415.001,089.004,404.0020,114.00 Thomas, Robert3,259.003,679.008,406.002,123.0014,697.0016,827.00 Farmer, Kim3,860.003,470.003,862.001,040.0010,024.0018,389.00 David, Chloe3,379.003,428.003,973.001,716.004,839.0013,085.00 Post, Melissa4,222.003,317.005,849.002,081.0010,521.0018,979.00 Zimmerman, Kate2,380.003,247.0011,956.001,156.003,098.008,531.00 Brennan, Michael4,964.003,152.0011,601.001,122.003,170.0010,733.00 Robinson, Betty5,929.003,127.007,971.001,114.002,686.0024,099.00 Flores, Tia4,052.002,883.002,142.002,012.0013,547.0021,983.00 Dumlao, Richard3,275.002,779.007,549.001,101.005,850.0015,065.00 Morrison, Thomas2,586.002,398.002,453.001,020.004,612.0020,525.00 Shadow, Elizabeth4,270.004,263.004,999.001,052.002,399.008,924.00 Mark, Katharine5,853.002,011.003,807.001,348.0011,110.0018,047.00 Davis, William5,363.001,562.002,945.001,176.009,642.0013,714.00 Allenson, Carol4,411.001,042.009,355.001,100.0010,185.0018,749.00 Albertson, Kathy3,947.00557.003,863.001,117.008,237.008,690.00 Counts, Elizabeth4,670.00521.004,505.001,024.003,528.0015,275.00 stepsChallenge 9 Filters 1B34
Mar 31, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here