The following concepts will be introduced in this lab:
- Text and Numeric Entries: The information or data you enter in a cell can be text, numbers, or formulas.
- AutoCorrect: The AutoCorrect feature makes some basic assumptions about the text you are typing and, based on these assumptions, automatically corrects the entry.
- Column Width: The size or width of a column controls the amount of information that can be displayed in a cell.
- Spelling Checker: The spelling checker feature locates all misspelled words, duplicate words, and capitalization irregularities in the active worksheet and proposes the correct spelling.
- Thesaurus: The thesaurus is a reference tool that provides synonyms, antonyms, and related words for a selected word or phrase.
- Copy and Move: The contents of worksheet cells can be duplicated (copied) or moved to other locations in the worksheet or between worksheets, saving you time by not having to retype the same information.
- Range: A selection consisting of two or more cells on a worksheet is a range.
- Formula: A Formula is an equation that performs a calculation on data contained in a worksheet.
- 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.
- Function: A function is a prewritten formula that performs certain types of calculations automatically.
- Recalculation: Excel automatically recalculates formulas whenever a change occurs in a referenced cell.
- Alignment: Alignment settings allow you to change the horizontal and vertical placement and the orientation of an entry in a cell.
- Font: Fonts consist of typefaces, point sizes, and styles that can be applied to characters to improve their appearance.
- Number Format: Number formats affect the appearance of numbers onscreen and when printed.