Layer 1 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? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst writes a query that asks a database to return the number of rows in a specified range. Which function do they use? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When creating a SQL query, which JOIN clause returns all matching records in two or more database tables? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst wants to be sure all of the numbers in a spreadsheet are numeric. What function should they use to convert text to numeric values? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In data analytics, what is the process of gathering data from multiple sources and combining it into a single, summarized collection? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When creating a SQL query, which JOIN clause returns only records with matching values in two or more database tables? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When using VLOOKUP, there are some common limitations that data analysts should be aware of. One of these limitations is that VLOOKUP can only return a value from the data to the left of the matched value. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When working with subqueries, which part of the query segment executes first? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 In data analytics, what is data aggregation? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 An INNER JOIN is a function that returns records with matching values in two or more tables. An OUTER JOIN is a function that combines RIGHT and LEFT JOIN to return all matching records in both tables. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst creates an absolute reference around a function array. What is the purpose of the absolute reference? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 When using VLOOKUP, there are some common limitations that data analysts should be aware of. One of these limitations is that VLOOKUP only returns the first match it finds, even if there are many possible matches within the column. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 The VALUE function converts a numeric value into a text string in a spreadsheet. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 The COUNT DISTINCT function includes repeating values when returning values in a specified range. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: When writing a function, a data analyst wraps a table array in dollar signs. This is an _____ , which is used to lock the array so rows and columns don’t change if the function is copied. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst writes a query that asks a database to return only distinct values in a specified range, rather than including repeating values. Which function do they use? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 Fill in the blank: Data aggregation involves creating a _____ collection of data that originally came from multiple sources. Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 To search for the population of Brazil, what is the correct VLOOKUP syntax? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You are creating a spreadsheet to help you with your job search. Every time you find an interesting job, you add it to the spreadsheet. Then, you want to indicate two possible options: Need to Apply or Applied. What spreadsheet tool will save you time by enabling you to create a dropdown list with Need to Apply and Applied as the possible options? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 An analyst notes that the “160” in cell A9 is formatted as text, but it should be Australian dollars. What spreadsheet tool can help them select the right format? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst wants to write a SQL query to combine data from two columns and into a new column. What function can they use? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 A data analyst in human resources uses a spreadsheet to keep track of employees’ work anniversaries. They add color to any employee who has worked for the company for more than 10 years. Which spreadsheet tool changes how cells appear when values equal 10 or more? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You are using a spreadsheet to keep track of your newspaper subscriptions. You add color to indicate if a subscription is current or has expired. Which spreadsheet tool changes how cells appear when values meet each expiration date? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions
Layer 1 You are using a spreadsheet to organize a list of upcoming home repairs. Column A contains the list of repairs, and column B notes the priority of each item on the list: High Priority or Low Priority. What spreadsheet tool can you use to create a drop-down list of priorities for each cell in column B? Layer 1 View Answers Layer 1 Ask Question Data Analysis Data Science Questions