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

LATEST SUBMISSION GRADE 100%

Question 1

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

• Descriptors

• Characteristics

• Attributes

• Criteria

Correct. These words are attributes, referring to the information in the columns below. An attribute is a characteristic or quality of data used to label a column in a table.

Question 2

In the following spreadsheet, where can you find all of the attributes -- also known as the observation -- of Fayetteville?

• Cell B7

• Row 6

• Row 7

• Column B

Correct. The observation for Fayetteville is in row 7. An observation is all of the attributes for something contained in a row of a data table.

Question 3

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

• Sort range

• Name range

• Randomize range

• Organize range

Correct. Sort range was used to alphabetize the city names in column B. Sorting a range of data from A to Z helps data analysts organize and find data more quickly.

Question 4

To find the average population of the cities in this spreadsheet, what is the correct AVERAGE function syntax?

• C2*C11

• C2:C11

• C2-C11

• C2,C11

Correct. The range is C2:C11. The full AVERAGE function syntax is =AVERAGE(C2:C11). AVERAGE returns an average of values from a selected range. C2:C11 is the specified range.

Question 5

When writing a query, what word does a data analyst use to indicate the table from which the data will be retrieved?

• SELECT

• WHERE

• TABLE

• FROM

Correct. In a query, data analysts use FROM to indicate the table from which the data will be retrieved.

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

• WHERE customer_id is 1057

• WHERE_customer_id=1057

• WHERE customer_id 1057

• WHERE customer_id = 1057

Correct. The correct WHERE clause syntax is WHERE customer_id = 1057. WHERE is used to extract only those records that meet a specified criteria. customer_id = 1057 tells the database to return only information about the customer whose ID is 1057.

Question 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 line chart

• A column, or bar, chart

• A pie chart

Correct. The chart is a column chart. A column chart is effective at demonstrating the differences between several items in a specific range of values.

Question 8

A data analyst wants to demonstrate how the population in Charlotte has increased over time. They create the chart below. What is this type of chart called?

• Area chart

• Line chart

• Column chart

• Bar chart

Correct. This is a line chart. Line charts are effective for demonstrating trends and patterns, such as how population changes over time.