answersLogoWhite

0


Best Answer

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

User Avatar

Wiki User

11y ago
This answer is:
User Avatar
More answers
User Avatar

Wiki User

11y ago

In Excel it allows you to do analysis based on a formula having one or two values changed to produce a table of various results. It will take values from the first row and first column and use them in a formula. The initial formula is in the cell on the first row and first column, in other words the top left cell of the table. Whatever the formula does, it then uses the values to fill the table. So say you put a formula in the top corner cell which adds two cells. Then you would use the first value on each row and column of the table as values for the formula.

This answer is:
User Avatar

Add your answer:

Earn +20 pts
Q: What is the purpose of using Data Tables?
Write your answer...
Submit
Still have questions?
magnify glass
imp
Related questions

Feature of rdbms?

It stores data in tables. Tables have rows and column. These tables are created using SQL. And data from these tables are also retrieved using SQL


What is the purpose of relating tables in a database?

to calculate data more effectively


What is the purpose of data table?

The purpose of data tables is to present tabular information in a grid, or matrix, and to have column or rows that show the meaning of the information in the grid.


What is the purpose of a data chart?

the purpose of a data chart is to write your data down by using your chart


Is data often represented by using tables diagrams and graphs?

true A+


Definition of numerical data?

Numerical data is data measured or identified on a numerical scale. Numerical can be analyzed using statistical methods, and results can be displayed using tables, charts, histograms, and graphs.


What links two tables using a common field in both tables and extracts the relevant data from each?

A join operation links two tables using a common field and extracts relevant data. By specifying the common field in the ON clause of a SQL query, the database can combine rows from both tables based on matching values in that field. This allows data to be retrieved from multiple tables in a single query.


What is the difference between data model and database model?

A database is a collection of tables that is used for some purpose (typically an application of some sort). A database model is a description of that database, and describes how the tables relate to each other. Typically, a model is designed first, then the actual database is implemented using the model as a blueprint.


How do you relate tables?

You can relate the data present in multiple tables by using the concept of Foreign Keys. for example if we have an employee database that contains various details of an employee scattered in multiple tables, one column in each table can be used to logically group the data in all these tables. For example, the employee number column in each of these tables can be used to relate the data present in these tables.


What are the advantages of de-normalized data?

1. We can retrieve the data from tables using less number of joins. 2. The data is more centralized.


How do you related?

You can relate the data present in multiple tables by using the concept of Foreign Keys. for example if we have an employee database that contains various details of an employee scattered in multiple tables, one column in each table can be used to logically group the data in all these tables. For example, the employee number column in each of these tables can be used to relate the data present in these tables.


What is the purpose of using monitoring systems?

The purpose of using monitoring systems is to capture data. Another purpose of using monitoring systems is to monitor the environment for security purpose.