1. Which of the following is NOT a type of conditional formatting in Excel?

A) Color Scales
B) Icon Sets
C) Text Wrapping
D) Data Bars



2. Which of the following is NOT a type of data validation in Excel?

A) Time
B) Text Length
C) Date
D) Decimal



3. What is the function used to count the number of cells in a range that meet a certain criteria?

A) COUNTIF
B) AVERAGEIF
C) MAXIF
D) SUMIF



4. Which of the following is NOT a sorting option in Excel?

A) Sort by Font
B) Sort by Fill
C) Sort by Conditional Formatting
D) Sort by Color



5. Which of the following functions can be used to search for a value in a table and return a corresponding value in the same row?

A) INDEX
B) MATCH
C) HLOOKUP
D) VLOOKUP