Excel Module 5 SAM Project B Jefferson School District

Описание: Excel Module 5 SAM Project B Jefferson School District


Contact Me:
WhatsApp No:+1(725) 272-9378



#Shelly Cashman Excel 2019
#Module 5: SAM Project 1b
#Jefferson School District
#SC_EX19_5b
#Module 5
#Jefferson School District
GETTING STARTED
• Open the file SC_EX19_5b_FirstLastName_1.xlsx, available for download from the SAM website.
• Save the file as SC_EX19_5b_FirstLastName_2.xlsx by changing the “1” to a “2”.
o If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.
• To complete this SAM Project, you will also need to download and save the following data files from the SAM website onto your computer:
o Support_EX19_5b_Fundraisers.xlsx
• With the file SC_EX19_5b_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet.
#Shelly Cashman Excel 2019
#Module 5: SAM Project 1b
#Jefferson School District
#SC_EX19_5b
#Module 5
#Jefferson School District
o If cell B6 does not display your name, delete the file and download a new copy from the SAM website.
PROJECT STEPS
#Shelly Cashman Excel 2019
#Module 5: SAM Project 1b
#Jefferson School District
#SC_EX19_5b
#Module 5
#Jefferson School District
1. Allison Kenyon is on the Finance Committee of the Jefferson School Foundation, an organization that raises funds for schools in the Jefferson School District. Allison is tracking sales from four cookie dough fundraisers held during the year. She asks for your help in projecting future sales and visualizing the sales data for an upcoming committee meeting.

#Shelly Cashman Excel 2019
#Module 5: SAM Project 1b
#Jefferson School District
#SC_EX19_5b
#Module 5
#Jefferson School District
The Elementary School, Middle School, and High School worksheets have the same structure and contain similar data. Group the Elementary School, Middle School, and High School worksheets to make changes to the three worksheets at the same time. The first change is to display today's date.
#Shelly Cashman Excel 2019
#Module 5: SAM Project 1b
#Jefferson School District
#SC_EX19_5b
#Module 5
#Jefferson School District

In cell B3 of the Elementary School worksheet, enter a formula using the TODAY function to display today's date.
2. Find each instance the text "Pistachio cranberry" on the three worksheets and then change it to Pumpkin spice to use the correct cookie flavor.
3. Use the text in cell H5 to fill the range I5:K5 with the remaining quarters in the year.
#Shelly Cashman Excel 2019
#Module 5: SAM Project 1b
#Jefferson School District
#SC_EX19_5b
#Module 5
#Jefferson School District
4. Allison wants to use the cell formatting in merged cell H8 in other places in the workbook. Create and apply a cell style as follows:
a. Create a cell style named Notes based on the formatting in merged cell H8.
#Shelly Cashman Excel 2019
#Module 5: SAM Project 1b
#Jefferson School District
#SC_EX19_5b
#Module 5
#Jefferson School District
b. Merge cells H6:K6 without centering the contents.
c. Apply the new Notes cell style to cell H6.
5. Allison thinks each school has a good chance of increasing the average number of fundraising items sold to 125 in Quarter 4 next year. For Quarter 1, she estimates 80 fundraising items sold, which is the average number sold each quarter this year.

#Shelly Cashman Excel 2019
#Module 5: SAM Project 1b
#Jefferson School District
#SC_EX19_5b
#Module 5
#Jefferson School District