Excel 1-2

Part I-Lesson

Excel Spreadsheets Worksheet 2

• When a number or symbol (8,+-$) is entered as the first character in a cell, the cell contains a value.
• If a value is longer than the cell, Excel displays ####### in the cell.
• A NUMERIC LABEL is a number that will not be used in calculations.
• Examples of numeric labels are social security numbers and identification numbers.
• To indicate that numeric labels are to be treated as labels and not values, it is necessary to begin the entry with a LABEL PREFIX, an apostrophe (‘).
• The label prefix is not displayed on the worksheet but is shown on the formula bar.
• A value automatically aligns to the right of the cell, making it a right-justified entry.
• A label automatically aligns to the left of the cell, making it a left-justified entry.
• Since labels are left-justified and values are right-justified in a cell, column titles (which are labels) will not appear centered over numeric data.
• You can align a label by using the alignment buttons on the Formatting toolbar.

Part II- Worksheet

1. A _________________________________ is a number that will not be used in calculation.
2. Examples of numeric labels are ______________________ numbers and ______________________ numbers.
3. When a ___________________ or ____________________ is entered as the first character in a cell, the cell contains a value.
4. If a value is longer that the cell, Excel displays ______________________ in the cell.
5. To indicate that numeric labels are to be treated as labels and not values, it is necessary to begin the entry with a __________________________________.
6. A value automatically aligns to the ______________of the cell, making it a right-justified entry.
7. The label prefix is not displayed on the worksheet but is shown on the ____________________________.
8. A label automatically aligns to the _________________ of the cell, making it a left-justified entry.
9. You can align a label by using the alignment buttons on the _____________________________.
10. Since labels are left-justified and values are right-justified in a cell, column titles (which are labels) will not appear ______________________ over numeric data.