Excel Basics Quiz

Which of the following is the correct file extension for an Excel workbook?

• .docx

• .xlsx

• .pptx

• .pdf

Which of the following shortcuts is used to create a new workbook in Excel?

• Ctrl + N

• Ctrl + S

• Ctrl + P

• Ctrl + O

Which function is used to find the maximum value in a range?

• MIN()

• MAX()

• AVERAGE()

• COUNT()

How do you merge cells in Excel?

• Format > Merge

• Home > Format > Merge

• Home > Merge & Center

• Insert > Merge Cells

Which of the following functions adds the values in a specified range?

• ADD()

• SUM()

• TOTAL()

• COUNT()

How can you freeze the top row in an Excel worksheet?

• View > Freeze Panes > Freeze Top Row

• Home > Freeze Top Row

• Data > Freeze Top Row

• Insert > Freeze Top Row

Which chart type is best suited for showing proportions in Excel?

• Line Chart

• Bar Chart

• Pie Chart

• Scatter Plot

What is the default number of worksheets in a new Excel workbook?

• 1

• 2

• 3

• 4

Which of the following shortcuts is used to save a workbook in Excel?

• Ctrl + A

• Ctrl + S

• Ctrl + W

• Ctrl + Z

Which function counts only the numeric values in a range?

• COUNT()

• COUNTA()

• SUM()

• AVERAGE()