Formulas & Functions

Display the Relationships Between Formulas and Cells

June 27, 2015 0

Sometimes checking formulas for accuracy or finding the source of an error can be difficult when the formula uses precedent or dependent cells: Precedent cells Cells that are referred to by a formula in another […]

Formulas & Functions

Display Formulas

June 21, 2015 2

Display Formulas You Can toggle between Excel’s normal display which shows the results of the formulas in the spreadsheet and a display mode that shows the actual formulas. The keyboard shortcut is Ctrl + tilde […]

Formulas & Functions

AVERAGE, MODE, MEAN, And MEDIAN

June 20, 2015 0

Average Description Returns the average (arithmetic mean) of the arguments. For example, if the range A1:A20 contains numbers, the formula =AVERAGE(A1:A20) returns the average of those numbers. Syntax AVERAGE(number1, [number2], …) The AVERAGE function syntax […]

Formulas & Functions

Turning Off Error Checking

May 12, 2015 0

When Excel open it is constantly checking in the background for potential errors in your worksheets. If an Excel detects an error (or at the least what Excel thinks is an error) then the cell […]