Free since 2005 · No login required
AT

Academic Tutorials

Learn at your own pace

site-mobile-top-banner · 320x50

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