0
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.
Wiki User
∙ 7y ago
Add your answer:
Earn +20 pts
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.
How would you delete a data from a cell in excel?
Use the delete key.
In Microsoft Excel what key combination do you press to move the last cell containing data?
Ctrl - End.
When do you press the enter key?
There are hundreds of reasons. You press the Enter key when you want to execute whatever command is appropriate at the time. If you are entering data in an Excel worksheet cell, you can press the enter key when you are done entering the data.
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.
What happens if you sorted a column by choosing the column heading in Excel?
It would use the data in the column as the basis for the sorting and sort the rest of the data.
What happens when multiple filters are applied to an Excel spreadsheet?
The only thing that happens is that only the data which meets the terms of all the filters is displayed.
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.
What are two ways to accept data in Excel?
Press the Enter key. Click on the tick beside the formula bar when you are typing it in.
What happens if you don't assign a primary key field in Microsoft Excel?
Excel is primarily a spreadsheet, not a database, so you do not set primary keys in it. That would be something you would do in a program like Access. Setting a primary key ensures that there is a unique value in each record, meaning that record can always be uniquely identified. Without a primary key set, it is possible to end up with duplicated data and it can be harder to find data. Primary keys are also used in creating relationships, so that is more difficult to do without one.
Is diagram the visual representation of data in Excel?
A chart is a visual representation of data in Excel.
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.
