0
Add your answer:
Earn +20 pts
Excel displays data in a special document called?
Microsoft Excel displays data in Worksheets, also called spreadsheets, or as a group of worksheets known as a Workbook.
What ribbon is the goal seeking command on in Excel?
In Excel 2007, on the Data ribbon tab, click on What-If Analysis in the Data Tools group, and select Goal Seek. In older versions of Excel it is on the Tools menu.
What is the definition for a data series?
It would be a group of cells in Excel that have values in them. These can then be identified for use in creating charts in Excel. Different charts need data series for them to show.
Is character datatype of Excel?
The name used in Excel for that data type is Text, but it is like the character data type in other computer systems.
Where is the solver located if its already loaded onto Excel?
Analysis group on the data tab
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 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 automatically group and summarize data in excel?
You use the Group and Outline option, which you can find in the Data menu.You use the Group and Outline option, which you can find in the Data menu.You use the Group and Outline option, which you can find in the Data menu.You use the Group and Outline option, which you can find in the Data menu.You use the Group and Outline option, which you can find in the Data menu.You use the Group and Outline option, which you can find in the Data menu.You use the Group and Outline option, which you can find in the Data menu.You use the Group and Outline option, which you can find in the Data menu.You use the Group and Outline option, which you can find in the Data menu.You use the Group and Outline option, which you can find in the Data menu.You use the Group and Outline option, which you can find in the Data menu.
