Microsoft Excel - Assessment

Which function is used to calculate the average of a range?

• SUM()

• MAX()

• AVERAGE()

• MEDIAN()

Which of the following is a valid cell address?

• 1A

• A1

• A.1

• Row1

What happens when you click the “Sort A to Z” button?

• Sorts data from largest to smallest

• Sorts data alphabetically or numerically in ascending order

• Filters the data

• Changes text case

Which tab on the Ribbon allows you to insert a chart?

• Home

• Insert

• Data

• View

In Excel, what symbol is used to start a formula?

• =

• +

• @

• $

Which function returns the current date in Excel?

• TIME()

• NOW()

• DATE()

• TODAY()

What does the Fill Handle do in Excel?

• Deletes cell content

• Copies or extends cell contents/formulas

• Applies formatting

• Saves the workbook

What does the AutoSum button do in Excel?

• Multiplies values

• Adds values

• Subtracts values

• Sorts data

Which of the following is a valid formula in Excel?

• =SUM(A1:A10)

• SUM(A1:A10)

• A1+A10=

• =A1:A10 SUM

What is the default file extension for an Excel workbook in Excel 2016 and later?

• .xls

• .xlsx

• .docx

• .csv