Question

You use worksheets to perform calculations. How do you perform these calculations?

Answer 1

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.

Answer 2

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