foundations data data everywhere weekly challenge 4 answers
1. In the following spreadsheet, the column labels in row 1 are called what?
- Criteria
- Attributes
- Descriptors
- Characteristics
2. Fill in the blank: In row 8 of the following spreadsheet, you can find the _____ of Cary.
- 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.
- 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?
- =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.
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.
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?
- 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 _____?
- attributes
- characteristics
- criteria
- descriptors
10. In the following spreadsheet, where can you find all of the attributes—also known as the observation—of Fayetteville?
- Row 7
- Column B
- Row 6
- Cell B7
