foundations data data everywhere weekly challenge 4 answers
1. In the following spreadsheet, the column labels in row 1 are called what?
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-24-at-6.44.59-AM.png)
- Criteria
- Attributes
- Descriptors
- Characteristics
2. Fill in the blank: In row 8 of the following spreadsheet, you can find the _____ of Cary.
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-24-at-6.46.32-AM.png)
- format
- attribute
- criteria
- observation
3. Fill in the blank: In the following spreadsheet, the _____ feature was used to alphabetize the city names in column B.
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-24-at-6.48.40-AM.png)
- Organize range
- Name range
- Randomize range
- Sort range
4. A data analyst types =POPULATION(C2:C11) to find the average population of the cities in this spreadsheet. However, they realize they used the wrong formula. What syntax will correct this function?
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-24-at-6.49.37-AM.png)
- =AVERAGE(C2-C11)
- AVERAGE(C2:C11)
- AVERAGE(C2-C11)
- =AVERAGE(C2:C11)
5. You are working with a database table named genre that contains data about music genres. You want to review all the columns in the table.
You write the SQL query below. Add a FROM clause that will retrieve the data from the genre table.
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-24-at-6.51.07-AM.png)
What is the name of the genre with ID number 3?
- Jazz
- Rock
- Metal
- Blues
6. You are working with a database table that contains invoice data. The customer_id column lists the ID number for each customer. You are interested in invoice data for the customer with ID number 35.
You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 35.
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-24-at-6.52.40-AM.png)
After you run your query, use the slider to view all the data presented.
What is the billing country for the customer with ID number 35?
- Ireland
- Argentina
- Portugal
- India
7. A data analyst creates the following visualization to clearly demonstrate how much more populous Charlotte is than the next-largest North Carolina city, Raleigh. What type of chart is it?
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-24-at-6.54.08-AM.png)
- A scatter chart
- A column, or bar, chart
- A line chart
- A pie chart
8. A data analyst wants to demonstrate a trend of how something has changed over time. What type of chart is best for this task?
- Area
- Column
- Line
- Bar
Shuffle Q/A 1
9. Fill in the blank: In row 1 of the following spreadsheet, the words rank and name are called _____?
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-27-at-12.42.05-PM.png)
- attributes
- characteristics
- criteria
- descriptors
10. In the following spreadsheet, where can you find all of the attributes—also known as the observation—of Fayetteville?
![](https://thewodm.com/wp-content/uploads/2022/11/Screenshot-2023-04-27-at-12.43.17-PM.png)
- Row 7
- Column B
- Row 6
- Cell B7