Excel 2016 Basics Quiz

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

• .docx

• .xlsx

• .xls

• .pdf

Which symbol is used to start a formula in Excel?

• =

• +

• @

• #

What does the function =SUM(A1:A5) do?

• Finds the average of the cells

• Multiplies all the values

• Adds the values in cells A1 through A5

• Counts the cells

Which feature allows you to apply the same formatting to multiple cells?

• Format Painter

• Conditional Formatting

• Filter

• Freeze Panes

Which shortcut key is used to save a workbook?

• Ctrl + C

• Ctrl + S

• Ctrl + V

• Ctrl + P

What does the function =AVERAGE(B1:B10) return?

• The sum of all numbers

• The maximum value

• The mean of the numbers

• The number of cells

What type of chart is best for showing percentages?

• Bar Chart

• Line Chart

• Pie Chart

• Column Chart

Which of these is NOT a valid Excel data type?

• Number

• Text

• Equation

• Date

How do you insert a new worksheet in Excel?

• Right-click a tab and choose "Insert"

• Press Ctrl + N

• Use the Insert > Table option

• Go to Home > Add

What is the maximum number of rows in Excel 2016?

• 65,536

• 104,8576

• 1,048,576

• 16,384