answersLogoWhite

0

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

12y ago

What else can I help you with?

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 is the main purpose of relating data between tables in a database?

The main purpose of relating data between tables in a database is to establish connections between different pieces of information, allowing for efficient querying and retrieval of data. This relationship helps to avoid data duplication and ensures data integrity by enforcing constraints and maintaining consistency across the database.


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.


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.


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.