LATEST SUBMISSION GRADE 100% 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. Correct. Highlighting empty cells in a bright blue color is an example of conditional formatting. 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?
Correct. To move the first and last names in column C to their own columns, a data analyst would use the SPLIT function. Question 3Fill in the blank: A predetermined structure that includes a function’s required information and its proper placement is called _____.
Correct. Syntax is a predetermined structure that includes a function’s required information and its proper placement. Question 4You are working with the following selection of a spreadsheet:
In order to extract the five-digit postal code from Burlington, MA, what is the correct function?
Correct. The correct syntax is Question 5A data analyst in a human resources department is working with the following selection of a spreadsheet:
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?
Correct. To create
the ID 20093208 for the employee in row 5, the function is Question 6An 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.
*Correct. One possible syntax is ** Question 7A data analyst wants to search for a certain value in a column, then return a corresponding piece of information. Which function should they use?
Correct. VLOOKUP is used to search for a certain value in a column, then return a corresponding piece of information. Question 8A 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?
Correct. Data analysts use data mapping to note differences in data sources in order to ensure the data is compatible. 🗂️ Page Index for this GitHub WikiWhich of the following are the responsibilities of a data analyst?What are the duties and responsibilities of a Data Analyst? Data analysts are responsible for analyzing data using statistical techniques, implementing and maintaining databases, gathering data from primary and secondary sources, identifying, analyzing and interpreting trends from the data.
What are the most common process and procedures handled by data engineers?These are some common tasks you might perform when working with data: Acquire datasets that align with business needs. Develop algorithms to transform data into useful, actionable information. Build, test, and maintain database pipeline architectures.
What do data analyst use to label the type of data contained in each column in a spreadsheet?Correct: To label the type of data contained in each column in a spreadsheet, data analysts use attributes.
Which of the following tasks can data analysts do using both spreadsheets and SQL?Which of the following tasks can data analysts do using both spreadsheets and SQL? Select all that apply. Correct. Analysts can use SQL and spreadsheets to perform arithmetic, use formulas, and join data.
|