Using compound formula and using a range in a formula!

Question 1

What is a compound formula?

Answer 1

A compound formula is a formula that uses more than one operator to perform calculation.

Question 2

When you do a calculation in the cell you want to display your result in, what will appear in the cell and where will the actual formula be visible?

Answer 2

When you do a calculation in the cell you want to display your result in, the result appears in the cell, but the actual formula will be visible in the formula
bar.

Question 3

How can you assign multiple cells to a formula?

Answer 3

You can assign multiple cells to a formula by using a range

Question 4

Why would you want to use a range with an example?

Answer 4

Because using a range can save a lot of time. Eg. if you want to calculate the sum of multiple rows or columns it is always better to use a range.

Question 5

In the example =SUM(B4:B9), what is SUM?

Answer 5

In =SUM(B4:B9), SUM is a built-in function of Excel that helps in adding numbers.