In this video, you will add additional locations to your spreadsheet until you have
at least ten locations in your guide.
Then, you will use fill colors, alternating colors, and other formatting tools
to make your area guide more easy to use.
Search the internet for additional locations in the area you chose.
Use different search terms and phrases to get different results.
Add a name, address, description, and category to your spreadsheet for each location.
Add at least ten locations.
Then, add additional formatting to your spreadsheet.
Add colors or borders to cells, columns, or rows, to make your guide easier to read.
For example, you could add a border to the first row so that your headings stand out
even more.
Or, use alternating colors to make it easier to tell the rows apart.
Select the range of cells whose colors you want to alternate.
Choose “Format” and “Alternating colors.”
Then, select from a variety of color styles, or create your own.
Now, the colors you chose will alternate in the spreadsheet rows.
Update other formatting options to match.
Make sure your spreadsheet is easy to read.
Then, move on to the next video to wrap up this activity.
Now, it’s your turn:
Add nine more locations to your area guide spreadsheet so you have a total of at least ten.
Experiment with formatting options like fill colors, borders, or alternating colors
to make your spreadsheet lively and easy to read.
Then, move on to the next video.