What are some common Excel terms?
Workbook – an Excel file with more than one worksheet
Worksheet – Also known as a Spreadsheet. A workbook may contain more than one worksheet. On start up Excel displays an empty workbook with three worksheets.
Cell – An intersection of a Column and Row where you enter your data.
Example: A1 is the name of a cell location with A being the Column and the 1 being the Row
Active Cell – Contains the cell pointer (cursor). The name of the cell appears to the left side of the Formula Bar
Formula Bar – Located above the worksheet frame-where the data is displayed when entered.
Sheet Tabs – Appear at the bottom of the Workbook Window and displays the name of each worksheet.
Tab Scrolling buttons – Navigate in the Sheet, between worksheets.
Name Box – Displays the reference or name of the currently active cell.
Labels – Text that appears above a column or beside a row to identify the type of data that will appear. Always appear to the left of the Cell.
Template – Pre-designed Workbooks. Can select templates from existing files installed on Excel installation or can get templates from the Microsoft.com Website. Options display in the Task pane
Auto Complete Feature – Used to complete an entry based on consecutive entries made in the same column.
Pick from the List – A shortcut used to insert repeated information. Click on the cell with the right mouse button and view words in the list.
Numeric Labels – number entered into a worksheet as a label, not as a value such as Social Security Number
Label Prefix – An apostrophe ‘ used to indicate that a number is really a label and not a value. When you enter a value with an apostrophe, Excel displays a green triangle in the upper left corner of the cell.
Values – Numbers, Formulas, and Functions. Can be used in calculations. Always appear to the right of the cell.
Series – A list of sequential numbers such as dates, times or test. Can fill series on the following options: Days, Weekdays, Months, and Years. Create tan incremental series-copy cells, Fill series, Fill formatting only or Fill without formatting