Session 1 - Microsoft Excel Quiz

What is the purpose of the SUM function in Excel?

• To find the maximum value in a range

• To calculate the total of a range of cells

• To find the average of a range of cells

• To count the number of non-empty cells

Which key combination is used to save a workbook in Excel?

• Ctrl + P

• Ctrl + Z

• Ctrl + S

• Ctrl + N

What does the AVERAGE function do in Excel?

• Calculates the total of a range

• Finds the average of a range of cells

• Counts the number of cells with values

• Identifies the highest value in a range

What feature allows you to split data in one column into multiple columns?

• AutoFill

• Data Validation

• Text to Columns

• Conditional Formatting

Which of the following is a method to create a drop-down list in Excel?

• View > Freeze Panes

• Insert > Table

• Home > Conditional Formatting

• Data > Data Validation > Allow: List

What is the purpose of Conditional Formatting in Excel?

• To sort and filter data

• To format cells based on specific criteria

• To create charts and graphs

• To protect sheets from editing

Which function would you use to count how many students scored more than 70 marks?

• SUMIF

• COUNTIF

• AVERAGE

• COUNTA

What is the result of the formula =MIN(B2:B5)?

• The total score in the range

• The average score in the range

• The lowest score in the range

• The highest score in the range

How do you rename a worksheet in Excel?

• Use the Ribbon to rename

• Double-click the sheet tab

• Select the sheet and press F2

• Right-click the sheet tab and select Rename

What is the purpose of the AutoFill feature?

• To automatically format cells

• To fill a series of cells with data

• To create charts

• To protect data