1. A data analyst is working with a spreadsheet from a furniture company. To use the template for this spreadsheet, click the link below and select “Use Template.”
Link to template: Sample Transaction Table.
Or, if you don’t have a Google account, download the file directly from the attachment below.
The analyst inputs a function to find the number of transactions that include a brass-colored product. The syntax of which of the following formulas would return that result?
1 / 1 point
Correct
The COUNTIF formula =COUNTIF(F2:F30, “brass”) has a condition that would allow the analyst to count all product color values in Column F that are brass. The condition is “brass,” so this calculation would return a count of 5 because there are 5 values in Column F that are “brass.”
Related Questions & Answers:
- He asks: How would you write a query that retrieves only data about people with the last name Hassan from the Clients table in our database? 9. Scenario 2 continued Next, your interviewer wants to better understand your knowledge of basic SQL commands. He asks: How ... Read more...
- Fill in the blank: Data _____ refers to the accuracy, completeness, consistency, and trustworthiness of data throughout its life cycle. 1. Fill in the blank: Data _____ refers to the accuracy, completeness, consistency, and trustworthiness of data throughout its life ... Read more...
- 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? 5. A data analyst in a human resources department is working with the following selection of a spreadsheet: A ... Read more...
- Fill in the blank: Once data is clean, a data analyst moves on to _____ and verification. 1. Fill in the blank: Once data is clean, a data analyst moves on to _____ and verification. 1 / ... Read more...
- During which of the four phases of analysis can you find a correlation between two variables? 2. During which of the four phases of analysis can you find a correlation between two variables? 1 / 1 ... Read more...
- A data analyst uses an absolute reference to lock a function array so rows and columns don’t change if the function is copied. What symbol is used to create an absolute reference? 4. A data analyst uses an absolute reference to lock a function array so rows and columns don’t change if ... Read more...
