Google Sheets Activity 2
To-Do Date: Sep 5 at 11:59pmActivity 2: Manage data in Google Sheets
In this activity you’ll explore how to add, copy, and paste data. You’ll also practice sorting and
filtering data. Use your spreadsheet from the previous activity.
Complete the following steps:
1. Open your Google Sheets spreadsheet from the previous activity “On the Rise forecast report_YOURNAME.”
2. Update cells A101-G101 by adding a city, state/province, country, region, and January, February and March monthly values.
(Use Greenwood, IN, USA, North America - Central, and 9409, 10327, and 9735)
3. Open Fort Lauderdale On the Rise forecast data Links to an external site. in a separate tab.
4. Copy cells A8-D8 from “Fort Lauderdale On the Rise forecast data” and paste them into row 102 in “On the Rise forecast report_YOURNAME.” Select Paste special and choose Paste values only.
5. Copy cells F8-AO8 from “Fort Lauderdale On the Rise forecast data” and paste them into row 102, starting at cell E102 in “On the Rise forecast report_YOURNAME.” Select Paste special and choose Paste values only.
6. Close the “Fort Lauderdale On the Rise forecast data” tab.
7. Sort the data in “On the Rise forecast report_YOURNAME.”
a. To sort by country, select Column C and select the down arrow. Choose Sort sheet A → Z.
b. To sort by region, select Column D and select the down arrow. Choose Sort sheet A → Z.
8. Filter data by region.
a. Select Column D and select Create a filter from the toolbar.
b. Select Filter in the top right corner of the cells to open the filter options menu.
c. Filter by values to view the data from only certain regions. Explore what happens when you filter to see the data from North America – Canada or North America – Mexico. Then, try filtering to see the data from regions outside of the USA.
9. Select Turn off filter to remove the filter.
Do not close your Google Sheet. You will use it in the next activity