What formula would you write to do each of the
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.

Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
    Tutors
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
OR
Relevant Tutors available to help