click below
click below
Normal Size Small Size show me how
Excel Vocabulary
Term | Definition |
---|---|
Spreadsheet | An application used to store and analyze data. |
Workbook | An excel file. |
Worksheet | Sheets in an excel workbook. |
Workbook Window | The active workbook that is open. |
Cell | The intersection of a row and column. |
Sheet Tab | Used to display a worksheet. |
Active Worksheet | In a spreadsheet program such as Excel or Google Spreadsheets, the active sheet is the worksheet you are working on. |
Workspace | A file that memorizes the current layout of all open windows and workbooks. |
Columns | Vertical part of the worksheet grid identified by the letters A to Z and AA to XFD. |
Rows | Horizontal part of the worksheet grid identified by the numbers 1 to 1,048,576 |
Headings | Row numbers and column letters. |
Cell Reference | The column letter and row number that identify a cell such a B3. |
Name Box | Displays the cell reference of the active cell. Located at the top of the worksheet. |
Formula Bar | Displays the active cell’s contents. Located above the cells. |
Formula | Mathematical statement used to calculate a value. A formula must always begin with an equals sign. |
Relative Reference | A cell reference that reflects the row or column it has been copied to. |
Absolute Reference | A cell reference the remains constant no matter where they are copied. |
Mixed Reference | A cell reference that is either an absolute column and relative row or absolute row and relative row. |
Active Cell | The cell displayed with a bold border. Also called the selected cell. |
Enter Data | Entering data into excel, you can add by selecting a cell and begin typing. |
Range | Entering data into excel, you can add by selecting a cell and begin typing. |
Gridlines | Solid lines that mark off the rows and columns in a worksheet. |