*Weekly Challenge 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)

=AVERAGE(C2:C11)

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

Attributes

A data analyst creates the following visualization to clearly demonstrate how much more populous Charlotte is than the next-largest North Carolina city, Raleigh. It's called a line chart. True False

False

A data analyst wants to demonstrate a trend of how something has changed over time. What type of chart is best for this task? Column Line Area Bar

Line

In the following spreadsheet, what feature was used to alphabetize the city names in column B? Randomize range Name range Sort range Organize range

Sort range

You are working with a database table named employee that contains data about employees. 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 employee table. What employee has the job title of Sales Manager? Nancy Edwards Margaret Park Andrew Adams Michael Mitchell

Nancy Edwards

Fill in the blank: In row 8 of the following spreadsheet, you can find the _____ of Cary. observation attribute format criteria

observation

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? Argentina Portugal India Ireland

Portugal