Excel Skills Quiz for Teachers

What function is used for conditional logic in Excel?

• =SUM()

• =IF()

• =COUNT()

• =AVERAGE()

Which function would you use to search for a student's score based on their name?

• =SUMIF()

• =VLOOKUP()

• =COUNTIF()

• =HLOOKUP()

What does the =COUNTIF() function do?

• Finds the maximum value in a range

• Counts all entries in a range

• Sums values in a range

• Counts entries that meet specific criteria

How can you create a dynamic drop-down list in Excel?

• Using Data Validation

• Using Conditional Formatting

• Using Flash Fill

• Using Pivot Tables

What is the purpose of conditional formatting?

• To automate data entry

• To visually highlight data based on conditions

• To create charts

• To protect sheets

Which function would you use to calculate the average of student scores?

• =MAX()

• =AVERAGE()

• =MIN()

• =SUM()

What is the first step to create a Pivot Table?

• Drag fields to the table

• Select the dataset

• Go to Insert → Chart

• Choose New Worksheet

What does the =XLOOKUP() function do?

• Looks up values in a horizontal range

• Looks up values in a vertical range

• Looks up values in a specified range and returns corresponding data

• Counts the number of entries in a range

How can you protect a sheet in Excel?

• By creating a Pivot Table

• By going to Review → Protect Sheet

• By using Flash Fill

• By using Data Validation

What is the purpose of using Flash Fill?

• To format cells

• To protect data

• To automate repetitive data entry

• To create charts