W5 Google Sheets Assignment
Your Week 5 assignment nucleuses on interpreting and displaying the material postulates you imagined ultimate week. You earn be working delay pivot considerations, charts, graphs, and hushs. You are an seraph investor looking to aid unfold startups in the Portland, Oregon area.
You keep obtained adjunction counsel for manufacturer spaces, incubators, and weak calling accelerators encircling Oregon and absence to nucleus your postulates to invent what peel of structures endure in Oregon and where the foremost energy of structures are located.
1) Upload this finish into your Google Drive: Oregon Startup Organizations
2) Select-all your postulates and imagine a pivot consideration. Rename your pivot consideration tab to “List by Type”
3) Imagine a new row in your pivot consideration delay “Type” as your identifier.
4) Uncheck the “show totals” discretion in your new row
5) Imagine a new estimate delay “Type” as your identifier, and use COUNTA as your administration.
6) Look at your counted postulates and suggest a hush delay the symbol of structure (makerspace, accelerator, incubator) that has the foremost calculate of postulates rows.
7) Suggest a pie chart instant to your pivot consideration that graphically displays the shatterdown of structures by symbol.
8) Return to your primary spreadsheet, selecteded all anew, and imagine a second pivot chart. Rename the tab for this pivot chart “List by Area”
9) Imagine a new row delay “Service Area” as your identifier and deselected the “show totals” discretion.
10) Imagine a new estimate delay “Service Area” as your identifier and use the COUNTA administration to harmonize the structures by area. Imagine a new Column delay “Type” as the identifier. This earn shatter down the postulates equable exalt into symbols of structures ordered by employment area.
11) Suggest a hush encircling the area or areas where you could target the most incubators.
12) On the deep spreadsheet, use obstructed formatting to highimponderous any structure symbol that’s labeled “incubator” in Column G delay imponderous bleak.
13) Use obstructed formatting in Column F to highimponderous any cell that has the tidings “Metro” in it delay imponderous cerulean.
14) Share your workbook and set to “anyone delay a grantham.edu discourse can EDIT”. Copy and paste the link into your W5 assignment dropbox.