Excel Basics Quiz for Grade 12

What is the default file extension for an Excel workbook?

• .docx

• .xlsx

• .pptx

• .txt

Which of the following is used to perform calculations in Excel?

• Chart

• Formula

• Table

• Image

How do you start a formula in Excel?

• With a plus sign (+)

• With an equal sign (=)

• With a minus sign (-)

• With a colon (:)

What function would you use to find the average of a range of cells?

• SUM

• AVERAGE

• MAX

• MIN

Which of the following is a valid cell reference in Excel?

• 1A

• A1

• A-1

• 1-A

What is the shortcut key to save a workbook in Excel?

• Ctrl + S

• Ctrl + P

• Ctrl + C

• Ctrl + V

Which function would you use to count the number of cells that contain numbers in a range?

• COUNT

• COUNTA

• COUNTIF

• COUNTBLANK

What is the purpose of the VLOOKUP function in Excel?

• To look up a value in a vertical table

• To look up a value in a horizontal table

• To calculate the sum of a range

• To find the maximum value in a range

Which of the following is used to create a chart in Excel?

• Data tab

• Insert tab

• Review tab

• View tab

What is the function of the Fill Handle in Excel?

• To format cells

• To copy cell contents or formulas

• To delete cell contents

• To insert new rows