Question

You want to calculate the sum of 2 different ranges-A1:A5 and D1:0D5. Considering that the cells B1:85 contain values, which of the following options will you use for this purpose?

Choose the best option

A. =SUM(A1:A5)+(01.05)

B. =SUM(A1:A5)+SUM(D1:05)

C. =TOTAL(A1:D5)

D. None of the given options

Answer 1

For example =SUM(A2:A6) is less likely to have typing errors than =A2+A3+A4+A5+A6. Using SUM with two ranges of numbers. Here's a formula that uses two cell ...

Answer 2

B. =SUM(A1:A5)+SUM(D1:05)

You want to calculate the sum of 2 different ranges-A1:A5 and D1:0D5. Considering that the cells B1:85 contain values.

• To add and obtain the total of all the individual values in a range of cells, for instance, use the function SUM(range). Consider the scenario where you want to add every value from cell A1 through cell A5. You can utilise the SUM() function rather than laboriously writing down A1+A2+A3+A4+A5 by hand.
• SUM adds values using addition. Individual values, cell references, ranges, or a combination of all three can be added. For instance, the formula =SUM(A2:A10) adds the values in cells A2 and A10.
• When finished, choose a cell adjacent to the numbers you wish to add, click AutoSum on the Home tab, and then press Enter. Excel automatically enters a formula (using the SUM function) when you click AutoSum to sum the values.
• Use the Excel AutoSum button to sum a group of cells quickly and easily. The chosen cell is automatically filled with an Excel SUM function. A range of cells' SUM function adds up one or more numbers. Choose cell A5 in this example, which is the empty cell in the row beneath the cells you wish to add up.

#SPJ2