0
Is it usually best to use columns rather than rows for the most abundant data in the worksheet?
Wiki User
∙ 10y ago
In a worksheet data should normally be laid out like a database, in a tabular format where possible. So data of the same type, should be organised in columns, like fields in a database. Data relating to one particular entity should be organised in rows like a record in a database. In some cases it could be organised in either way, depending on the nature of the data and what the user wants to be able to get from it.
Wiki User
∙ 10y ago
Add your answer:
Earn +20 pts
What is 3 dimensional worksheet?
It is normally a workbook that is 3 dimensional rather than a worksheet. Each worksheet consists of cells laid out in rows and columns. These are the first two dimensions. However, you can also have a "stack" of worksheets where ranges can be defined in terms of the same cell in a set of worksheets. This, then, is the third dimension.
Is there potassium on the earth?
Yes. Potassium is rather abundant on Earth.
Are categories reserved for rows or columns in Excel?
It can be both, though normally we arrange things in columns rather than rows. When you create a chart there is an option as to which way to chart the data, either by row or columns.
Why you colour columns rather than rows in periodic table?
because of energy levels
Does the formulas version in the worksheet show the actual formula you have entered rather than the resulting values?
Yes.
What is an activity worksheet?
The one currently on your screen (with a highlighted top bar, rather than the ones with grey outlines).
What term describes a temple with a series of engaged columns rather than a free standing colonnade?
pseudoperipteral
What are Rococo Architecture influences?
rococo has more ornamentation rather that baroque architecture. a good example of this is their columns
What happens when you hide a column in Microsoft Excel?
The column disappears from view so you cannot see it. You will notice its heading is missing, so if column H was hidden you would see column G and then column I. The values in column H can still be used in the worksheet by referencing them in the normal way. Hiding columns can be useful for hiding data that you do not want to be seen or that you do not want users to change or that does not need to be seen. It can be used to put in supporting data to a worksheet rather than having it cluttering up the screen by being visible.
When sorting a Excel worksheet can you sort multiple columns within the same sort?
You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.You can sort multiple columns, based on one or more column. The first selected column is the one that determines the sort order when you have multiple columns selected. You can also sort using multiple columns to determine the sort, like sorting surnames, and within that, sorting people who have the same surname by firstname. All of this can be done through the sort options, rather than just clicking on the icon to do a simple sort.
When you set up a worksheet should you use cell references and formulas whenever possible rather than logical values?
You use formulas rather than actual numeric values. Logical values are usually generated from formulas, so they are rarely typed in literally, so you would type formulas in instead of them, with cell references in those formulas, and possibly some values.
Why does water exists on the moon and mars?
Water is abundant in space, the problem is rather that was the water exist in significant amount on any particulars planet.
