What formula would you write to do each of the following?
a. Add a range of numbers in cells 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 items listed in cells A1 through F1, excluding any that contain text.