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