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.

please please help with excel. a. Open a blank excel work book

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!