answersLogoWhite

0


Best Answer

Protecting the formula area stops the user (as opposed to the designer!) from making accidental changes to the formulae. It helps to make the sheet more 'foolproof'.

User Avatar

Wiki User

16y ago
This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: Why would it be important to 'protect' formula area of a spreadsheet?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Continue Learning about Math & Arithmetic

What are the advantages of using the references in a spreadsheet equation?

It allows you to use the same formula for different values. All you need to do to use different values is change the cells that have the values and you have no need to changed the formula. It is also possible to give cells real names and then use these in a formula. This can make the formula more meaningful. If you take the following formulas, the first is obviously very clear. The second is not so clear, but enables values to be changed in the referenced cells and the third has the actual values. =Income - Expenditure =A6 - B6 =50430-42950 Another advantage and reason is by having the actual values in separate cells, you can see the values on the spreadsheet, making it easier to understand. If you have the values directly in the formula, you will see the result of the formula, but it won't be as clear as to how the total was arrived at. Anything that can be calculated in a spreadsheet should be calculated, and cell references should be used to make the spreadsheet clearer. Another reason is that a formula that has references in it can be copied easily and used with different values, which you can't do if the formula has direct values in it. A lot of spreadsheets consist of similar formulas which can be copied. This is the most efficient way of doing things, rather than repeatedly typing similar formulas. These are some of the main reasons that you would use references rather than actual values in a spreadsheet formula.


Are statistics use in a financial spreadsheet?

Yes. Statistics and statistical functions would indeed be used in a financial spreadsheet. A lot of financial data is statistical.


What is the sum of all the numbers from 1 to 240?

Any spreadsheet program would tell you... 28,920


If you type 3 plus 4 in a spreadsheet cell and then hit enter?

In Microsoft Excel, in order to add two numbers together in the given cell, you need to include in the given cell an equals sign before the formula. Therefore, you would enter into a cell:=3+4..and press enter.


What is an expression in excel?

In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.In Excel an expression is a simple formula and would not have complex parts or complicated functions in it.

Related questions

Why would it be important to Protect formula areas of the spreadsheet in Information technology?

i dont no


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.


How do you calculate fat in milk using Excel formula in Microsoft Excel spreadsheet?

You would first need to know how the fat in milk is calculated and have a formula for it. You would need to know what values are needed to do it. Then you would need to get the values you need and enter them into cells in the spreadsheet. Using these cell references to build your formula, you could do the calculation.


What is an example of an arithmetic formula in a spreadsheet?

For example, an entry into cell D3 of "=B3+C3" would instruct the spreadsheet to add the contents of cells B3 and C3 and store the sum in cell D3.


What is the spreadsheet formula to work out total revenue?

Without seeing your exact spreadsheet, it is not possible to be specific, but you would generally be making use of the SUM function to total up your individual revenues.


Does a formula have equals SIGN in it?

In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.In an Excel spreadsheet and equals sign normally starts a formula. You can also start with a plus or minus or start a function with the @ symbol, because some spreadsheet applications use that, but they will be converted to an equals sign. The equals signs tells Excel that you are going to use a formula, so if you started a function without it, the function would be treated like a piece of text.


Why do you put the equals sign first on a spreadsheet?

Because it tells the spreadsheet that what you are typing is a formula. If you leave it out, it will treat what you type as being text. So if you type =A1+A2 it will add the values in A1 and A2 together. If you type A1+A2 it will literally put that in a cell and treat it like a piece of text and not as a formula. There are times that you would want to do that, so to let a spreadsheet know that you want to do a formula, you must put an equals sign at the start.


What is a field in a database that contains formulas or functions in Excel?

In a database a field with a formula is called a calculated field. A calculated field should actually be in a table, as it can be calculated from data in other fields in the table, so it normally only appears in queries, reports and forms. In a spreadsheet it would just be a calculation.


How a spreadsheet is formatted using the insertion of repetitive text?

You can use a formula to do this. You can set it up in order to use the repetitive text where you would like it.


What is a spreadsheet called when it has diffarent sanarioes?

Generally it would still be called a spreadsheet, but it could be called a What-if spreadsheet.


When do you use the '-' symbol in a spreadsheet?

The most common use is in a formula that includes subtraction.


Why would a shopkeeper need to use a spreadsheet?

You can analyze your profit and loss on a spreadsheet.