Q:
# What are some Excel spreedsheet formulas?

Some simple Excel spreadsheet formulas include =SUM(c1+c2) for addition, =SUM(c1-c2) for subtraction, =SUM(c1*c2) for multiplication and =SUM(c1/c2) for division. The =AVERAGE(c1:c2) formula can provide the average value of a group of cells.

Continue ReadingExcel is designed to make it easy to do calculations with large groups of numbers. Accordingly, its formulas are very flexible and also easy to write. For instance, if you want to add a series of numbers that are not in the same column, choose an empty cell for the answer, and type =SUM( in the Formula Bar. Then click a cell, type a comma, and click the next cell until all labels appear in the bar separated by commas. Close the parentheses, and press Enter. The formula adds the values and renders a result. Formulas for subtraction work in the same way.

While the formula =SUM(c1*c2) does simple multiplication, formulas built on PRODUCT are more convenient for multiplying ranges of numbers. To multiply five numbers in cells C1 through C5, for example, type =PRODUCT(c1, c2, c3, c4, c5) or =PRODUCT(c1:c5) in the Formula Bar, and press Enter.

To perform division, use either =SUM(c1/c2) or =QUOTIENT(c1,c2) where c1 is a numerator and c2 is a denominator.

Excel also makes it convenient to calculate averages. For instance, the formula =SUM(c1:c25)/25 averages a range of 25 numbers in cells C1 through C25. An even simpler formula is =AVERAGE(c1:25).

Learn more about Software-
Q:
## What is the auto sum feature in Excel?

A: The AutoSum feature in Excel provides a shortcut to adding up columns or rows of numbers in an Excel spreadsheet. It can add up to 255 numbers at one time. Full Answer >Filed Under: -
Q:
## How do you insert a check box in an Excel spreadsheet?

A: To insert a check box in an Excel spreadsheet, enable the Developer tab from Settings. Once the tab is visible, use it to drag and drop a check box. Full Answer >Filed Under: -
Q:
## How do you put a tick mark on Excel?

A: The tick or check mark symbol can be inserted into an Excel spreadsheet through the Windows Character Map tool, Symbols command on the Insert menu or its c... Full Answer >Filed Under: -
Q:
## What are some basic formulas to use in Excel?

A: SUM, COUNT, CONCATENATE and LEN are some basic formulas to use in Excel. These are predefined formulas that perform operations within user-specified parame... Full Answer >Filed Under: