0

# Why would it be important to 'protect' formula area of a spreadsheet?

Updated: 11/4/2022

Wiki User

16y ago

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'.

Wiki User

16y ago

Earn +20 pts
Q: Why would it be important to 'protect' formula area of a spreadsheet?
Submit
Still have questions?
Related questions

i dont no

### 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.

### 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.