SUM function can be quickly entered in a cell by pressing ........ in Excel.

2024

SUM function can be quickly entered in a cell by pressing ........ in Excel.

  1. A.

    alt + =

  2. B.

    ctrl + =

  3. C.

    alt + ctrl

  4. D.

    F2

Attempted by 66 students.

Show answer & explanation

Correct answer: A

The AutoSum feature in Excel is one of the fastest ways to calculate the total of a column or row of numbers. Instead of typing out =SUM(A1:A10) manually, you can simply use the keyboard shortcut:

  1. Select an empty cell immediately below a column of numbers or to the right of a row of numbers.

  2. Press Alt and = simultaneously.

  3. Excel will automatically write the SUM formula and highlight the adjacent data range.

  4. Press Enter to confirm and display the final total.

Explore the full course: Rssb Basic Computer Instructor