When you write a formula, why should you use cell references rather than typing

Question

When you write a formula, why should you use cell references rather than typing in values directly into the formula? For each task below, write down the appropriate formula. A. Add a range of numbers in cell B2-B12. b. Find the largest value in cells C2-F2. c. Find the smallest value in cells A1 through X10. d. Find the average value in cells C1 through C10, assuming blank cells will be ignored. e. Find the total number of values listed in cells A1 through F1, any that contain text. You are given the following worksheet below: What formula would you enter in cell B2 that can be copied down the column and across the row to complete the multiplication? What new formula results for each of the following formulas if we copy the formula from cell C10 to cell E12? a. -A1 + A2 b. -$A$1 + A2

Explanation / Answer

2) The usage of cell formula reference: when usiing the cell reference (formula) what ever the changes made to the referenced cell, the resultant cell (the cell which the reference applied) also will get the changes.

3) a) add a range of numbers in the cell (B2:B12)

=SUM(B2:B12) (the values are added from the cell B2 to B12)

b) largest value of cell(C2:F2)

= LARGE(C2:F2,1) (LARGE(Array,k), array refers the cell range to find large number, and k refers the number largest value to be founded)

c) smallest value of cell(A1:X10)

=SMALL(B2:E11,1) (SMALL(Array,k), array refers the cell range to find small number, and k refers the number smallest value to be founded)

d) average (C1:C10)

= AVERAGE(C1:C10) (returns the average value of the given range excluding the blank cell in the given range)

e) total number of values in the cell(A1:F1)excluding the text

= COUNT(A1:F11) (returns the count of values in the given range excluding the text in the given range)

4)   =($A2*B$1), (the formula reference the Absolute value in the column and relative value in the row in A2 and relative column and absolute row in B$1.)

5)

a) =A1+A2 in this formula, both the value are relative(reference to relative column and relative row) so the formula will be changed to:

= C1+C2

b) $A$1+A2 in this formula , A1 has absolute row and absolute column and A2 is relative reference, so the formula will be changed to :

=($A$1+C2)

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.