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

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

When in the data preprocessing phase, how should one treat missing/null values?Remove the rows with missing values.Fill Missing values with the most common value in the column.Remove the whole column if it has more than 2% of the total size of the dataset as missing values.

Question 2Fill in the blank: Data analysts can use _____ to highlight the area around cells in order to see spreadsheet data more clearly.1 pointfiltersborderspivot tablesitalics