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 MS Excel feature is most often used as color-based formatting to highlight, emphasize or differentiate among data and information stored in a spreadsheet?"Conditional formattingData analysisData validationData sort

Which of the following tools in Excel can be used for data validation?Pivot tableData validation toolConditional formattingFilter tool

Which feature allows you to format cells based on their values? aCharting bCell Formatting cConditional Formatting dData Validation

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

Match the FollowingPivotTablesConditional FormattingData ValidationVLOOKUPINDEX/MATCHProvides a way to format cells based on certain conditions being met.Matches data from one range to another based on a specified criteria.Used for dynamic data analysis and summarization, especially for large datasets.Allows you to retrieve values from a specific cell within a table/array. Restricts input into a cell based on predefined criteria, such as a range of values or a list.SubmitReset AnswerPreviousNext