A1 x V fx Clara's Goodie Bags 1 Clara's Goodie Bags Barstow Total 4 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Total Bags Wedding 3245 2223 2887 3542 Birthday 2102 1063 2001 4114 Holiday 4265 5556 4842 5003 Graduation 2134 2257 2432 4888 Retirement 1623 1112 1444 1771 Custom 1407 1833 1598 1651 Documentation Barstow + x fx Clara's Goodie Bags Clara's Goodie Bags 2 Carlsbad Total 4 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Total Bags Wedding 1887 2236 2804 3558 Birthday 2874 1565 2147 4012 Holiday 6825 5269 4226 5334 Graduation 4240 2887 2035 3336 Retirement 944 1118 1402 1779 Custom 1437 783 1074 2006 Documentation Carlsbad + A1 x fx Clara's Goodie Bags A 1 Clara's Goodie Bags Birthday Total mm 4 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 Total Bags Wedding 7,267 7,267 7,267 7,267 8,150 8,150 8,150 8,150 Holiday 15,425 15,425 15,425 15,425 Graduation 8,709 8,709 8,709 8,709 Retirement 3,635 3,635 3,635 3,635 Custom 3,891 3,891 3,891 3,891 Documentation Sheet1 + A1 x V fx Clara's Goodie Bags 1 Clara's Goodie Bags San Diego Total 4 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Total Bags Wedding 2135 4213 2748 3642 Birthday 3174 4165 3542 2650 Holiday 4335 5142 3968 4888 Graduation 2335 2143 3012 3550 Retirement 1068 2107 1374 1821 Custom 1047 1374 1169 875 Documentation San Diego + Case Problem 2 filles needed for this Case Problemi Barstow.xlsx, San Diego , Carlsbad , Goodilla deras Goodie Bags Clara Porry founded Clara's Goodie Bags to create unique party ve packages Le ate and corporate events. The first retail location opened on July 1, 2016 in Barstow, California the San Diego location opened in 2017, and recently the Carlsbad loxation was added Each location Excel workbook to track the number of goodie bags sold in major categories wedding the holiday graduation, retirement, and custom Clara wants you to use the workbooks to prepare t showing the number of goodie bags sold by quarter and location for each category. Complete the following on the Barstow workbook located in the Excels Cower botter included with your Data Files and then the workbook as Barstow 2017 in the location specified by your instructor In the Documentation worksheet, enter your name and the date 1. In the Barstow worksheet calculate the total number of goodiebags sold in each category in the range B8 G8, and the total number sold each quarter in the range 14:18 Improve the look of the worksheet by using the formatting of your choice including a bottom border in the range A:H7 and appropriate number formats for the total numbers of rabbags sold. 5. Save the Barstow 2017 workbook, and leave it open. 6. Repeat Steps 1 through for the San Diego and Carlsbad workbooks, raming them San Diego 2017 and Carlsbad 2017, respectively. 7. Open the Goodiebag worklok located in the Excel Case folder included with your Data Files, and then save the workbook as Goodie Bags 2017 in the location specified by your instructor 8. In the Documentation worksheet, enter your name and the date. 9. Rename Sheets Summary in cell A2 enter Summary Sales as the Label O Troubleshoot 10 The rely ocals in the Goodie Bag 2017 Summary w he displaying the correct results. Make any necessary corrections to the formulas the correct cells from the Bastow 2017, San Diego 2017, and Carlsbad 2017 work 11. Insert formulas to calculate the totals for the range 38.68 and the range 1418 Troubleshoot 12. The Documentation worksheet in the Goodie Bag 2017 workbook includes hyperlinks in the range A9A11 for each city's corresponding workbook Barstow 2017 San Diep 2017, and Carlsbad 2017 located in the folder where you saved the workbooks The text displayed for each hyperlink does not match its source file. Edit the hyperlinks to the each hyperlink points to its corresponding location workbook 13. Add appropriate text for the Screen Tip to each hyperlink. Test each hyperlink. 14. Prepare each workbook for printing. For all worksheets except the Documentation worksheet display the workbook name and the worksheet name on separate lines in the right section of the header and display your name and the current date on separate lines in the right section of the footer. Change the orientation so that each workbook will print on one page 15. Save and close all of the workbooks. A1 x V fx Clara's Goodie Bags 1 Clara's Goodie Bags Barstow Total 4 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Total Bags Wedding 3245 2223 2887 3542 Birthday 2102 1063 2001 4114 Holiday 4265 5556 4842 5003 Graduation 2134 2257 2432 4888 Retirement 1623 1112 1444 1771 Custom 1407 1833 1598 1651 Documentation Barstow + x fx Clara's Goodie Bags Clara's Goodie Bags 2 Carlsbad Total 4 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Total Bags Wedding 1887 2236 2804 3558 Birthday 2874 1565 2147 4012 Holiday 6825 5269 4226 5334 Graduation 4240 2887 2035 3336 Retirement 944 1118 1402 1779 Custom 1437 783 1074 2006 Documentation Carlsbad + A1 x fx Clara's Goodie Bags A 1 Clara's Goodie Bags Birthday Total mm 4 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 Total Bags Wedding 7,267 7,267 7,267 7,267 8,150 8,150 8,150 8,150 Holiday 15,425 15,425 15,425 15,425 Graduation 8,709 8,709 8,709 8,709 Retirement 3,635 3,635 3,635 3,635 Custom 3,891 3,891 3,891 3,891 Documentation Sheet1 + A1 x V fx Clara's Goodie Bags 1 Clara's Goodie Bags San Diego Total 4 Quarter 1 5 Quarter 2 6 Quarter 3 7 Quarter 4 8 Total Bags Wedding 2135 4213 2748 3642 Birthday 3174 4165 3542 2650 Holiday 4335 5142 3968 4888 Graduation 2335 2143 3012 3550 Retirement 1068 2107 1374 1821 Custom 1047 1374 1169 875 Documentation San Diego + Case Problem 2 filles needed for this Case Problemi Barstow.xlsx, San Diego , Carlsbad , Goodilla deras Goodie Bags Clara Porry founded Clara's Goodie Bags to create unique party ve packages Le ate and corporate events. The first retail location opened on July 1, 2016 in Barstow, California the San Diego location opened in 2017, and recently the Carlsbad loxation was added Each location Excel workbook to track the number of goodie bags sold in major categories wedding the holiday graduation, retirement, and custom Clara wants you to use the workbooks to prepare t showing the number of goodie bags sold by quarter and location for each category. Complete the following on the Barstow workbook located in the Excels Cower botter included with your Data Files and then the workbook as Barstow 2017 in the location specified by your instructor In the Documentation worksheet, enter your name and the date 1. In the Barstow worksheet calculate the total number of goodiebags sold in each category in the range B8 G8, and the total number sold each quarter in the range 14:18 Improve the look of the worksheet by using the formatting of your choice including a bottom border in the range A:H7 and appropriate number formats for the total numbers of rabbags sold. 5. Save the Barstow 2017 workbook, and leave it open. 6. Repeat Steps 1 through for the San Diego and Carlsbad workbooks, raming them San Diego 2017 and Carlsbad 2017, respectively. 7. Open the Goodiebag worklok located in the Excel Case folder included with your Data Files, and then save the workbook as Goodie Bags 2017 in the location specified by your instructor 8. In the Documentation worksheet, enter your name and the date. 9. Rename Sheets Summary in cell A2 enter Summary Sales as the Label O Troubleshoot 10 The rely ocals in the Goodie Bag 2017 Summary w he displaying the correct results. Make any necessary corrections to the formulas the correct cells from the Bastow 2017, San Diego 2017, and Carlsbad 2017 work 11. Insert formulas to calculate the totals for the range 38.68 and the range 1418 Troubleshoot 12. The Documentation worksheet in the Goodie Bag 2017 workbook includes hyperlinks in the range A9A11 for each city's corresponding workbook Barstow 2017 San Diep 2017, and Carlsbad 2017 located in the folder where you saved the workbooks The text displayed for each hyperlink does not match its source file. Edit the hyperlinks to the each hyperlink points to its corresponding location workbook 13. Add appropriate text for the Screen Tip to each hyperlink. Test each hyperlink. 14. Prepare each workbook for printing. For all worksheets except the Documentation worksheet display the workbook name and the worksheet name on separate lines in the right section of the header and display your name and the current date on separate lines in the right section of the footer. Change the orientation so that each workbook will print on one page 15. Save and close all of the workbooks
