0
What else can I help you with?
If a cell contains incorrect data how can it be corrected in excel?
Click on the cell with the incorrect data and change the data to the correct information.
What affects the data in the cell on Microsoft Excel?
Formatting can change the look of a cell and its contents.
What are ways you can change a worksheet?
Select the cell that contains the data you want to change and edit the cell, by double-clicking on the cell or editing in the formula bar.
Is it true that Formatting can change the actual data of a cell?
Formatting does not change the actual data stored in a cell but only changes how the data is displayed. For example, you can format a number as currency or a date format without altering the underlying numerical value.
What is the formatting option that changes the way the data looks in a cell?
Any formatting can change the way data looks in a cell. That is the point of formatting.
What does destination cell mean?
It is the target cell where you want to put data. This term usually is used when talking about copying data from a source cell to a destination cell.
When cells are copied using Excel copy function what happens to the data in the copied cells?
When you copy cells in Excel, the data in the copied cells, the cell references are automatically adjusted. If the copied area includes hidden cells, these cells are also copied. To copy a selection of cells to a different worksheet, click another worksheet tab and select the upper-left cell of the paste area.
When data is entered into a cell by pressing the enter key the cell pointer will?
It will normally move to the cell underneath it, but you can change the settings in Excel so that it does not do that.
What are conditions that are used to restrict or limit the data the displays?
Format the cell to allow for Data Validation.
What is the formatting that is automatically updated if you change data in the worksheet?
No, not necessarily. A lot of formatting will stay the same. There are instances when formatting will change, like when using Conditional Formatting. Typing data in a particular way into a cell that clearly identifies its data format can also change the formatting, like if you type a time into a cell.
Is getting data from a cell in a spreadsheet called referencing?
Yes, that term is used. By referencing a cell you can use the value that is in that cell.
How do you find what sheet or where the data came from in an Excel pivot table?
Excel 2007:Click on any cell of Pivot table.Click on the Options Tab for PivotTable Tools.In the Data section, click on Change Data Source icon, then the Change Data Source item from the drop-down menu.Observe the Table/Range in the Change PivotTable Data Source window.Excel 2003:Click on any cell of Pivot table.Open the Data menu and select Pivot Table.In Pivot Table Wizard use Back button and change address of the source data.
