Question: please please help with excel. a. Open a blank excel work book b. Enter the following data into the worksheet. Save the workbook as Smartphone
please please help with excel.

a. Open a blank excel work book b. Enter the following data into the worksheet. Save the workbook as Smartphone Activities and your name to the desktop. c. Al Column heading: Activity, Lot, Sometimes, Never, A5Receive/make calls, A6view/send text msgs, A7Visit social media sites, e. Column B: 200, 450, 850, 120, 1000, 900 f. Column C: 550, 400, 200, 375, 100, 180 g. Column D: 450,350,150,705, 100, 120 h. Insert a row above row A2 i. In cell A2, enter the title SmartPhone Activities, Ages 14 thru 19 j. Merge and center the above title across column A thru D. set the font to 16 points k. Bold the column labels in row 2 and center them. Apply bold to the labels in column A I. Type Total in A12 column and apply formula to add all the numbers from column B to D m. Apply comma number format to the values n. Find Maximum, Minimum, Average for all columns combined and not including the totals o. Create a bar chart using the worksheet data move the chart to column A15
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
