What does a formula do in a spreadsheet program?

What does a formula do in a spreadsheet program?
by

1 Answer

Answer :

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

Related questions

I need advice on a formula to find a specific string in an Excel Spreadsheet and list all cell contents that have that string.

Description : I need advice on a formula to find a specific string in an Excel Spreadsheet and list all cell contents that have that string.

Last Answer : You might be able to use the find function =Find(thing_to_find,source) which returns the position of the thing you're looking for within a string in conjunction with Excel's string functions to extract ... you in the right direction. Agree w/ poster below a more specific example would be helpful.

Spreadsheet help with creating a formula?

Description : Spreadsheet help with creating a formula?

Last Answer : Try the spreadsheet in Google Docs. The formulas are super easy to use.

What is the default alignment of number, text and formula in a spreadsheet? -Technology

Description : What is the default alignment of number, text and formula in a spreadsheet? -Technology

Last Answer : Default alignment of text or label entry is left alignment and for numbers and formula, it is right alignment.

In a spreadsheet software, the formula =A1 +$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3? -Technology

Description : In a spreadsheet software, the formula =A1 +$2 was entered in cell A3 and then copied into cell B3. What is the formula copied into B3? -Technology

Last Answer : Need Answer

Which program do you need to write HTML code? (a) Spreadsheet (b) Access -Technology

Description : Which program do you need to write HTML code? (a) Spreadsheet (b) Access -Technology

Last Answer : (c) From the given options, Notepad is useful program to write HTML code.

What is Spreadsheet program?

Description : What is Spreadsheet program?

Last Answer : Feel Free to Answer

An application program that helps the user to change any number and immediately see the result of that change is A) Desktop publishing program B) Database C) Spreadsheet D) All of above

Description : An application program that helps the user to change any number and immediately see the result of that change is A) Desktop publishing program B) Database C) Spreadsheet D) All of above

Last Answer : Answer : C

The first computer spreadsheet program was_________ (A) Lotus 1-2-3 (B) MS Excel (C) Visicalc (D) None of the Above

Description : The first computer spreadsheet program was_________ (A) Lotus 1-2-3 (B) MS Excel (C) Visicalc (D) None of the Above

Last Answer : (C) Visicalc

Information can betransferred betweenthe DBMS and a A. spreadsheet program B. word processor program C. graphicsprogram D. AH of the above E. None of the above

Description : Information can betransferred betweenthe DBMS and a A. spreadsheet program B. word processor program C. graphicsprogram D. AH of the above E. None of the above

Last Answer : AH of the above

What is an Excel: a) A Graphic Program b) A Spreadsheet c) A Presentation Software d) None of The Above

Description : What is an Excel: a) A Graphic Program b) A Spreadsheet c) A Presentation Software d) None of The Above

Last Answer : b) A Spreadsheet

What is an Excel: a) A Graphic Program b) A Spreadsheet c) A Presentation Software d) None of The Above

Description : What is an Excel: a) A Graphic Program b) A Spreadsheet c) A Presentation Software d) None of The Above

Last Answer : b) A Spreadsheet

An application program that helps the user to change any number and immediately see the result of that change is a. Desktop publishing program b. Database c. Spreadsheet d. All of above

Description : An application program that helps the user to change any number and immediately see the result of that change is a. Desktop publishing program b. Database c. Spreadsheet d. All of above

Last Answer : c. Spreadsheet

Can you help me think through how to set up an excel spreadsheet to create some graphs?

Description : Can you help me think through how to set up an excel spreadsheet to create some graphs?

Last Answer : Excell graph tutor.

What is the strangest Excel spreadsheet you have seen?

Description : What is the strangest Excel spreadsheet you have seen?

Last Answer : I've used them to map dollhouses, and to create level maps for computer games, for population models, economic models, experience models, for military simulation scenario data, to make maps of game ... they started wanting you to subscribe to Office. I have used Open Office or Libre Office instead.

What is this code that suddenly populated an Excel spreadsheet on my computer?

Description : What is this code that suddenly populated an Excel spreadsheet on my computer?

Last Answer : That looks a lot like a list of Standard Industrial Codes (SIC Codes). From this book How it got onto your workstation, I have no idea. But the data is actually pretty valuable.

How do I include empty value cells in an average function in Google Spreadsheet?

Description : How do I include empty value cells in an average function in Google Spreadsheet?

Last Answer : I think I figured it out. I’m glad Google spreadsheets obey the laws of math lol.

What suggestions can you provide for organizing a list of worthwhile quotations in an Excel Spreadsheet?

Description : What suggestions can you provide for organizing a list of worthwhile quotations in an Excel Spreadsheet?

Last Answer : alphabetically by subject matter

I need help with a 2007 Excel spreadsheet?

Description : I need help with a 2007 Excel spreadsheet?

Last Answer : Ctl-F will open a search window in Excel.

Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Description : Help! I'm trying to write something in an excel spreadsheet and it's showing up below as well...

Last Answer : answer:Okay, my answer is gonna get moderated, but this drives me nuts. Every company I've ever worked at, managers all want to use Excel as if it was a word processor. Excel is not a word processor! ... column to become wide), or causing the text to continue to the into the next cell to the right.

Excel spreadsheet help (formulas)

Description : Excel spreadsheet help (formulas)

Last Answer : Which version of excel are you using? In 2010 it has a square root function which is =sqrt(CellNameHere). Also as far as the second problem with the multiplication table can you not just use the cell name for example =$B$1*A2 and then drag it down?

How do you generate a new file for each page of a document, spreadsheet, or pdf?

Description : How do you generate a new file for each page of a document, spreadsheet, or pdf?

Last Answer : answer:I would do this with CutePDF Writer, as we've been discussing in another thread recently. Print each separate page of the document to a new .PDF filename, and then you can do what you like ... Mail Merge document, but you've given so few details that I can't really advise that here yet.

Is there any software that would be able to extract email addresses and put them into an Excel spreadsheet?

Description : Is there any software that would be able to extract email addresses and put them into an Excel spreadsheet?

Last Answer : Yes, but the software would depend on where/how the email addresses are currently stored.

John is talking to Mary while working on a deal book at 2AM. Mary learns that John's sister has three children. 'How old are the children?' asks Mark.'Well,' replies John, 'the product of their ages is 36.' 'Hmmm, the sum of their ages is the same as this figure right here,' says John pointing at the spreadsheet. 'Still not enough information' says Mary after thinking for a minute. 'The eldest is dyslexic' says John. How old are the children? -Riddles

Description : John is talking to Mary while working on a deal book at 2AM. Mary learns that John's sister has three children. 'How old are the children?' asks Mark.'Well,' replies John, 'the product of their ... after thinking for a minute. 'The eldest is dyslexic' says John. How old are the children? -Riddles

Last Answer : This answer was deleted by moderators

Name the toolbar of spreadsheet which has all the options of changing the font properties. -Technology

Description : Name the toolbar of spreadsheet which has all the options of changing the font properties. -Technology

Last Answer : Formatting Toolbar

Describe, how the owner of the restaurant could use the spreadsheet for financial modeling? -Technology

Description : Describe, how the owner of the restaurant could use the spreadsheet for financial modeling? -Technology

Last Answer : 1. Decide on a total purchasing need for next night/week/month/year.2. Change figures in spreadsheet.3. Raise/lower/add/delete any value.4. Compare results with predicted/total needed/target results.5. To general use for budgeting like to calculate profit.

Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Description : Write command for the operations (i) to (iii) based on the spreadsheet below: -Technology

Last Answer : 1. At cell F2, type =D2*E2 and then copy this formula using mouse Fill handle onto range F3: F5.2. At cell G2, type =IF(C2=”Consumable”, F2*0.07, F2*0.11) and then copy this formula using mouse Fill handle onto range G3: G5.3. At cell G6, type =SUM(G2: G5).

A term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cell. -Technology

Description : A term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cell. -Technology

Last Answer : (a) A term that is used in spreadsheet which forces a line break in a cell when the cell entry is too large to fit in the cellWrap.

You have used a spreadsheet to calculate the average marks of a class in Mathematics. -Technology

Description : You have used a spreadsheet to calculate the average marks of a class in Mathematics. -Technology

Last Answer : (b) Marks of each student tor Mathematics will be required for calculating average marks of mathematics.

The Fill handle tool is used for labor intensive entering data in a spreadsheet. -Technology

Description : The Fill handle tool is used for labor intensive entering data in a spreadsheet. -Technology

Last Answer : True Entering data into a spreadsheet can be very labor intensive, but Fill handle tool autofill the entries and save time.

How to create a spreadsheet (xls/xlsx file) in Python -Web-Development

Description : How to create a spreadsheet (xls/xlsx file) in Python -Web-Development

Last Answer : answer:

What is the lexical meaning of the word spreadsheet ?

Description : What is the lexical meaning of the word spreadsheet ?

Last Answer : spreadsheet

Excel Spreadsheet , PowerPoint , Word Processing What are some examples of software ?

Description : Excel Spreadsheet , PowerPoint , Word Processing What are some examples of software ?

Last Answer : Examples of Excel spreadsheets , PowerPoint , word processing application software.

What are the benefits of spreadsheet package ?

Description : What are the benefits of spreadsheet package ?

Last Answer : Below are the benefits of spreadsheet - 1. A worksheet has 256 columns and 65,536 rows. 2. Benefits of 16 worksheets are available. 3. Multiple spreadsheets can be linked together. 4. Numerous formulas ... be presented in different ways. 15. Saving can be done by creating a format in the worksheet.

Spreadsheet What ?

Last Answer : spreadsheet Yes One Kind of Computer Program. Of Lexical Money Scatter Or Large Size Paper. To it Ever Ever Workbook To say Is. A Register In the book E.g. Many Page Yes , that's right A In the workbook Many Worksheet Stays. One by one Worksheet Too many Row and _ There is a column .

Why would a house wife use spreadsheet?

Description : Why would a house wife use spreadsheet?

Last Answer : Because to maintain house record.

What do you call the numbers down the side of a spreadsheet?

Description : What do you call the numbers down the side of a spreadsheet?

Last Answer : The columns are lettered across the top, while the rows are numbered down the side. A1 is the cell with the address of column A and row 1, which happens to be the top left-hand cell on a spreadsheet.

What is the Smallest unit of spreadsheet software?

Description : What is the Smallest unit of spreadsheet software?

Last Answer : Cell

What is Each individual box on the spreadsheet?

Description : What is Each individual box on the spreadsheet?

Last Answer : Each individual box on a spreadsheet is known as a cell. Each cell is identified by a letter and a number. For instance, the first cell is A1, which is column A and row 1. Columns are along the top, and ... G and then down the G column to row 3. If I then click on G3, that cell becomes active.

When would you use database software instead of a spreadsheet or word processing software?

Description : When would you use database software instead of a spreadsheet or word processing software?

Last Answer : when I need to see table relationships and sort data by custom fields

What is a horizontal line in a spreadsheet called?

Description : What is a horizontal line in a spreadsheet called?

Last Answer : It is called a horizontal line!

How spreadsheet is helpful to a banker?

Description : How spreadsheet is helpful to a banker?

Last Answer : Spreadsheets can use formulae to calculate large number, orinterest rates much quicker and more accurately than humanscan.

How do you sell a spreadsheet?

Description : How do you sell a spreadsheet?

Last Answer : Okay so I have a friend that wants to sell a spreadsheet. He hasa bunch of formulas and figured out how to password protect it todisable editing by consumers. But how do you prevent the people whobuy the sheet from just sharing the file with there friends?

What is Main benefit of a spreadsheet package to an accountant at work?

Description : What is Main benefit of a spreadsheet package to an accountant at work?

Last Answer : What is the answer ?

What symbol would you use to add two numbers together in a spreadsheet?

Description : What symbol would you use to add two numbers together in a spreadsheet?

Last Answer : The plus symbol.

What can the forecasting function of a spreadsheet help businesses do?

Description : What can the forecasting function of a spreadsheet help businesses do?

Last Answer : It can help them to predict what will happen in the future andallow them to plan for that, like investing enough money to keepthem in profit, or stop spending money on something that isn'tworking for them.

What is the name of the individual cells on a spreadsheet worksheet?

Description : What is the name of the individual cells on a spreadsheet worksheet?

Last Answer : What is the answer ?

Why NASA use spreadsheet for?

Description : Why NASA use spreadsheet for?

Last Answer : What is the answer ?

What is the difference between closing a workbook and closing a spreadsheet?

Description : What is the difference between closing a workbook and closing a spreadsheet?

Last Answer : Need answer

What Is A The Tool That Can Be User Of Ms Excel 2007 Can Use To Enlarge And Reduce The Size Of The Spreadsheet View.?

Description : What Is A The Tool That Can Be User Of Ms Excel 2007 Can Use To Enlarge And Reduce The Size Of The Spreadsheet View.?

Last Answer : Need answer