W5 Google Sheets Assignment
Your Week 5 assignment centrees on interpreting and displaying the bulky basis you begetd decisive week. You conciliate be agoing delay pivot boards, charts, graphs, and hushs. You are an angel investor looking to acceleration unfold startups in the Portland, Oregon area.
You keep obtained contiguity instruction for manufacturer spaces, incubators, and slender matter accelerators encircling Oregon and failure to centre your basis to ascertain what skin of constructions consist in Oregon and where the prominent ardor of constructions are located.
1) Upload this finish into your Google Drive: Oregon Startup Organizations
2) Select-all your basis and beget a pivot board. Rename your pivot board tab to “List by Type”
3) Beget a new row in your pivot board delay “Type” as your identifier.
4) Uncheck the “show totals” non-interference in your new row
5) Beget a new esteem delay “Type” as your identifier, and use COUNTA as your character.
6) Look at your counted basis and introduce a hush delay the character of construction (makerspace, accelerator, incubator) that has the prominent sum of basis rows.
7) Introduce a pie chart present to your pivot board that graphically displays the tamedown of constructions by character.
8) Return to your primordial spreadsheet, prime all intermittently, and beget a avoid pivot chart. Rename the tab for this pivot chart “List by Area”
9) Beget a new row delay “Service Area” as your identifier and deprime the “show totals” non-interference.
10) Beget a new esteem delay “Service Area” as your identifier and use the COUNTA character to coincide the constructions by area. Beget a new Column delay “Type” as the identifier. This conciliate tame down the basis smooth exalt into characters of constructions ordered by labor area.
11) Introduce a hush environing the area or areas where you could target the most incubators.
12) On the deep spreadsheet, use compulsory formatting to highunsubstantial any construction character that’s labeled “incubator” in Column G delay unsubstantial inexperienced.
13) Use compulsory formatting in Column F to highunsubstantial any cell that has the term “Metro” in it delay unsubstantial cerulean.
14) Share your workbook and set to “anyone delay a grantham.edu oration can EDIT”. Copy and paste the converge into your W5 assignment dropbox.