Name the different types of data that can be inserted in the Excel worksheet
Answers
Answered by
2
Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters.
Values (numbers) are generally raw numbers or dates.
Formulas are instructions for Excel to perform calculations.
Label: Excel aligns text to the left side of the cell. If the text is too wide to fit, Excel extends that data past the cell width if the next cell is blank. If the next cell is not blank, Excel displays only enough text to fit the display width. Widening the column displays additional text.
Whole value: If the data is a whole value, such as 34 or 5763, Excel aligns the data to the right side of the cell.
Value with a decimal: If the data is a decimal value, Excel aligns the data to the right side of the cell, including the decimal point, with the exception of a trailing 0. For example, if you enter 246.75, then 246.75 is displayed; if you enter 246.70, however, 246.7 appears.
Date: If you enter a date, such 12/16, Dec 16, or 16 Dec, Excel automatically returns the value in your default date format (16-Dec if you haven’t changed it) in the cell, but the Formula bar displays 12/16/2010
hope it helps
thank u
Values (numbers) are generally raw numbers or dates.
Formulas are instructions for Excel to perform calculations.
Label: Excel aligns text to the left side of the cell. If the text is too wide to fit, Excel extends that data past the cell width if the next cell is blank. If the next cell is not blank, Excel displays only enough text to fit the display width. Widening the column displays additional text.
Whole value: If the data is a whole value, such as 34 or 5763, Excel aligns the data to the right side of the cell.
Value with a decimal: If the data is a decimal value, Excel aligns the data to the right side of the cell, including the decimal point, with the exception of a trailing 0. For example, if you enter 246.75, then 246.75 is displayed; if you enter 246.70, however, 246.7 appears.
Date: If you enter a date, such 12/16, Dec 16, or 16 Dec, Excel automatically returns the value in your default date format (16-Dec if you haven’t changed it) in the cell, but the Formula bar displays 12/16/2010
hope it helps
thank u
Similar questions