Excel Shortcuts and Functions Quiz

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

• SUM()

• TOTAL()

• AVERAGE()

• MEAN()

What is the shortcut to edit a cell?

• F1

• F2

• F3

• F4

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

• Subtracts values

• Divides values

• Multiplies values

• Adds values from A1 to A5

Which of the following is an example of Absolute Cell Reference?

• A1

• A$1

• $A$1

• $1A

Shortcut to undo the last action in Excel is:

• Ctrl + R

• Ctrl + N

• Ctrl + Z

• Ctrl + U

What will =MAX(10, 20, 15) return?

• 10

• 20

• 15

• 0

What is the result of =IF(50>30,"Yes","No")?

• Yes

• No

• 30

• 50

Shortcut to save a workbook in Excel is:

• Ctrl + A

• Ctrl + E

• Ctrl + S

• Ctrl + W

Which function gives the smallest number in a range?

• MAX()

• MIN()

• LOW()

• SMALLEST()

Which key is used to start a new line within a cell?

• Ctrl + Enter

• Shift + Enter

• Alt + Enter

• Ctrl + Shift