PREMIUM
๐Ÿ“š FPSC SST 2026 Preparation Group
Join Our WhatsApp Group for SST Past Papers & Mock Tests
โœ… Daily MCQs โ€ข ๐Ÿ’ก Expert Tips โ€ข ๐Ÿ“š Past Paper Discussion
Join Group โ†’

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