creating a workbook

User Generated

Zryvffvn17

Business Finance

Description

must be in a word excel document. all the instructions are in the files below

Unformatted Attachment Preview

CMPTR2 Chapter 13: Creating a Workbook On Your Own On Your Own 13-1 1. Open the data file Sunny located in the Chapter 13\On Your Own folder. Save the workbook as Sunny Day Pizza. 2. Rename the Sheet1 worksheet as Sales History. 3. Insert 12 rows at the top of the Sales History worksheet. (Hint: Select rows 1 through 12 before using the Insert command.) 4. Increase the width of column A to 23 characters and increase the width of columns B through F to 14 characters. 5. Copy the contents of the range B13:F13. Paste the contents of the Clipboard in the range B7:F7. 6. In the range A8:A11, enter the following data: of the pizzas served in each of the five restaurants. 8. Drag and drop the calculated values that are in the range B26:F26 to the range B8:F8. Notice that the formulas still show the original results because the cell references in the function did not change when you moved the range. 9. Select the range B26:F26, and then use AutoSum to calculate the average number of pizzas served in each of the five restaurants. (Hint: Click the AutoSum button arrow to access additional functions.) 10. Drag and drop the calculated values that are in the range B26:F26 to the range B9:F9. 11. Select the range B26:F26, and then use AutoSum to calculate the cell A8: Total Pizzas Served cell A9: Average per Month in each of the five restaurants. A10: Maximum Move the calculated values in the cell A11: Minimum 7. Select the range B26:F26, and then maximum number of pizzas served range B26:F26 to the range B10:F10. use AutoSum to calculate the sum 1 On Your Own 13-1 CMPTR2 Chapter 13: Creating a Workbook 12. Select the range B26:F26, and then use AutoSum to calculate the Restaurant Manager Location Phone 1 Anthony 58 Oak 555– Quinlan Drive 3585 2 Ada Nunez 3 Christina 525 555– Seward Simpson 4093 Street 4 Hazel 3654 555– Orchard 7831 Lane 5 Eileen 1087 555– Summit 6117 Boulevard minimum number of pizzas served in each of the five restaurants. Move the calculated values in the range B26:F26 to the range B11:F11. 13. In the Sales History worksheet, enter the following data: cell A1: Sunny Day Pizza cell A2: Sales Report cell A3: Year cell B3: 2016 cell A4: Total Pizzas Served 14. In cell B4, use the SUM function to add the values in the range B8:F8. 15. Insert a new worksheet. Rename 4514 555– Prescott 3728 Avenue 18. Format the labels in row 4 as bold. 19. Set the widths of columns A through D so that all of the data is visible. (Hint: Column A should be the worksheet as Restaurant wide enough to display the Directory. Restaurant heading but not fit the 16. In the Restaurant Directory worksheet, enter the following data: cell A1: Sunny Day Pizza cell A2: Restaurant Directory 17. In the range A4:D9, enter the following data: contents in cells A1 and A2. You can AutoFit the rest of the columns to their contents.) 20. Insert a new worksheet in the workbook. Rename the inserted sheet as Documentation. Move the Documentation worksheet to be the first sheet in the workbook. 21. In the Documentation worksheet, enter appropriate data to record the company name, yourself as the 2 On Your Own 13-1 CMPTR2 Chapter 13: Creating a Workbook author, the current date, and the commands are on the PAGE purpose of the workbook. LAYOUT tab or on the Print 22. View each sheet in the workbook in screen.) Page Layout view, and change the 23. Print the entire workbook. page orientation or scale each 24. Save the workbook, and then close worksheet as needed so that it fits it. on a single page. (Hint: The Scale 3 On Your Own 13-1 Name: Course Section: Professor Name: Title of the Assignment: PC or Mac: Month Restaurant R 1estaurant R 2estaurant R 3estaurant R 4estaurant 5 January $ 3.725 $ 3.425 $ 4.150 $ 2.875 $ 2.025 February $ 4.700 $ 3.150 $ 5.825 $ 2.575 $ 2.175 March $ 4.475 $ 4.145 $ 5.875 $ 2.825 $ 2.225 April $ 3.550 $ 3.550 $ 5.525 $ 3.250 $ 2.225 May $ 4.125 $ 3.945 $ 4.450 $ 2.975 $ 2.450 June $ 5.000 $ 3.700 $ 6.300 $ 3.120 $ 2.825 July $ 4.850 $ 4.650 $ 6.350 $ 3.475 $ 2.375 August $ 5.350 $ 4.550 $ 6.150 $ 3.425 $ 2.475 September $ 6.155 $ 4.750 $ 5.225 $ 3.500 $ 2.625 October $ 6.050 $ 4.950 $ 5.125 $ 3.325 $ 2.450 November $ 5.120 $ 4.235 $ 5.500 $ 3.575 $ 2.450 December $ 5.475 $ 4.225 $ 5.600 $ 4.325 $ 2.725
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Here is your document.

Company Name:
Author:
Date:
Purpose of the Workbook:

Sunny Day Pizza
14-May-17
The purpose of this workbook was to go over the sales of this company.

Name:
Course Section:
Professor Name:
Title of the Assignment:
PC or Mac:

Sunny Day Pizza
Sales Report
Year
Total Pizzas Served

Total Pizzas Served
Aver...


Anonymous
Really great stuff, couldn't ask for more.

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags