Importance of Using Formulas in Excel

Techwalla may earn compensation through affiliate links in this story. Learn more about our affiliate and product review process here.
Excel does the math with formulas so there is no need for calculators.

Excel is an spreadsheet program for manipulating data. It can store, arrange, organize, calculate and display data ind visual charts. Excel formulas are often used to perform automated math operations to data in the spreadsheet.

Advertisement

Description

Video of the Day

An Excel formula is a set of instruction that tells the program what it should so with certain data. Starting the text in a cell with "=" tells Excel that what follows is a formula. Excel also has functions, or pre-programed functions that automatically perform common calculations.

Advertisement

Video of the Day

Purpose

Formulas can be used to perform many operations and tasks automatically. Users can type numbers directly into the formulas or use cell references, so the formula will use whatever data the referenced cells contain.

Advertisement

Benefits

Formulas can be copied and pasted to different cells and even to different worksheets. So users don't have to recreate the same formula if they want to perform the same operations over several sets of data. Formulas can be used for a set of two numbers or across a range of several cells of data.

Advertisement

Advertisement

Examples

Type "=4*4" in a cell and the cell will display "16." Common functions include "Autosum" and "Average." Insert the Autosum function and select cells B2, B3, B4 and B5 and excel will add the values in those cells and show the sum in a selected cell. Type "=Average(B2:B5)" and excel will add the values in cells B2 through B5 and show the average of those numbers in a selected cell.

Advertisement

Advertisement

references