D388 Excel
1. Formatting: Changing the appearance of the
data ana cells in a worksheet
2. Range of cells: Is a consecutive block of cells
arranged in a row, a column, or a combo of both. To
specify a range of cells you specify The upper
range followed by the ":" character. And then the
lower right cell in the range
Ex:
B1:B4 —-> refers to b1,b2,b3,b4
A2:C2-> a2, b2, c2
3. Number (data type): Used to define any type
of number and can be configured to display the
number in standardized ways, such as with a fixed
number of decimal places.
4. Currency (data type): Used to define a
number as money; currency values will be
displayed with a monetary symbol (such as a dollar
sign) appropriate for the currency described and
two decimal places. Currency data can be
, configured to highlight negative numbers in
specific ways (such as using a red font).
5. Accounting (data type): Used to define a
number as money; the accounting data type has
fewer options than the currency type. The
accounting data type displays data with a currency
symbol and two decimal places.
6. Date (data type): Used to display the number
in a cell as a date; the date data type has several
display options, such as "12/18/1973" or "Tuesday,
December 18, 1973."
7. Time (data type): Used to display the contents
of a cell as a specific time of day, such as "11:35
AM."
8. Percentage (data type): used to display the
contents of a cell as a percent; the percentage
data type is displayed with the % symbol.
1. Formatting: Changing the appearance of the
data ana cells in a worksheet
2. Range of cells: Is a consecutive block of cells
arranged in a row, a column, or a combo of both. To
specify a range of cells you specify The upper
range followed by the ":" character. And then the
lower right cell in the range
Ex:
B1:B4 —-> refers to b1,b2,b3,b4
A2:C2-> a2, b2, c2
3. Number (data type): Used to define any type
of number and can be configured to display the
number in standardized ways, such as with a fixed
number of decimal places.
4. Currency (data type): Used to define a
number as money; currency values will be
displayed with a monetary symbol (such as a dollar
sign) appropriate for the currency described and
two decimal places. Currency data can be
, configured to highlight negative numbers in
specific ways (such as using a red font).
5. Accounting (data type): Used to define a
number as money; the accounting data type has
fewer options than the currency type. The
accounting data type displays data with a currency
symbol and two decimal places.
6. Date (data type): Used to display the number
in a cell as a date; the date data type has several
display options, such as "12/18/1973" or "Tuesday,
December 18, 1973."
7. Time (data type): Used to display the contents
of a cell as a specific time of day, such as "11:35
AM."
8. Percentage (data type): used to display the
contents of a cell as a percent; the percentage
data type is displayed with the % symbol.
