click below
click below
Normal Size Small Size show me how
lesson 1
Excel
Term | Definition |
---|---|
Workbook | An excel file with one or more worksheet. |
worksheet | The work area for entering and calculating data made up of columns and rows separated by grid lines. |
cell | The intersection of a column and a row on a worksheet. You enter data into cells to create a worksheet. |
Active cell | The active cell contains the cell pointer. There is a dark outline around the active cell. |
Formula Bar | As you enter data into a cell, it simultaneously appears in formula bar, which is located above the worksheet. |
Cell Reference | The location of a cell in a worksheet as identified by its column letter and row number. |
scroll | A way to view locations on the worksheet without changing the active cell. |
Sheet Tabs | Tabs that appear at the bottom of the workbook window, which display the name of each worksheet. |
Tab scrolling Buttons | Buttons that appear just to the left of the sheet tabs, which allow you to scroll hidden tabs into view. |
Label | Text in the first row or column of a worksheet that identifies the type of data contained in there. |
Defaults | The standard settings excel uses in its software, such as a column width or number of work sheets in a notebook. |
Auto Complete | A feauture used to complete an entry based on previous entries made in the column containing the active cell. |
Auto Correct | A feature used to automate the correction of common typing errors. |
Value | A number entered in the worksheet. |
Series | A list of sequential numbers, dates, times, or text. |
Label Prefix | An apostrophe used to indicate that a n umber is a label and not a value. |
Numeric Label | A number entered in worksheet as a label, not as a value. |
Formula | An instruction Excel uses to calculate a number. |
Mathematical operators | Symbols used in math operations. |
Order Of Mathematical Operations | The order in which excel performs the calculations specified in a formula. |