A junior data analyst needs to search their spreadsheet for a particular client ID. In order to identify all cells containing the ID, they use a spreadsheet tool that changes how cells appear when values meet specific conditions. What tool do they use?1 pointField lengthCell filteringData mergingConditional formatting

Question 8A data professional discovers that a client name has been misspelled numerous times within a spreadsheet. In order to find each of those misspellings, they use a spreadsheet tool that changes how cells appear when values meet specific conditions. What tool do they use?1 pointData mergingCell filteringField lengthConditional formatting9.Question 9

Question 8A data analyst suspects that there are some nulls in their spreadsheet. In order to identify those missing values, they use a spreadsheet tool that changes how cells appear when values meet specific conditions. What tool do they use?0 / 1 pointConditional formattingData mergingField lengthCell filtering

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?

Question 4A data analyst selects Format Cells and the option Text Is Exactly Baseball. This changes the color of all the cells that contain the word “Baseball.” What spreadsheet tool is the analyst using?1 pointConditional formattingData validationFilteringCONVERT

Which of the following tools can be used for data analysis?ExcelRPythonAll of the above