41.9k views
4 votes
You use worksheets to perform calculations. How do you perform these calculations?

2 Answers

7 votes
The main function you will use is.... Type SUM= in all caps into a cell and then you can control click cells to add them together. You can also add PEMDAS properties to do calculations withing it.
User Gerardo Hernandez
by
7.9k points
2 votes

Answer:

These functions can be used by putting an equal sign before entering the function string

-SUM: you can use this within the worksheet to add and obtain a total for a column / row

(=SUM (number 1, number 2…)

-SEARCH: you can SEARCH any specific item in the worksheet using the search function

(=SEARCH(find_text, within_text,[start_num])

-AVERAGE: you can take average of two or more numbers using this function within the worksheet (=AVERAGE (number1, number2…)

Like these functions there are several more functions that can be used


User Luca Detomi
by
7.0k points
Welcome to QAmmunity.org, where you can ask questions and receive answers from other members of our community.