Concepts

The following concepts will be introduced in this lab:

1. Template: A template is a workbook file that includes predefined settings that can be used as a pattern to create many common types of workbooks.
2. Text and Numeric Entries: The information or data you enter in a cell can be text, numbers, or formulas.
3. AutoCorrect: The AutoCorrect feature makes some basic assumptions about the text you are typing and, based on these assumptions, automatically corrects the entry.
4. Column Width: The size or width of a column controls how much information can be displayed in a cell.
5. Copy and Move: The contents of worksheet cells can be duplicated (copied) or moved to other locations in the worksheets or between worksheets, saving you time by not having to retype the same information.
6. Range: A selection consisting of two or more cells on a worksheet is a range.
7. Formulas: A formula is an entry that performs a calculation.
8. Relative Reference: A relative reference is a cell or range reference in a formula whose location is interpreted by Excel in relation to the position of the cell that contains the formula.
9. Functions: Functions are prewritten formulas that perform certain types of calculations automatically.
10. Recalculation: Whenever a number in a referenced cell in a formula changes, Excel automatically recalculates all formulas that are dependent on the changed value.
11. Alignment: Alignment settings allow you to change the horizontal and vertical placement and the orientation of an entry in a cell.
12. Fonts: Fonts consist of typefaces, point sizes, and styles that can be applied to characters to improve their appearance.
13. Number Formats: Number formats affect how numbers look onscreen and when printed.
14. Styles: A style consists of a combination of formats that have been named and that can be quickly applied to a selection.
15. Graphics: A graphic is a non-text element or object, such as a drawing or picture that can be added to a document.