What formula would you write to do each of the following? a. Add a range of numbers

Question:

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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question
Question Posted: