Week 7 On Your Own 13-1 Submission

Students, please view the "Submit a Clickable Rubric Assignment" video in the Student Center.Instructors, training on how to grade is within the Instructor Center.

Week 7 On Your Own Homework 13-1 Worth 75 points Note: Microsoft Office Suite 2013 (PC), 2011 (Mac), or more recent software is required to complete each homework assignment. Note: Some On Your Own projects have been modified for students using  Microsoft Office 2011 for Mac software. Students should select the appropriate version of the assignment based on the software they are using. Failure to do so may result in errors or difficulty when completing the project.Note: Use the data files you downloaded previously.Complete the weekly homework based on the following:

1. Complete the On Your Own project (PC or Mac version) according to the project instructions and submit your assignment through the online course shell. Note: It is important to note that some On Your Own projects request a printed or self-submitted document. Students completing this course online or in a physical classroom must submit the assignment through the online course shell regardless of the instructions presented in each On Your Own exercise.    
2. Submit your assignment in the appropriate Microsoft Office application(s) using the filename “Last name_First initial_OYO#” in addition to the appropriate filename extension (e.g., .docx, .dotx, .htm, etc.). For example: If your name is Mary Smith, the file for the On Your Own project 12-1 should be saved as Smith_M_12-1.dotx. 
3. Include your name, course section, professor name, title of the assignment, and version of the assignment (PC or Mac).
4. Provide general comments on the overall assignment experience in two to three (2-3) sentences. Submit the written portion in the text box located in the assignment submission link. 

I have attached the instructions to complete the assignment correctly. WEEK7OYO file are the directions and OYO13 Sunny is the woksheet to be completed. Please follow the guidelines and rules outlined above. 

Name:Course Secton:Professor Name:Ti±le of ±he Assignmen±:PC or Mac:

CMPTR2Chapter 13: Creating a Workbook1On Your Own 13-1On Your Own 13-11. Open the data fileSunnylocated inthe Chapter 13\On Your Ownfolder. Save the workbook asSunny Day Pizza.2. Rename the Sheet1 worksheet asSales History.3. Insert 12 rows at the top of theSales History worksheet. (Hint:Select rows 1 through 12 beforeusing the Insert command.)4. Increase the width of column A to23 characters and increase thewidth of columns B through F to 14characters.5. Copy the contents of the rangeB13:F13. Paste the contents of theClipboard in the range B7:F7.6. In the range A8:A11, enter thefollowing data:cell A8:Total Pizzas Servedcell A9:Average per MonthA10:Maximumcell A11:Minimum7. Select the range B26:F26, and thenuse AutoSum to calculate the sumof the pizzas served in each of thefive restaurants.8. Drag and drop the calculated valuesthat are in the range B26:F26 to therange B8:F8. Notice that theformulas still show the originalresults because the cell referencesin the function did not change whenyou moved the range.9. Select the range B26:F26, and thenuse AutoSum to calculate theaverage number of pizzas served ineach of the five restaurants. (Hint:Click the AutoSum button arrow toaccess additional functions.)10. Drag and drop the calculated valuesthat are in the range B26:F26 to therange B9:F9.11. Select the range B26:F26, and thenuse AutoSum to calculate themaximum number of pizzas servedin each of the five restaurants.Move the calculated values in therange B26:F26 to the rangeB10:F10.On Your Own

ComputerScienceExpert

(11)

Status NEW Posted 06 Jun 2017 08:06 AM My Price 9.00

-----------

Attachments

file 1496737513-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