Thing+13+Party+Planner


 * __ Thing 13: Party Planner __**

Choose Excel or Google Spreadsheet to complete this Quest.
 * // There are 5 people in your family and all 5 will be attending. You have invited Grandpa and Grandma, but Grandpa is out of town fishing that day so only Grandma can attend. Aunt Lucy has 5 people in her family and 3 will be attending. Uncle Gus and Aunt Francis have 4 in their family however only 2 can attend that day. You also want to invite all 9 of your cousins and you have let them know they can bring a friend, so 13 people will be attending. In addition, you can't forget all 12 members on your Ping Pong team plus the 2 coaches so an additional 10 people will be attending. //**


 * S **** tep 1 - Open a new Excel document or Google Spreadsheet and name it: __Party Planner.__ **


 * Step 2 - Title three columns - Name, # Invited, # Attending (//make sure all of the titles are capitalized//). This is called a Header Row. **


 * Step 3 - List all of the families, neighbors, and groups invited under NAME. You will need to adjust the column width to fit the name of the people invited. **


 * Step 4 - List the number of people invited under # INVITED **


 * Step 5 - List the number of people attending under # ATTENDING **


 * Step 6 - Align the text for column B and C so it is in the center. **


 * Step 7 - Highlight column A and color it light blue, highlight column B and color it light green, and highlight column C and make it light pink. **


 * Step 8 - Put a border around each cell. **


 * Step 9 - Have a row labeled TOTALS in cell A9 and make it bold. **


 * Step 10 - Make the header row bold. **


 * Step 11 - Highlight row 1, right click and select Insert, shift cells down **


 * Step 12 - In Cell A1 put your name and the type of party you are planning. **


 * Step 13 - Highlight Cells A1, B1, and C1. **


 * Step1 4 – Click on Format Cells, under alignment click Merge Cells. **


 * Step 15 - Make the font for this row size 14, change the font color to blue, and align center. **


 * Step 16 - Put an addition formula in the cell B10 adding the # of people invited. The formula should look like one of these: **


 * Step 17 - Put an addition formula in the cell C10 adding the # of people attending. The process is the same as above. You may also experiment with using the FUNCTIONS button on the toolbar. **


 * Step 18 - Highlight Cells B2 to B8 & C2 to C8 (hint to highlight: hold the shift key and use the arrow keys to scroll down or hold down on the mouse and drag down to the end of both columns) **


 * Step 19 – Insert a chart that will best fit your data. Give your chart a name and label the horizontal axis and vertical axis **

__ SAVING/SHARING YOUR SPREADSHEET __


 * 1. If you used Excel, save it in the 8th grade tech/party planner folder **
 * 2. If you used Google Spreadsheet follow the instructions below and share it with me. **
 * **Step 1 - In the top right hand corner, click on the blue button that says SHARE. **


 * **Step 2 - On the bottom of the page it says ADD PEOPLE. Enter ****nicole.schroeder.lca@gmail.com **** click on SHARE. **


 * Step 17 - Put an addition formula in the cell C10 adding the # of people attending. The process is the same as above. You may also experiment with using the FUNCTIONS button on the toolbar. **


 * Step 18 - Highlight Cells B2 to B8 & C2 to C8 (hint to highlight: hold the shift key and use the arrow keys to scroll down or hold down on the mouse and drag down to the end of both columns) **


 * Step 19 – Insert a chart that will best fit your data. Give your chart a name and label the horizontal axis and vertical axis **



__ SAVING/SHARING YOUR SPREADSHEET __


 * 1. If you used Excel, save it in the 8th grade tech/party planner folder **
 * 2. If you used Google Spreadsheet follow the instructions below and share it with me. **
 * **Step 1 - In the top right hand corner, click on the blue button that says SHARE. **


 * **Step 2 - On the bottom of the page it says ADD PEOPLE. Enter ****nicole.schroeder.lca@gmail.com **** click on SHARE. **