0
For Excel, it depends on the kind of table you are setting up. You can have a one-input or a two-input table. For a one input you put a set of figures either in a column or a row. You then need a formula for the table to work off. That is put at the top of the empty column that you want data to go into, or the start of the empty row that you want to put data into. Select your formula, the row/column of figures and the blank row/column where data is going to go. You then start the Data Table option. You will be asked for a row input and a column input. If you have your figures in a column, then you put a cell reference into the column input that is in the formula. If they are in a row, then you use the row input. The data fills in then. For a two-input, you will have data in a row and data in a column and a formula in the cell which is above the column and at the start of the row, or the top left cell in the table. You select the row and column with the existing data and the area you want the data to go into. Pick your row and colmn inputs based on the cells in the main formula. Your table will then fill in.
Wiki User
∙ 9y ago
Add your answer:
Earn +20 pts
To learn the proper way to set up a table of contents editors can use a?
It can use a style manual.
What is a way to organize data in columns?
Data organized into columns and rows is called a table.
What does a data table provide?
A data table provides an organized way to collect and record observations.
What is the best way to show a lot of numerical data in very small space?
A data table is the best way to show a lot of numerical data in a very small place.
A good way to organize and record your results and observations is?
A way to organize and record results and observations is using data table
In carrying out a controlled experiment what does a data table help you do?
It helps you record your data. A data table provides an organized way to collect and record observations.
What does a data table help you do when carrying out a controlled experiment?
A data table provides an organized way to collect and record observations.
What is the simplest way to organize data?
put them in a table
What kind of table is one way to organize data into categories or groups?
A Frequency Table
Describe the usefulness of a table in mode of presentation of data?
A table is very useful in making complicated information easier to understand. A table is also a good way to summarize data.
What is the proper way to cloth a table in fine dining?
You have to gently clean the dining table with towel, and then cloth it the way you want! Have a good Dinner!
When you sort data in a query the records in the underlying table are actually rearranged?
No. Most queries list off data, but does not affect the underlying data. Certain types of query can be used to change data in a table, but do not re-arrange the order of the data in the table itself. That is determined by the indexes, mainly the primary key. You can sort the data in the table itself and have it remain that way.
