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.
- A.
alt + =
- B.
ctrl + =
- C.
alt + ctrl
- 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:
Select an empty cell immediately below a column of numbers or to the right of a row of numbers.
Press
Altand=simultaneously.Excel will automatically write the SUM formula and highlight the adjacent data range.
Press
Enterto confirm and display the final total.