Write excel formulas to do the followings: a. Find the average values for the range b3:e7. b. Count the no. of cells containing numeric values . c. Find the maximum value from the range b3:e7.
Answers
Answered by
4
Answer:
Notes
1. AVERAGE automatically ignores empty cells and cells with text values.
2. AVERAGE includes zero values.
3. Use AVERAGEIF or AVERAGEIFS to ignore zero values.
4. Arguments can be supplied as constants, ranges, named ranges, or cell references.
5. AVERAGE can handle up to 255 total arguments.
6. To see a quick average without a formula, you can use the status bar.
PLEASE, MARK ME AS BRAINLIEST!
Attachments:
Similar questions