Question

In EXCEL, you can sum a large range of data by simply selecting a tool button called .....?
AutoFill
Auto correct
Auto sum
Auto format

Answer 1

Answer:- Option (c) Auto sum

Explanation :

In EXCEL, you can sum a large range of data by simply selecting a tool button called Auto sum.

Following steps explain how you can calculate the AutoSum of a range of data:

• Click on the cell where you want to define the sum formula.
• Select the Formulas tab.
• Click AutoSum from the function library group, from formula ribbon.
• Click on Sum.
• Press the Enter key.
• Or, select the Home tab, click AutoSum and then press Enter Key.
• When you click AutoSum, you'll notice that Excel has defined the formula, =SUM(B3:E3) to the selected cell, and Excel highlights the cells you're totaling.
• Press Enter key to apply the formula to the cell.

Alternatively, you can write =SUM(BE:E3) in the cell to get the sum.

Answer 2

Answer:

Explanation:

Auto Sum