2007-03-09 02:56:14 · 3 answers · asked by Operating systems student 1 in Computers & Internet ➔ Software
A function is a built in set of executable codes to perform a specific task. For example, the Sum() function will add a group of numbers within the range specified in the parenthesis. But what if you want to add half the numbers, then add the other half , and multiply the two sums together. There is no prebuilt function in Excel to do that. You need to write a formula.
A formula is a set of commands to generate a specific result. The commands may include functions. For example, I could write a simple formula: =sum(a1:a12)*sum(b1:b12). This formula combines the Sum function with the multiplication operator to create the formula,
2007-03-09 03:12:52 · answer #1 · answered by SA Writer 6 · 2⤊ 0⤋
Built in calculations are called functions. The easiest way to include a fuction in your worksheet is by using a formula palette.The Formula palette keeps track of the functions you enter and displays a description of the formula and how its constructed.
2007-03-09 03:13:00 · answer #2 · answered by MONICA T 1 · 1⤊ 0⤋
The Formula is made up of the various Functions and the ranges that the function is performed upon. =Sum is a function. =Sum(a2:a25) is a formula.
2007-03-09 03:16:33 · answer #3 · answered by texaskelt 5 · 2⤊ 0⤋