Microsoft Excel Power Tips and Tricks Quiz

What is the purpose of filters in Microsoft Excel?

• To sort data in ascending order

• To remove duplicate values

• To only see data that meets certain criteria

• To create pivot tables

How can you filter for unique values in Excel?

• Use the Advanced command in the Sort & Filter group

• Use the Remove Duplicates command in the Data Tools group

• Use the VLOOKUP function

• Use the SUMIF function

What is the syntax for the VLOOKUP function?

• VLOOKUP (value, table, index_number, [not_exact_match])

• SUMIF (range, criteria, [sum_range])

• COUNTIF (range, criteria)

• IF (condition1, value_if_true1, value_if_false1)

How can you create named cells and ranges in Excel?

• Using the Name box on the formula bar

• Right-clicking the selection and selecting Define Name

• Using the Define Name box

• All of the above

What is the purpose of the SUMIF function?

• To count the number of cells that meet a criterion

• To sum the values in a range that meet criteria

• To count the number of cells that meet multiple criteria

• To sum the values in a range of cells that meet multiple criteria

What is the syntax for the SUMIFS function?

• SUMIF (sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ... criteria_range_n, criteria_n])

• COUNTIF (range, criteria)

• COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2, ... criteria_range_n, criteria_n])

• IF (condition1, value_if_true1, value_if_false1)

What is the purpose of the COUNTIF function?

• To count the number of cells that meet a criterion

• To sum the values in a range that meet criteria

• To count the number of cells that meet multiple criteria

• To sum the values in a range of cells that meet multiple criteria

What is the syntax for the COUNTIFS function?

• SUMIF (sum_range, criteria_range1, criteria1, [criteria_range2, criteria2, ... criteria_range_n, criteria_n])

• COUNTIF (range, criteria)

• COUNTIFS (criteria_range1, criteria1, [criteria_range2, criteria2, ... criteria_range_n, criteria_n])

• IF (condition1, value_if_true1, value_if_false1)

What is the purpose of an IF statement in Excel?

• To sort data in ascending order

• To remove duplicate values

• To only see data that meets certain criteria

• To check whether a condition is met and return different values

What is an Excel Pivot Table?

• A user-created summary table of the original spreadsheet

• A visual representation of a pivot table in Excel

• A function used to find things in a table or range by row

• A function used to count the number of cells that meet a criterion