PREMIUM
🎯 PPSC Past Paper Test Series
30 Mock Tests (100 MCQs Each) + 3,000+ Past Paper MCQs
✅ Detailed Explanations • 💡 One-Liner Memory Hacks • 📚 Previous Papers
WhatsApp Now →

Which keyboard shortcut is used to create a formula that sums all the cells above the active cell in Excel?

A. Alt + S
B. Ctrl + =
C. Alt + =
D. Shift + =
Correct Answer: C. Alt + =

The keyboard shortcut Alt + = is used in Excel to quickly create a formula that sums all the cells directly above the active cell. This feature, known as AutoSum, automatically inserts the SUM function and selects the most probable range of cells to be summed, saving time and effort.

  • Alt + S is not a standard shortcut for AutoSum in Excel.
  • Ctrl + = is typically used for subscript formatting in some applications, not for summing cells in Excel.
  • Shift + = is used to type the equals sign, which is the starting character for any formula in Excel, but it does not automatically insert the SUM function or select a range.

Leave a Comment

Your email address will not be published. Required fields are marked *

Join Our WhatsApp Channel ×
Scroll to Top