0
The area in a worksheet where you are able to create or edit data and formulas is called?
Wiki User
∙ 14y agoWant this question answered?
Be notified when an answer is posted
Add your answer:
Earn +20 pts
How do you determine the formulas and functions needed for a worksheet in Excel?
There is no simple answer to that. Each worksheet is different. It depends on what it is that needs to be done, so they will have different formulas every time. A person who knows how to use Excel and knows what needs to be calculated, will be able to create the formulas. There are different ways of doing the same thing, so it is possible to use different variations of formulas that will achieve the same result. So, as you can see, there is no straightforward answer. It is down to the knowledge and experience of the person creating the worksheet as to what formulas they will use.
In Excel can you create a worksheet that will be able to make decisions based on the information that appears in other cells?
Yes you can do that. The main function to do that is the If function. See the link below for more information on it.
When considering which cells another worksheet user should be able to manipulate leave the cells?
When considering which cells another worksheet user should be able to manipulate, leave the cells _____.
Are data changes updated automatically in Excel?
Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.Charts are based on data in your worksheet. Any time there are changes to any data a worksheet updates itself, so things like the results of formulas change and also charts that use the data. So Excel has been designed for changes in data to make the spreadsheet automatically update everything that depends on the data. It is a fundamental aspect of an electronic spreadsheet to be able to recalculate and update when changes are made.
If you shrink a worksheet will excel be able to display more columns?
probably
How do you change a jpg file to an Excel file?
You can't. JPG is pictures, excel is a worksheet with names and numbers. You might be able to turn an excel-file into a JPG, but then you would no longer be able to do calculations in the worksheet.
How do you create a spectrum?
no idea but there is a cool website called wikianswers you might be able to ask on
What are the answers to cooking with elements worksheet activity 14?
The answers to the cooking with elements worksheet activity 14 are not able to be located through the internet. If a student is having trouble answering the questions on the worksheet they should go to the teacher.
What is the function of the cell refrance in Microsoft Excel?
In order to do formulas that use values in cells, you need to be able to refer to those cells in the formulas. That is what a cell reference does. You can then create formulas that can be copied quickly and be used for any values that may appear in the cells. As much as possible cell references, rather than values, should be used in formulas.
If Excel Merge and center is disabled how to enable it?
Unprotect the page where you want to use the Merge and Center command. When a worksheet is protected, you will not be able to use any of the commands that change the appearance of the worksheet.
A worksheet in Excel is able to display more columns and rows if?
If you change the scale, zooming out to show more.
Why it is important to design a worksheet before you begin entering actual data into it?
To create anything it is better to design it before creating it. Before building a house you get an architect to design it. Then the builder has all the plans needed and needs very little additional information to start and complete the building. The builder just follows the plan to build your house. Without the architect's designs the builder will have lots of questions and it will take much longer for the building work to be complete, so it is much better to have the design work done first. If you are creating anything complicated on a computer, the same approach is taken. For a simple worksheet, very little design work is needed. For a more complex one it is good to have worked out what you need to do, what formulas you will use, what information you want to be able to get from it, if you want to have charts, what the layout of the worksheet will be, what headings you will have and many other things. When you know what it is you need to do, it is much easier to create it. You will have a plan to follow and you can quickly create the worksheet. You will have less mistakes. All the formulas can be created and as soon as the data is entered they will start to calculate things for you. It may sound slower or a waste of time to design it first and quicker to start creating it, but as you are creating it that way you are having to work out what to do next. This makes creating it that way slower. So the initial time lost by designing it is more than made up for when you start creating it, as it can be created much quicker when you have a design already worked out. That is why it is important to design a complex worksheet before entering any data.
