Challenge 2

Challenge2

Formatting cells

Every cell in a new spreadsheet uses the same default formatting. As you begin to build a spreadsheet, you can customize the formatting to make your information easier to view and understand. In our example, we will be using a spreadsheet to plan and organize a garden plot.

1. Open our example file. Make sure you're signed in to Google, then click File > Make a copy.
2. Select cells A1:E6. Change the horizontal alignment to center and the vertical alignment to middle.
3. Select cells B3:E3. Bold the text and add an outside border.
4. Select the merged cell in row 1 and change the font to something other than Arial.
5. With the cell still selected, change the font size to 18 pt and bold the text.
6. For the same cell, change the fill color to purple and the font color to white.
7. When you're finished, your spreadsheet should look something like this: