4.1 - Introduction to Google Spreadsheets
4.2 - Create, Edit & Format a Spreadsheet
4.3 - Working with Sheets, Rows & Columns
4.4 - Charts in Spreadsheets
4.5 - Activity: Your Class Schedule
4.6 - Activity: Statement of Income
4.7 - Activity: Salary Comparison
4.8 - Activity: Conditional Formatting & Sorting
4.9 - Activity: Functions
Activity: See detailed directions below...
Download and save to file: Conditional Formatting and Sort data file (available below as an attachment)
Open Google Spreadsheets. Title new spreadsheet as Conditional Formatting and Sort.
Under File, click on Import. Select “Insert new sheet(s)”, then choose the above file you just saved to your file and import it.
Rename the worksheet (bottom left hand corner) as Formatting and Sort. Delete all other empty worksheets.
Hide Column B
Merge the following cells
A4:D4
A19:D19
G18:J18
Adjust Column A to fit data.
Type in today’s date in A4 and your name after Prepared by: in A19.
Bold Row A1:K3. Change the cell color to red and the text color to white.
Bold Row 6. Click on Wrap Text button. Adjust column widths to fit data as needed.
Bold G18:K18
Select H7:H16. Apply the following two conditional formatting rules (under the Format menu):
Greater Than 2, Background is neon green
Is Between 1 and 2, Background is neon yellow
Select I7:I16. Apply the following conditional formatting rule (under the Format menu):
Apply Greater Than 16, Text is Red
Select A6:K6. Click on the Filter button .
Sort by A to Z by Last Name.
Submit to your teacher (with the ability to edit).
Google Apps 101 by Kurt Wismer is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike 4.0 International License.