0
Rules can be applied to control things in a spreadsheet to affect the data you have. You can have validation rules to make sure the data you enter is more controlled. So you could do something like set a rule that limits what the highest value you can enter is. You can have conditional formatting rules to do things like change the colour of cells for different types of values. If a date is before today you could have it as a different colour than dates after today and have the spreadsheet do this automatically.
Wiki User
∙ 12y ago
Add your answer:
Earn +20 pts
What does A1 mean in spreadsheets?
It is the cell in column A and row 1.
What does workbook in computer terms mean?
A workbook in spreadsheet software is a set of individual spreadsheets.
What do you mean by a spreadsheet?
spreadsheets is aprogram which organises information in to rows and columns so that it can be operated easily.
What is the difference between manual and electronic spreadsheets?
Manual spreadsheets are made with a pencil on paper. Electronic spreadsheets are made with a program on a computer.
Advantages and disadvantages of spreadsheets?
There are many advantages and disadvantages of using spreadsheets such as the fact that they are highly organized. One disadvantage of spreadsheets is that they can be complicated to understand.
What is tab in spreadsheets excel?
The tabs at the bottom of the screen identify individual spreadsheets.
Are spreadsheets or databases more powerful?
Databases are somewhat similar to spreadsheets, but databases are more powerful than spreadsheets because of their ability to manipulate the data.
What do you mean by Microsoft Excel?
Microsoft is a brand like Addidas or Prada. Excel is a programme that you use for producing spreadsheets.
What jobs use spreadsheets?
Certain people use spreadsheets in their jobs. Some of these people are:Accountants- they use spreadsheets in their jobs to work out formulas quickly and to keep recordsTeachers- use spreadsheets to keep track of children's progress and... Alot of other jobs involving numbersYou can use spreadsheets in almost any job.
What application software do you use for spreadsheets?
The Microsoft Excel program is a common program for spreadsheets.
What businesses use spreadsheets?
The most popular businesses that use spreadsheets are Google and Microsoft.
How large can spreadsheets be?
Spreadsheets can contain millions of cells in each spreadsheet, and a spreadsheet file can include multiple spreadsheets. For example, Lotus 1-2-3 and Microsoft Excel spreadsheets have 256 columns and 65,536 rows, or 16,777,216 cells.
