Question

The formula “=SUM (B3, C3, D3)” gives what answer?​

Answer 1

A N S W E R:

• It will calculate the sum of numbers in the cells - B3, C3 and D3 and displays the sum in the cell in which the given formula is written.

E X P L A N A T I O N:

• The SUM() function is used to calculate sum of numbers in a given range. So, SUM (B3, C3, D3) returns the sum of the numbers in these three cell addresses.
• We can also write =SUM(B3:D3). Both gives the same output.

•••♪

Answer 2

Answer:

It will return the SUM of B3,C3 and D3.

In other words SUM(B3,C3 and D3) means B3+C3+D3.

More about excel.

• You can write formula in a cell to calculate various operations like Sum, Average,HCF,LCM, Percentage etc.
• Top to bottom lines are called rows represented by (1,2,3.).There are 1,048,576 rows.However you may create as many you want by clicking on insert option.
• Left to right lines are called columns represented by(A,B,C.AA,BB.).There are 16,384 columns.You also may also create as many you want by clicking on insert option.
• The cells of a worksheet have a specific position, like A3 means column A and row 5. By typing the cell number in the formula box you can find a specific cell.