Question

In the formula, =SUM(Total_sale!B4:D4), ____________ indicates the source sheet.

a) Total_sale b) ! c) B4​

Answer 1

Answer:

Formulas in Excel are basically mathematical expressions that use cell references (e.g., “A5”,” D17”) as arguments. For example, a formula that adds the contents of cell E5 and E6 could be written as follows:

= E5+E6

Explanation:

If the values contained in E5 and E6 are 6 and 11, respectively, the formula will produce 17 as the value it displays. If you change E5 to 7, the result will automatically change to 18.

Answer 2

Answer:

THE ABOVE EXPLAINATION IS CORRECT BUT ANSWER IS

a) Total_sale is answer