4.2.3.Weekly challenge 2 - sj50179/Google-Data-Analytics-Professional-Certificate GitHub Wiki
LATEST SUBMISSION GRADE 100%
Question 1
As part of the data-cleaning process, a data analyst creates a rule to highlight any empty cells in a bright blue color. This is an example of data visualization.
True- False
Correct. Highlighting empty cells in a bright blue color is an example of conditional formatting.
Question 2
A data analyst at a nonprofit organization is working with a spreadsheet that contains member name data in column C. They want to divide this data so that first names are stored in one column and last names in another. Which tool should the analyst use?
| Data | A | B | C |
|---|---|---|---|
| 1 | Member Number | Date joined | LastFirst |
| 2 | 100582 | 9/29/16 | Yolanda_Dennis |
| 3 | 195785 | 4/7/20 | Josefina_Elliott |
| 4 | 137621 | 10/28/17 | Vernon_Moreno |
| 5 | 145202 | 1/12/18 | Cedric_Higgins |
Pivot tableMID function- SPLIT function
Conditional formatting
Correct. To move the first and last names in column C to their own columns, a data analyst would use the SPLIT function.
Question 3
Fill in the blank: A predetermined structure that includes a function’s required information and its proper placement is called _____.
structurestandard- syntax
script
Correct. Syntax is a predetermined structure that includes a function’s required information and its proper placement.
Question 4
You are working with the following selection of a spreadsheet:
| Data | A | B |
|---|---|---|
| 1 | Customer | Address |
| 2 | Sally Stewart | 9912 School St. North Wales, PA 19454 |
| 3 | Lorenzo Price | 8621 Glendale Dr. Burlington, MA 01803 |
| 4 | Stella Moss | 372 W. Addison Street Brandon, FL 33510 |
| 5 | Paul Casey | 9069 E. Brickyard Road Chattanooga, TN 37421 |
In order to extract the five-digit postal code from Burlington, MA, what is the correct function?
=LEFT(5,B3)=LEFT(B3,5)- =RIGHT(B3,5)
=RIGHT(5,B3)
Correct. The correct syntax is =RIGHT(B3,5)*. The RIGHT function returns a set number of characters from the right side of a text string. B3 is the specified cell. And 5 is the number of characters to return.*
Question 5
A data analyst in a human resources department is working with the following selection of a spreadsheet:
| Data | A | B | C | D |
|---|---|---|---|---|
| 1 | Year Hired | Last 4 of SS# | Department | Employee ID |
| 2 | 2019 | 1192 | Marketing | |
| 3 | 2014 | 2683 | Operations | |
| 4 | 2020 | 1939 | Strategy | |
| 5 | 2009 | 3208 | Graphics |
They want to create employee identification numbers (IDs) in column D. The IDs should include the year hired plus the last four digits of the employee’s Social Security Number (SS#). What function will create the ID 20093208 for the employee in row 5?
- =CONCATENATE(A5,B5)
=CONCATENATE(A5!B5)=CONCATENATE(A5*B5)=CONCATENATE(A5+B5)
Correct. To create the ID 20093208 for the employee in row 5, the function is =CONCATENATE(A5,B5)*. CONCATENATE joins together two or more text strings. (A5,B5) are the locations of the strings to be joined.*
Question 6
An analyst is cleaning a new dataset containing 500 rows. They want to make sure the data contained from cell B2 through cell B300 does not contain a number greater than 50. Which of the following COUNTIF function syntaxes could be used to answer this question? Select all that apply.
- =COUNTIF(B2:B300,”<=50”)
=COUNTIF(B2:B300,<=50)- =COUNTIF(B2:B300,">50")
=COUNTIF(B2:B300,>50)
*Correct. One possible syntax is **=COUNTIF(B2:B300,">50"*). This returns the number of cells that are greater than 50. Another option is =COUNTIF(B2:B300,<=50). This returns the number of cells that are less than or equal to 50. Either one can confirm that the data does not contain a number greater than 50.
Question 7
A data analyst wants to search for a certain value in a column, then return a corresponding piece of information. Which function should they use?
- VLOOKUP
FINDMATCHVALUE
Correct. VLOOKUP is used to search for a certain value in a column, then return a corresponding piece of information.
Question 8
A data analyst needs to combine two datasets. Each dataset comes from a different system, and the systems store data in different ways. What can the data analyst do to ensure the data is compatible?
Use a data visualization- Map the data
Apply a data structureMerge the data
Correct. Data analysts use data mapping to note differences in data sources in order to ensure the data is compatible.