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

 (Link to PDF Directions)

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 

Sample Image for Spreadsheet Formatting 

 

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

Sample Image for Spreadsheet 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. 

 


Resources
External Link    Spreadsheet Help From Google   
External Link    Using Google Spreadsheets from About.com


GreenCheckMarkCheck this Quest off your Tracking Document

 

You have completed 0% of the lesson
0%