Skip to main content

Transcript

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 easier to read.

Search the internet for additional locations in the area you chose.

Use different search terms and phrases to get different results.

By including different places to visit, eat, or stay, you will create a personalized guide that shows your users what is special, unique, and fun about the area you picked.

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 to make it appear more organized.

You might add 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, you might use alternating colors to make it easier to tell the rows apart.

Select a range of cells and change the formatting to add alternating colors.

You can choose from a variety of color schemes, or choose your own colors.

Now, the colors of each row in your guide alternate making it easier to read.

If necessary, update other formatting options to make your spreadsheet even more organized.

Now, it's your turn: Add at least nine more locations to your area guide spreadsheet, and experiment with formatting options like borders or alternating colors.


Instructions

  1. Add at least nine more locations to your area guide.
  2. Experiment with formatting options like borders or alternating colors.