# 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

• 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)

• Jazz
• Rock
• Metal
• Blues

• 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

• Area
• Column
• Line
• Bar

#### 9. Fill in the blank: In row 1 of the following spreadsheet, the words rank and name are called _____?

• attributes
• characteristics
• criteria
• descriptors

• Row 7
• Column B
• Row 6
• Cell B7

• change
• alphabetize
• randomize
• delete

#### 12. The function =AVERAGE(C2:C11) can be used to do what for the following spreadsheet?

• Arrange the rows according to increasing population size.
• Find the city with the largest population.
• Arrange the rows according to decreasing population size.
• Find the average population of the cities

#### What employee has the job title of Sales Manager?

• Nancy Edwards
• Margaret Park
• Michael Mitchell

• Paris
• Dijon
• London
• Buenos Aires

#### 15. A data analyst has to create a visualization that makes it easy to show which of the top ten most populous cities in North Carolina have a population below 250,000 people. What type of chart would be best for this visualization?

• Line chart
• Pie chart
• Bar chart
• Scatter chart

• True
• False

#### 17. In row 1 of the following spreadsheet, the words rank, name, population, and county are called what?

• Attributes
• Descriptors
• Criteria
• Characteristics

#### 18. In the following spreadsheet, what feature was used to alphabetize the city names in column B?

• Organize range
• Sort range
• Name range
• Randomize range

• (C2,C11)
• (C2-C11)
• (C2:C11)
• (C2*C11)

• Audiobooks
• Music
• Movies
• TV Shows

#### After you run your query, use the slider to view all the data presented.What is the billing city for the customer with ID number 28?

• Bangalore
• Buenos Aires
• Dijon
• Salt Lake City

#### 22. Which of the following best describes a bar chart?

• It is a visualization that uses a circle which is divided into wedges sized based on numerical proportion.
• It is a visualization that plots a sequence of points and connects them with them with straight lines or curves.
• It is a visualization that represents data with columns, or bars, the heights of which are proportional to the values that they represent.
• It is a visualization that plots individual points in the Cartesian coordinate plane.

#### 23. A data analyst has to create a visualization that clearly shows when and for how long the population of Charlotte has been above one million people. They choose to use a line chart. Why is this the best choice for their visualization?

• It is a visualization that plots a sequence of points and connects them with straight lines or curves.
• It is a visualization that uses a circle which is divided into wedges sized based on numerical proportion.
• It is a visualization that represents data with columns, or bars, the heights of which are proportional to the values that they represent.
• It is a visualization that plots individual points in the Cartesian coordinate plane.

• True
• False

• criteria
• dataset
• observation
• format

#### 26. If a data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically, what feature can they use in column B?

• Sort range
• Name range
• Randomize range
• Organize range

#### 27. A data analyst wants to create a visualization that depicts the populations of the top ten most populous cities in North Carolina. What type of chart would be best for this?

• A pie chart
• A scatter chart
• A column, or bar, chart
• A line chart

• Line
• Area
• Bar
• Column

#### After you run your query, use the slider to view all the data presented.What is the billing address for the customer with ID number 54?

• 1033 N Park Ave
• 230 Elgin St
• 110 Raeburn Pl
• 801 W 4th St

• chart editor
• rename
• filter view
• image

#### What is the job title of Andrew Adams?

• General Manager
• Sales Manager
• Sales Support Agent
• IT Manager

#### 32. Fill in the blank: Suppose you wanted to determine the average population of the cities in the following spreadsheet. The correct function syntax to use would be ________ .

• =AVERAGE(C2-C11)
• AVERAGE(D2:D11)
• AVERAGE(C2:C11)
• =AVERAGE(C2:C11)

• True
• False

• True
• False

#### 35. A company is curious about the population trend in Charlotte, NC. A data analyst in the company is tasked with creating a visualization that depicts such information. What type of chart would be best for this task and why?

• A pie chart because it plots a sequence of points and connects them with straight lines or curves.
• A line chart because it plots a sequence of points and connects them with straight lines or curves.
• A line chart because it is a visualization that uses a circle which is divided into wedges sized based on numerical proportion.
• A bar chart because it is a visualization that represents data with columns, or bars, the heights of which are proportional to the values that they represent.

#### 36. To find the average population of the cities in this spreadsheet, what is the correct AVERAGE function syntax? Type your answer below.

• AVERAGE(C2-C11)
• =AVERAGE(C2-C11)
• =AVERAGE(C2:C11)
• AVERAGE(C2:C11)

#### 37. 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 50.You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 50.

After you run your query, use the slider to view all the data presented.

What is the billing city for the customer with ID number 50?

• Paris
• Bangalore
• Tokyo

• area
• line
• bar
• column

• True
• False

• Area chart
• Column chart
• Line chart
• Bar chart

#### 41. In the following spreadsheet, the feature sort range was used to do what?

• Randomize the rank
• Randomize the population
• Alphabetize column B
• Alphabetize column D

#### 42. 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 7.You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 7.

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 7?

• France
• Austria
• Poland
• Brazil