1.4.4.Weekly challenge 4 - quanganh2001/Google-Data-Analytics-Professional-Certificate-Coursera GitHub Wiki
Glossary: Terms and definitions
We’ve covered a lot of terms—some of which you may have already known, and some of which are new. To make it easy to remember what a word means, we created this glossary of terms and definitions.
To use the glossary for this course item, click the link below and select “Use Template.”
Link to glossary: Week 4 Glossary
OR
If you don’t have a Google account, you can download the glossary directly from the attachment here.
Weekly challenge 4
Question 1
Fill in the blank: In row 1 of the following spreadsheet, the words rank and name are called ____ ?
| - | A | B | C | D |
|---|---|---|---|---|
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
A. attributes
B. descriptors
C. characteristics
D. criteria
The correct answer is A. attributes
Question 2
In the following spreadsheet, the observation of Greensboro describes all of the data in row 4. True or False?
| - | A | B | C | D |
|---|---|---|---|---|
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
A. True
B. False
It is true
Question 3
A data analyst wants to list the cities in this spreadsheet alphabetically, instead of numerically. They can use the feature sort range to do this. True or False?
| - | A | B | C | D |
|---|---|---|---|---|
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
A. True
B. False
It is true.
Question 4
The function =AVERAGE(C2:C11) can be used to do what for the following spreadsheet?
| - | A | B | C | D |
|---|---|---|---|---|
| 1 | Rank | Name | Population | County |
| 2 | 1 | Charlotte | 885,708 | Mecklenburg |
| 3 | 2 | Raleigh | 474,069 | Wake (seat), Durham |
| 4 | 3 | Greensboro | 296,710 | Guilford |
| 5 | 4 | Durham | 278,993 | Durham (seat), Wake, Orange |
| 6 | 5 | Winston-Salem | 247,945 | Forsyth |
| 7 | 6 | Fayetteville | 211,657 | Cumberland |
| 8 | 7 | Cary | 170,282 | Wake, Chatham |
| 9 | 8 | Wilmington | 123,784 | New Hanover |
| 10 | 9 | High Point | 112,791 | Guilford, Randolph, Davidson, Forsyth |
| 11 | 10 | Concord | 96,341 | Cabarrus |
A. Find the average population of the cities
B. Find the city with the largest population
C. Arrange the rows according to decreasing population size.
D. Arrange the rows according to increasing population size.
The correct answer is A. Find the average population of the cities
Question 5
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.
SELECT * FROM employee;
Output:
+-------------+-----------+------------+---------------------+------------+---------------------+---------------------+-----------------------------+------------+-------+---------+-------------+-------------------+-------------------+--------------------------+
| employee_id | last_name | first_name | title | reports_to | birth_date | hire_date | address | city | state | country | postal_code | phone | fax | email |
+-------------+-----------+------------+---------------------+------------+---------------------+---------------------+-----------------------------+------------+-------+---------+-------------+-------------------+-------------------+--------------------------+
| 1 | Adams | Andrew | General Manager | None | 1962-02-18 00:00:00 | 2002-08-14 00:00:00 | 11120 Jasper Ave NW | Edmonton | AB | Canada | T5K 2N1 | +1 (780) 428-9482 | +1 (780) 428-3457 | [email protected] |
| 2 | Edwards | Nancy | Sales Manager | 1 | 1958-12-08 00:00:00 | 2002-05-01 00:00:00 | 825 8 Ave SW | Calgary | AB | Canada | T2P 2T3 | +1 (403) 262-3443 | +1 (403) 262-3322 | [email protected] |
| 3 | Peacock | Jane | Sales Support Agent | 2 | 1973-08-29 00:00:00 | 2002-04-01 00:00:00 | 1111 6 Ave SW | Calgary | AB | Canada | T2P 5M5 | +1 (403) 262-3443 | +1 (403) 262-6712 | [email protected] |
| 4 | Park | Margaret | Sales Support Agent | 2 | 1947-09-19 00:00:00 | 2003-05-03 00:00:00 | 683 10 Street SW | Calgary | AB | Canada | T2P 5G3 | +1 (403) 263-4423 | +1 (403) 263-4289 | [email protected] |
| 5 | Johnson | Steve | Sales Support Agent | 2 | 1965-03-03 00:00:00 | 2003-10-17 00:00:00 | 7727B 41 Ave | Calgary | AB | Canada | T3B 1Y7 | 1 (780) 836-9987 | 1 (780) 836-9543 | [email protected] |
| 6 | Mitchell | Michael | IT Manager | 1 | 1973-07-01 00:00:00 | 2003-10-17 00:00:00 | 5827 Bowness Road NW | Calgary | AB | Canada | T3B 0C5 | +1 (403) 246-9887 | +1 (403) 246-9899 | [email protected] |
| 7 | King | Robert | IT Staff | 6 | 1970-05-29 00:00:00 | 2004-01-02 00:00:00 | 590 Columbia Boulevard West | Lethbridge | AB | Canada | T1K 5N8 | +1 (403) 456-9986 | +1 (403) 456-8485 | [email protected] |
| 8 | Callahan | Laura | IT Staff | 6 | 1968-01-09 00:00:00 | 2004-03-04 00:00:00 | 923 7 ST NW | Lethbridge | AB | Canada | T1H 1Y8 | +1 (403) 467-3351 | +1 (403) 467-8772 | [email protected] |
+-------------+-----------+------------+---------------------+------------+---------------------+---------------------+-----------------------------+------------+-------+---------+-------------+-------------------+-------------------+--------------------------+
What is the job title of Andrew Adams?
A. Sales Support Agent
B. General Manager
C. Sales Manager
D. IT Manager
The job title of Andrew Adams is General Manager
Question 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 54.
You write the SQL query below. Add a WHERE clause that will return only data about the customer with ID number 54.
SELECT * FROM invoice WHERE customer_id = 54;
Output:
+------------+-------------+---------------------+-----------------+--------------+---------------+-----------------+---------------------+-------+
| invoice_id | customer_id | invoice_date | billing_address | billing_city | billing_state | billing_country | billing_postal_code | total |
+------------+-------------+---------------------+-----------------+--------------+---------------+-----------------+---------------------+-------+
| 20 | 54 | 2009-03-22 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 0.99 |
| 141 | 54 | 2010-09-13 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 1.98 |
| 152 | 54 | 2010-10-24 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 13.86 |
| 207 | 54 | 2011-06-24 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 8.91 |
| 336 | 54 | 2013-01-28 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 1.98 |
| 359 | 54 | 2013-05-02 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 3.96 |
| 381 | 54 | 2013-08-04 00:00:00 | 110 Raeburn Pl | Edinburgh | None | United Kingdom | EH4 1HH | 5.94 |
+------------+-------------+---------------------+-----------------+--------------+---------------+-----------------+---------------------+-------+
What is the billing address for the customer with ID number 54?
A. 230 Elgin St
B. 801 W 4th St
C. 1033 N Park Ave
D. 110 Raeburn Pl
The billing address for the customer with ID number 54 is 110 Raeburn Pl. Explain: The clause WHERE customer_id = 54 will return only data about the customer with ID number 54. The complete query is SELECT * FROM invoice WHERE customer_id = 54. The WHERE clause filters results that meet certain conditions. The WHERE clause includes the name of the column, an equals sign, and the value(s) in the column to include. The billing address for the customer with ID number 54 is 110 Raeburn Pl.
Question 7
Fill in the blank: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decide to use the ____ feature to change it to a column chart.
A. image
B. filter view
C. chart editor
D. rename
Explain: A data analyst creates a table, but they realize this isn’t the best visualization for their data. To fix the problem, they decide to use the chart editor feature to change it to a column chart.
Question 8
A data analyst has to demonstrate how the population in Charlotte has increased over time. They create the chart below. What is this type of chart called?
A. Column chart
B. Area chart
C. Bar chart
D. Line chart
The correct answer is D. Line chart