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

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 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

What is the first thing you should do when checking spelling errors in Excel? 1 pointUse a dictionaryFind the misspelled data Click the Spelling button  Select the data you want to check for spelling

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

Question 3A company keeps a record of their customers’ accounts. They use a tool to filter and organize the data. They also implement some formulas on the data. What tool are they using to do this? 1 pointA spreadsheetA word processorA social media platformA recording software