11. A data analyst is using a function in a spreadsheet. For the function to work correctly, they follow the function’s syntax. What does this entail?
- It is the function’s name and placement.
- It is how the function can be used in a program.
- It is the function’s required information and its proper placement.
- It is the purpose of the function and its use.
12. In a spreadsheet, what is the correct function for extracting the first two characters of the string located in cell A7?
- =LEFT(A7,2)
- =LEFT(2,A7)
- =RIGHT(A7,2)
- =RIGHT(2,A7)
13. Fill in the blank: In a spreadsheet, the function VLOOKUP is used to _____ information in a column based on a specified data value.
- return
- replace
- transform
- delete
14. What describes syntax?
- It is the function’s required information and its proper placement.
- It is how the function can be used in a program.
- It is the purpose of the function and its use.
- It is the function’s name and placement.
15. A 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 last four digits of the employee’s Social Security Number(SS#) plus the year hired. What function will create the ID 19392020 for the employee in row 4?
- =CONCATENATE(B4+A4)
- =CONCATENATE(B4,A4)
- =CONCATENATE(A4+B4)
- =CONCATENATE(A4!B4)
16. An analyst is cleaning a new dataset. They want to determine how many of the cells in column F have a value of 0. However, they only want rows 7 to 120 to be considered. Which COUNTIF function syntax can be used to answer this question?
- =COUNTIF(F2:F1250, 0)
- =COUNTIF(F7:F120, =0)
- =COUNTIF(F7:F120,”0″)
- =COUNTIF(F7:F120,”=0”)
17. 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 prior to analyzing the data?
- Use a data visualization
- Map the data
- Spot check for null values
- Apply a data structure
18. A data analyst is working on a spreadsheet in which one of the columns contains name data. This data is formatted as lastname_firstname. The analyst splits this data at the underscore so that each piece—firstname and lastname—are contained in their own columns.
In this context, what is the underscore acting as?
- Partition
- Delimiter
- Substring
- MID function
Shuffle Q/A 2
19. A data analyst is using a function in a spreadsheet. When they input the function, they follow a predetermined structure that includes all required information for the function and its proper placement. What aspect of a function does this describe?
- The specified value of the function
- The syntax of the function
- The length of the function
- The number of characters in the function
20. You are working with the following selection of a spreadsheet:
In order to extract the five-digit postal code from Brandon, FL, what is the correct function?
- =RIGHT(5,B4)
- =RIGHT(B4,5)
- =LEFT(B4,5)
- =LEFT(5,B4)
