*Weekly challenge 4* >> Foundations: Data, Data, Everywhere
TOTAL POINTS 8
1.In the following spreadsheet, the column labels in row 1 are called what?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
1 point
2.In the following spreadsheet, where can you find all of the attributes — also known as the observation — of Fayetteville?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
1 point
3.Fill in the blank: In the following spreadsheet, the _____ feature was used to alphabetize the city names in column B.
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 7 | Cary | 170,282 | Wake, Chatham |
| 3 | 1 | Charlotte | 885,708 | Mecklenburg |
| 4 | 10 | Concord | 96,341 | Cabarrus |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 6 | Fayetteville | 211,657 | Cumberland |
| 7 | 3 | Greensboro | 296,710 | Guilford |
| 8 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 9 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 10 | 8 | Wilmington | 123,784 | New Hanover |
| 11 | 5 | Winston-Salem | 247,945 | Forsyth |
1 point
4.A data analyst types =POPULATION(C2:C11) to find the average population of the cities in this spreadsheet. However, they realize that have used the wrong formula. What syntax will correct this function?
| A | B | C | D | |
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
1 point
5.When writing a query, what word does a data analyst use to indicate the table from which the data will be retrieved?
1 point
6.You are writing a query that asks a database to retrieve data about the customer with identification number 1057. The column name for customer identification numbers is customer_id. What is the correct SQL clause?
1 point
7.Fill in the blank: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decide to use the _____ feature to change it to a column chart.
1 point
8.A data analyst wants to demonstrate how the population in Charlotte has increased over time. They create this data visualization. This is an example of an area chart.
1 point
Related Questions & Answers:
- *Weekly challenge 1* *Weekly challenge 1* >> Foundations: Data, Data, Everywhere 1. Data analysis is the various elements that interact with one another ... Read more...
- *Weekly challenge 2* *Weekly challenge 2* >> Foundations: Data, Data, Everywhere TOTAL POINTS 8 1.A junior data analyst is seeking out ... Read more...
- *Weekly challenge 3* *Weekly challenge 3* >> Foundations: Data, Data, Everywhere TOTAL POINTS 8 1.In which stage of the data life ... Read more...
- *Weekly challenge 5* *Weekly challenge 5* >> Foundations: Data, Data, Everywhere TOTAL POINTS 8 1.A magazine wants to understand why its ... Read more...
- *Course challenge* *Course challenge* >> Foundations: Data, Data, Everywhere TOTAL POINTS 10 1.Scenario 1, question 1-5 You’ve just started a new ... Read more...
- Structured thinking involves which of the following processes? Select all that apply. 1.Structured thinking involves which of the following processes? Select all that apply. 1 / 1 point Organizing available information ✓ ... Read more...
