articles

The average function on Excel allows you to find the average of a list of numbers, named ranges, arrays or cell references. This project takes just a few minutes and requires only a computer with Microsoft Excel and the ... More »

www.reference.com Technology Software

Find a list of all the formulas and functions for the spreadsheet program Microsoft Excel on sites such as TechOnTheNet.com, PCWorld.com, Office.com and Dummies.com, as of 2015. Each site includes the exact command to ex... More »

www.reference.com Technology Software

Find various cheat sheets for formulas and functions in Microsoft Excel 2003 and newer versions on websites such as Dummies.com and the TechTarget section of WhatIs.com. An illustrated cheat sheet for Microsoft Excel can... More »

www.reference.com Technology Software
similar articles

In Excel, the mean function is used to calculate the average of a set of numbers. The numbers used can come from any cell in an Excel spreadsheet by listing the cells involved into the average function box. More »

www.reference.com Technology Software

To subtract in Excel, enter the numbers in a cell using the formula =x-y, complete the same formula using the column and row headings of two different cells, or use the SUM function with negative numbers. Excel does not ... More »

www.reference.com Technology Software

The weighted average function in Excel calculates the average of a group of numbers with one or more of the numbers given more weight or a higher level of importance. For example, when averaging grades together, a teache... More »

www.reference.com Technology Software

Standard deviation is calculated in Excel by using the formula SDEV(ARRAY), where ARRAY represents the range of numbers for which the standard deviation is being determined. This range is either a row or a column of cell... More »

www.reference.com Technology Software