click below
click below
Normal Size Small Size show me how
Excel Lesson 1 Vocab
| Question | Answer |
|---|---|
| Workbook | An Excel file with one or more worksheet |
| Cell Reference | The location of a cell in a worksheet as identified by its column letter and row number. Also known as the cell's address |
| Worksheet | The work area for entering and calculating data made up of columns and rows seperated by gridlines (light gray lines). Also called spreading sheet |
| Scroll | A way to view locations on the worksheet without changing the active cell |
| Cell | The intersection of a column and a row on a worksheet. You enter data into cells to create a worksheet |
| Sheet Tabs | Tavs that appear at the bottom of the workbook window, which display the name of each worksheet |
| Active Cell | The active cell contains the cell pointer. There is a dark outline around the active cell |
| Tab Scrolling Buttons | Buttons that appear just to the left of the sheet tabs, which allow you to scroll hidden tabs into view |
| Formula Bar | As you enter data into a cell, it simutaneously appears in the Formula bar, which is located above the worksheet |
| Blank Work | A new, empty workbook contains three worksheets |
| Defaults | The standard settings Excel uses in its software, such as column width or number of worksheets in a workbook |
| Template | A workbook with certain labels, formulas, and formatting presetm saving you time in creating commonly used worksheets, such as monthly invoices or balance sheets |
| Label | Text in the first row or column of a worksheet that identifies the type of data contained there |
| AutoComplete | A feature used to complete an entry based on pervious enties make in the column containing the active cell |
| AutoCorrect | A feature use to automate the correction of common typing errors |
| Pick From Drop-down List | A shortcut used to insert repeated information |
| Spelling Checker | A tool used to assist you in finding and correcting typograhical or spelling errors |
| Undo | The command used to reverse one or a series of editing actions |
| Redo | The command used to redo an action you have undo |
| Value | A number entered in the worksheet |
| Series | A list of sequential numbers, dates, times, ir text |
| Numeric Label | A numbered entered in the worksheet as a label not as a value such as the year 2005 used as a column label |
| Standard column width | The default number of characters that display in a column based on the default font |
| Label Prefix | An apostraphe used to indicate that a number is a label and not a value |
| Formula | An instruction Excel uses to calculate a number |
| Order of mathematical operations | The order in which Excel performs the calculations specified in a formula |
| Mathematical operators | Symbols used in mathematical operations |