Excel is not a full working database. It only has some databasing capabilities. If you want to ensure data integrity you are better to look at using an actual database application.
In database system one of the main feature is that it maintains data integrity. When integrity constraints are not enforces then the data loses its integrity.
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.
Yes, that is what data integrity is all about.
It is data coming from another source, such as a database. It is external to Excel, but being used by Excel.
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.
Data integrity is a term used in databases. In its broadest use, "data integrity" refers to the accuracy and consistency of data stored in a database, data warehouse, data mart or other construct. The term - Data Integrity - can be used to describe a state, a process or a function - and is often used as a proxy for "data quality".
A chart is a visual representation of 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.
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.
Data integrity.
Data Integrity
Data integrity and data security