Google Sheets Activity 3

To-Do Date: Aug 28 at 11:59pm

Activity 3: Apply formatting to a Google Sheet

Now it’s your turn. In this activity, you’ll apply formatting to your Google Sheet.
You’ll practice aligning the text and try out two ways to make columns more readable: wrapping text and resizing the column.

Complete the following steps:

1. In your spreadsheet “On the Rise forecast report_YOURNAME”, select Row 1 and change the fill color to orange.

2. Select Rows 1-2, and click the Bold toolbar icon.

3. Merge duplicate cells.

a. Select duplicate instances of Cinnamon bun in row 1 (E1-P1).

b. From the Format menu, select Merge cells and choose Merge all.

c. Merge duplicate instances of the other bakery products in row 1.

4. Select Undo to undo the last merge. Select Redo to return to the merged state.

5. Select Row 1. From the Format menu, select Align and choose Center.

6. Wrap text and resize rows to view contents more easily.

a. Select Column A. From the Format menu, select Text wrapping and choose Wrap.

b. Select Rows 3-102. Double-click the bottom of the row to size to fit OR right-click and select Resize rows 3-102 and choose Fit to data.

7. Resize columns C and D to fit the text. Double-click the right side of each column OR select the columns, then and select Resize columns C-D and choose Fit to data.

a. Column C – Country

b. Column D – Region

8. Add a border to all cells in rows 101 and 102. Select cells A101:AN102, then select Borders, then All borders.

Do not close your Google Sheet. You will use it in the next activity.