Introduction to

Google Sheets - Part 2

GCF Global Online

CAMERA’s ON &

FACE VISIBLE

for the duration of class!

Challenges - Part 2

1. Open our example file (click filename). Make sure you're signed in to Google, then click File > Make a copy.
2. Change the row height of all of the rows to be smaller.
3. Merge cells A1:I1.
4. Insert a row below row 10 and type your name in the first cell.
5. Delete row 7. This row contains the name Ben Mathis.
6. Insert a column between columns G and H and type Total Quantity as the column header.
7. Select cells A2:J2, change them to wrap text, and center align them.
8. Freeze the top two rows.

Challenges - Solution 2

Introduction to

Google Sheets - Part 3

GCF Global Online

CAMERA’s ON &

FACE VISIBLE

for the duration of class!

Challenges - Part 3

• Open our example spreadsheet (click filename). Make sure you're signed in to Google, then click File > Make a copy.
• Select cells A1:E6. Change the horizontal alignment to center and the vertical alignment to middle.
• Select cells B3:E3. Bold the text and add an outside border.
• Select the merged cell in row 1 and change the font to something other than Arial.
• With the cell still selected, change the font size to 18 pt and bold the text.
• For the same cell, change the fill color to purple and the font color to white.

Challenges - Solution 3

Introduction to

Google Sheets - Part 4

GCF Global Online

CAMERA’s ON &

FACE VISIBLE

for the duration of class!

Challenges - Part 4

• Open our example file (click filename). Make sure you're signed in to Google, then click File > Make a copy.
• Select the Challenge sheet.
• In cell D4, create a formula that multiplies cells B4 and C4. Be sure to use cell references.
• Use the fill handle to copy the formula to cells D5 and D6.
• In cell D7, create a formula that adds cells D4, D5, and D6.
• Change the quantity in cell B4 to 15. You should also see cells D4 and D7 change.

Challenges - Solution