answersLogoWhite

0


Best Answer

There is no simple answer to that, as it depends on what exactly you are trying to do. Through using a spreadsheet and getting training and experience you would learn what facilities are available and how you can use them to do the things you need. Then when you come to create a spreadsheet you will know or can work out what formulas you need for the particular task you are trying to accomplish.

User Avatar

Wiki User

14y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

13y ago

A formula is a calculation of various elements in the spreadsheet. Some examples of formulas are:

  • =A1*3
  • =A3+B4
  • =NOW()+14
  • =SUM(A1:A12)-SUM(B1:B12)
This answer is:
User Avatar

User Avatar

Akasha Patrick

Lvl 2
3y ago

It uses data entered in the cells to calculate values for other cells

This answer is:
User Avatar

User Avatar

Wiki User

13y ago

Automatically does mathetical calculations, saving alot of time and effort! :)

This answer is:
User Avatar

User Avatar

Wiki User

10y ago

A simple formula put into D1 could be: =A1*B1

Which is asking the numerical data in cell A1, be timed by the numerical data in cell B1, and show the answer in cell D1.

This answer is:
User Avatar

User Avatar

Anonymous

Lvl 1
4y ago

it uses data entered in certain cells to calculate values for other cells

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is meant by formula in a spreadsheet program?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Is gnumeric a spreadsheet program?

Yes it is. It is a free and open source spreadsheet program.


When keying a formula in a spreadsheet what must you key to inform the program that you are entering a formula instead of entering text?

An equal sign because in order for the formula to go through correctly it has to have an (=)


Why is Excel referred to as a spreadsheet program?

It is one of the many spreadsheet applications that have computerised the paper-based spreadsheet, so Excel is therefore a spreadsheet program.


In a spreadsheet a built in formula is called?

In a spreadsheet a built-in formula is called a function.


What is meant by a spreadsheet model?

A spreadsheet model is the model (the type) of the spreadsheet. - how it looks like.


What is a function or formula in a spreadsheet program?

A formula in IT may be the instructions put into a spreadsheet to process the data stored on the spreadsheet. Or, it may mean the method used to use Information Technology correctly.


Where would value be located in excel?

Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.Values are stored in cells on the spreadsheet. When a cell is selected, you will see its contents on the formula bar.


What is a function in spreadsheet program?

Spreadsheet is a computer program used for calculating, organising, analysing data, and display results


What is lotus in spreadsheet programs?

Lotus 1-2-3 is a spreadsheet program.


Differentiate a spreadsheet from a spreadsheet program?

A spread sheet program, such as Micosoft Excel or Lotus 123, is a pre-developed and pre-tested software program that allows a user who knows how to use the program to produce an output, commonly referred to as a spread sheet. The producer is the program and its output is a spreadsheet.


A spreadsheet program is one example of an application program?

yes


What is MS Office Excel as a software program?

It is a spreadsheet program.