Importance of Using Formulas in Excel

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.

Description

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.

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.

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.