Home » MCQs » Microsoft Excel MCQs

What is the keyboard shortcut to insert a SUM formula in MS Excel?

26. What is the keyboard shortcut to insert a SUM formula in MS Excel?

1. CTRL + =
2. ALT + =
3. ALT + S
4. CTRL + ALT + =

Answer: B) ALT + =

Explanation:

The keyboard shortcut to insert a SUM formula is “ALT + =". For this, select the cell range and press "ALT+=". You will get the SUM of the values of the selected range.