Excel Basics Quiz

What is the default file extension of an Excel?

• .xls

• .xlsx

• .docx

• .csv

In Excel, a worksheet is composed of...

• Rows and columns

• Tables and charts

• Cells and formulas

• Pages and paragraphs

What is the intersection of a row and a column called?

• Field

• Cell

• Box

• Grid

Which symbol is used to start a formula in Excel?

• +

• -

• =

• *

What is the function of the SUM formula?

• Counts the number of cells

• Adds up values in a range

• Finds the highest value

• Calculates the average

What is the shortcut key for saving a workbook in Excel?

• Ctrl + S

• Ctrl + P

• Ctrl + X

• Ctrl + V

How do you merge multiple cells into one?

• Use the Merge & Center button

• Press Delete

• Use the SUM function

• Press Ctrl + M

Which Excel function counts the number of numeric values in a range?

• COUNT

• COUNTA

• SUM

• MAX

What is the default alignment for text in an Excel cell?

• Left

• Center

• Right

• Justified

Which function returns the largest value in a range?

• MAX

• MIN

• LARGE

• AVERAGE