0
How did changing value affects the other part of the worksheet in Excel?
Wiki User
∙ 9y ago
Worksheets have lots of formulas and they use values in cells. So if you change a value in a cell, any formula that uses that cell directly or indirectly can be affected by the change. How many other parts of the worksheet it will affect will depend on the particular worksheet, as each will have different formulas. Changing a value in a cell could affect one cell or many cells.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
What can you see when you open Microsoft Excel?
You will see a blank worksheet entitled Book1 when you open Excel. Depending on the version, you will see other things such as a ribbon or menus.
Where is hierarchy in Excel?
In Excel there can be many hierarchies. Cells are in a worksheet, a worksheet is in a workbook. A grand total formula could be adding up the results formulas giving other totals. There can be hierarchy in graphics.
Are worksheet and spreadsheet interchangeable?
MS Excel is considered a Spreadsheet program and sheets within an Excel file are referred to as worksheets. In other words, MS Excel is a spreadsheet program that produces worksheets but not a worksheet program that produces spreadsheets.Actually, the above is wrong. worksheet and spreadsheet are interchangable.
Is Excel and AN XML?
It is not XML, Excel is a spreadsheet software. But you could save your worksheet as XML format as well as other formats like XLS, CSV, and many more.
What is replicating a formula in Excel?
Replicating means copying. So replicating a formula in Excel is copying a formula. This is a very common activity that is done in Excel. You create one formula and then use it in other places on the worksheet.
What other application does the table view look like in Microsoft Access?
It looks like a worksheet in a spreadsheet application such as Excel.
What is an Excel pane?
An Excel pane is part of the window. The worksheet itself can be split into panes using the Split option. You can also freeze panes, so that one is on the screen all of the time. You also have the task pane, which is outside the worksheet, but can show other things, such as help options.
A series of rows and columns that contains related data that is managed independently from the data in other rows and columns in the worksheet is an Excel?
table
Why would someone protect a workbook in Excel?
To stop other people changing the contents.
Does data sheet view looks like Excel?
A datasheet in Access looks a bit like a worksheet in Excel, but it is different, like having row and column headings relating to records and fields, rather than just having numbers and letters. A worksheet in Excel has a wide range of facilities that a datasheet doesn't. A datasheet is mainly for displaying data and enables some manipulation of the data. A worksheet in Excel allows you do all sorts of complex operations using formulas and other facilities in Excel. Access and Excel are different kinds of applications, so naturally they have different facilities. So the similarities are visual rather than functional.
What is the difference between a worksheet and a spreadsheet?
Worksheet and workbook are terms specific to Microsoft Excel. A workbook may consist of one or more worksheets. A spreadsheet is the same thing as a worksheet except it is a general term the can be used to describe handwritten spreadsheets as well as spreadsheets created by programs other than Excel; however, Excel worksheets are often called spreadsheets.
What is the use of drawing in Microsoft Excel?
There are often occasions when you want to draw things on a worksheet, like an arrow pointing to a particular figure, doing diagrams on a worksheet, drawing shapes around things, and many other uses.
