when might you use the sum function in your school work or workplace?

Such a function comes in handy when you are trying to add, subtract, multiply, or divide numbers using excel.

Expert answered|Ohjollyme|Points 60|

Rating

There are no new answers.

What are some applications for excel workbooks and worksheets in both the feild of accounting and for an NFL team? **Weegy:** Excel or, to be specific, Microsoft Excel, is an application software for application that use spreadsheets. The spreadsheets present information in tabular form arranged in rows and columns. [ This arrangement of data and information makes it easy to carry out certain types of analysis that require carrying out similar analytical operations on multiple entries in a column or a row, or where the entries in a particular depends on entries in other cells occupying a specified relative position. For example if a table is listing monthly sales in one column and cumulative sales for the year in the next column, then the cumulative sales for any month can be calculated as addition of entry in the cumulative sale column for the previous month plus entry for sale column in the current month. The spreadsheets are also very convenient for analysis requiring use of a string of entries in a particular column or row. This kind of analysis could be simple functions like totalling or calculating averages. It may also include more complex operations like calculating standard deviations or other statistical measures.
These kinds of features of spreadsheets make excel very useful for applications like preparing budgets and financial plans, statistical tabulation and analysis. It is also very useful for tabulating information pertaining to a large number of subjects. For example, tabulating the marks obtained by students of a class in an exam. ] (More)

Question

Expert Answered

Asked 8/19/2011 8:49:37 PM

0 Answers/Comments

what does the sum function? **Weegy:** The SUM function returns the summed value of an expression.
The syntax for the SUM function is:
SELECT SUM(expression )
FROM tables
WHERE predicates;
expression can be a numeric field or formula.
Simple Example
For example, [ you might wish to know how the combined total salary of all employees whose salary is above $25,000 / year.
SELECT SUM(salary) as "Total Salary"
FROM employees
WHERE salary > 25000;
In this example, we've aliased the sum(salary) field as "Total Salary". As a result, "Total Salary" will display as the field name when the result set is returned.
] (More)

Question

Expert Answered

Asked 8/20/2011 12:26:00 AM

0 Answers/Comments

27,199,495 questions answered

There are no comments.