Excel Quiz

What is the default file extension for an Excel workbook in newer versions?

• .xls

• .xlsx

• .csv

• .docx

What does the Ctrl + Z shortcut do in Excel?

• Save the workbook

• Undo the last action

• Redo the last action

• Close the workbook

What does the SUM function do in Excel?

• Subtracts numbers

• Adds numbers

• Counts numbers

• Finds the maximum value

Which function finds the largest value in a given range?

• SUM

• COUNT

• MAX

• MIN

Which of the following is NOT a number format in Excel?

• Currency

• Percentage

• Heading

• Scientific

What does the Format Painter tool do?

• Copies cell contents

• Copies formatting from one cell to another

• Changes the font of selected text

• Deletes formatting

What does the COUNTIF function do?

• Counts all numbers in a range

• Counts cells based on a specific condition

• Counts only blank cells

• Adds numbers based on a condition

Which function returns the average of numbers that meet a specific condition?

• AVERAGE

• AVERAGEIF

• COUNT

• COUNTIF

The IFERROR function is used to:

• Return an error message when a formula is incorrect

• Ignore errors in a formula

• Display a custom message if an error occurs

• Convert errors into numbers

Which function removes extra spaces from text in Excel?

• LEFT

• LEN

• TRIM

• CONCATENATE