Basic Microsoft Excel Quiz

Which symbol is used to start a formula in Microsoft Excel?

• @

• =

• #

• $

What is the default alignment for text entered into a cell in Excel?

• Center

• Left

• Right

• Justify

Which function is used to find the average of a range of numbers in Excel?

• SUM

• AVERAGE

• COUNT

• MAX

Which menu option would you use to sort data in ascending or descending order?

• Insert

• Data

• Review

• View

Which chart type is best for showing the proportion of parts to a whole?

• Line Chart

• Pie Chart

• Column Chart

• Scatter Chart

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

• Multiplies the values in A1 to A5

• Adds the values in A1 to A5

• Finds the average of A1 to A5

• Counts the number of cells from A1 to A5

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

• 1A

• A1

• AA

• 11

How can you make the text in a cell bold?

• Press Ctrl + I

• Press Ctrl + B

• Press Ctrl + U

• Press Ctrl + C

Which function would you use to count the number of cells in a range that are not empty?

• COUNT

• COUNTA

• COUNTBLANK

• COUNTIF

What is the result of the formula =<katex latex="A"></katex>1+<katex latex="B"></katex>1 if <katex latex="A"></katex>1 contains 5 and <katex latex="B"></katex>1 contains 3?

• 8

• 53

• 2

• 15