0
What else can I help you with?
Why do business move data in and out of excel?
to perform some kind of action on the data
How would you convert the data into a table in Excel 2007?
You do not convert any data in Excel. A table is a layout to organize the data. If you want the data to look like it is in a table, then move the data to where you would like it to display.
How do you move comma separated data inside an Excel cell to their own cells?
One way would be to copy the data into a text file, using Notepad perhaps, and then save the file and open it with Excel. The text will then be in different cells. You could then copy that data back into the original Excel file.
When you data from Access to Excel a copy of the data is created in Excel?
You can copy data from Access and paste it directly into Excel. From a table or query, data can be selected and then copied and pasted into Excel. In that case, data changing in the original Access file will not change data in the Excel file. To do that there must be a link between the data. You can also import data from Access into Excel and from Excel into Access, again maintaining a link to the source if you want.
In Microsoft Excel what key combination do you press to move the last cell containing data?
Ctrl - End.
When copying or moving cells if data already exists in the destination cells Excel?
When copying cells in Excel to a destination where data already exists, you can choose to either replace the existing data with the copied data, keep the existing data and not copy over it, or merge the copied data with the existing data. When moving cells in Excel to a destination where data already exists, the original cells will be replaced by the moved cells.
What is external data in Excel?
It is data coming from another source, such as a database. It is external to Excel, but being used by Excel.
Can Excel be used for data storage?
Excel files will have data in them, so in that way they are storing data. Excel is not a disk or USB key or other such data storage devices. It is software, not hardware.
Is diagram the visual representation of data in Excel?
A chart is a visual representation of data in Excel.
What happens if you do not key in data in Excel?
Without data, there is not much Excel can do. Formulas will have no data to work on. Charts will not show anything. Data is very important to Excel. There are things you can do without it, like draw shapes, but Excel is designed to do things with data, so you need to have some.
How do you interrogate data in Excel 2007?
You can interrogate data in Excel 2007 by using the filter and sort options in Excel. This re-organizes the data in a way that makes it easy to analyze and evaluate the data.
How do you Convert Tally 7.2 xml data into Excel Format?
tally 7.2 data convert into excel
