0
to perform some kind of action on the data
Wiki User
∙ 14y ago
Add your answer:
Earn +20 pts
Why do business use a data table?
Excel
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.
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.
How do you move data in excel?
One option is to cut and paste, the same as you would use for any other application.
When copying or moving cells if data already exists in the destination cells Excel?
will not complete the copy or move procedure
What the the term excel mean?
In the context of computing and software, Excel refers to Microsoft Excel, which is a powerful spreadsheet program used for data analysis, calculations, and organizing information. It allows users to create spreadsheets, perform calculations, create charts and graphs, and analyze and visualize data efficiently. Excel is widely used in business, finance, and other fields for data management and analysis.
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.
Where can one find data mining consultants services?
There are numerous places one can find data mining consultant services. One such place is Excel Business Solutions and another is called Business Intelligence Solutions.
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.
