Spreadsheet Mission
You have earned 0 point(s) out of 0 point(s) thus far.
Spreadsheet Quest 2: Format, Insert and Merge
Video hosted at Vimeo.com and created by Kathy Campau and Renee Jorae
Introduction
You have set up your basic spreadsheet for your party and have entered the data. There are special formatting features you can do to make it more readable for others.
Format your spreadsheet
Step 1 - Open the existing Party Planner spreadsheet.
Step 2 - Align the text for column B and C so it is in the center.
Step 3 - 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 4 - Put a border around each cell.
Step 5 - Have a row labeled TOTALS in cell A9 and make it bold.
Step 6 - Make the header row bold.
Insert and Merge
Step 1 - Highlight row 1, go to INSERT on the menu bar and select ROW ABOVE
Step 2 - In Cell A1 put your name and the type of party you are planning.
Step 3 - Highlight Cells A1, B1, and C1.
Step 4 - Click on the Merge Cells Button.
Step 5 - Make the font for this row size 14, change the font color to blue, and align center.
Step 6 - Check with your SSI Department Chief to see how they want you to submit or share this document.
Check this Quest off your Tracking Document
You have completed 0% of the lesson