Introduction to MOS Excel Quiz

Which Excel function is used to add a range of numbers together?

• AVERAGE

• SUM

• COUNT

• MAX

What is the keyboard shortcut to copy selected cells in Excel?

• Ctrl + V

• Ctrl + X

• Ctrl + C

• Ctrl + Z

Which formula would you use to find the average of the values in cells A1 to A5?

• =SUM(A1:A5)

• =AVERAGE(A1:A5)

• =COUNT(A1:A5)

• =MIN(A1:A5)

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

• The minimum value in cells B1 to B10

• The maximum value in cells B1 to B10

• The sum of values in cells B1 to B10

• The average of values in cells B1 to B10

Which of the following is the correct formula to subtract the value in cell B2 from the value in cell A2?

• =A2+B2

• =A2-B2

• =B2-A2

• =A2*B2

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

• Ctrl + S

• Ctrl + P

• Ctrl + O

• Ctrl + N

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

• COUNT

• COUNTA

• SUM

• AVERAGE

What is the result of the formula =2*3+4 in Excel?

• 10

• 14

• 12

• 8

Which shortcut is used to undo the last action in Excel?

• Ctrl + Y

• Ctrl + Z

• Ctrl + U

• Ctrl + A

Which of the following functions returns the smallest value in a range?

• MAX

• MIN

• SUM

• AVERAGE