Details of this Paper

Sunny Day Pizza

Description

solution


Question

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;cell A8: Total Pizzas Served;cell A9: Average per Month;cell A10: Maximum;cell A11: Minimum;7. Select the range B26:F26, and then use AutoSum to calculate the sum 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 maximum number of pizzas served in each of the five restaurants. Move the calculated values in the range B26:F26 to the range B10:F10.;12. Select the range B26:F26, and then use AutoSum to calculate the 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: 2014;cell A4: Total Pizzas Served;14. In cell B4, use the SUM function to add the values in the range B8:F8. On Your Own 15. Insert a new worksheet. Rename the worksheet as Restaurant Directory. Move the Restaurant Directory worksheet to be the first sheet in the workbook.;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;Restaurant Manager Location Phone;1 Grace 958 Pine 555?3585 Anthony Drive;2 Lanell 4514 555?3728 Nunez Trainer Avenue;3 Christina 525 555?4093 Steward Simpson Street;4 Letitia 3654 555?7831 Breton Apple Lane;5 Eileen 1087 555?6117 Jones Summit Boulevard;18. Set the widths of columns A through D so that all of the data is visible. (Hint: Column A should be wide enough to display the Restaurant heading, but not fit the contents in cells A1 and A2. You can AutoFit the rest of the columns to their contents.);19. 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.;20. In the Documentation worksheet, enter appropriate data to record the company name, yourself as the author, the current date, and the purpose of the workbook.;21. View each sheet in the workbook in Page Layout view, and change the page orientation or scale each worksheet as needed so that it fits on a single page.;22. Print the entire workbook.;23. Save the workbook, and then close it.

 

Paper#63986 | Written in 18-Jul-2015

Price : $22
SiteLock