1. Which of the following functions can be used to calculate the sum of a range of cells based on multiple criteria?

A) COUNTIF
B) SUMIF
C) COUNTIFS
D) SUMIFS



2. Pivot tables can be used to:

A) Analyze large sets of data
B) Perform mathematical calculations on data
C) Sort and filter data
D) All of the above



3. Which of the following Excel features allows you to create a custom number format?

A) Custom Lists
B) AutoFill
C) Format Cells
D) Conditional Formatting



4. Which of the following Excel features allows you to validate data based on a set of rules?

A) Validation Rules
B) Scenario Manager
C) Data Tables
D) Solver



5. Which of the following is NOT a type of pivot table layout in Excel?

A) Matrix
B) Compact
C) Tabular
D) Outline