describe the following functions sum() average() max() min() upper()
Answers
Answer:
the number you get when you add two or more figures together and then divide the total by the number of figures you added
Explanation:
Any discussion of functions in Excel invariably begins with the Sum function and…often is followed by how to use the Average function and then, although we can…go in different directions certainly, a few functions like finding the maximum…value, the highest value in a range, the lowest value. That's the normal…starting point when we talk about functions in Excel.…Let's just bring out a couple of ideas about how to use these functions.…First of all, the AutoSum button is a shortcut for typing =Sum.…
You'll find it on the Home tab, in the Editing group, and you'll also find it on…the Formulas tab in the Function library.…You'll see it right here as well.…And by the way, you can also use Alt= to activate that as well.…Alt= is the same as typing or using the Sum button.…And many times, you'll learn quickly too that you can add up data in a column,…instead of adding them individually.…It saves us a good deal of time.…