Question

Write down the steps to find out the total of a range of cells using AutoSum

Answer 1

To use AutoSum in Excel, just follow these 3 easy steps:

Select a cell next to the numbers you want to sum:

To sum a column, select the cell immediately below the last value in the column.

To sum a row, select the cell to the right of the last number in the row.



Click the AutoSum button on either the Home or Formulas tab.

A Sum formula appears in the selected cell, and a range of cells you're adding gets highlighted (B2:B6 in this example):



In most cases, Excel selects the correct range to total. In a rare case when a wrong range is selected, you can correct it manually by typing the desired range in the formula or by dragging the cursor through the cells you want to sum.

Tip. To sum multiple columns or rowsat a time, select several cells at the bottom or to the right of your table, respectively, and then click the AutoSumbutton. For more details, please see How to use AutoSum on more than one cell at a time.

Press the Enter key to complete the formula.

Now, you can see the calculated total in the cell, and the SUM formula in the formula bar:


Answer 2

Answer:

This is your answer

hope this helps you