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

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

"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

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

What is the primary purpose of a Pivot Table in Excel?Group of answer choicesData sortingData encryptionData analysis and summarizationData validation