click below
click below
Normal Size Small Size show me how
Excel Vocabs
Excel Vocabs / Definition
| Definition | Word |
|---|---|
| ~Document in which data is arranged in rows and columns of a grid. ~Can be manipulated and used in calculations. | Spreadsheet |
| ~is the MS Excel file in which you enter and store related data. | Workbook |
| ~(also known as a spreadsheet) is a collection of cells on a single "sheet". ~Where you actually keep and manipulate the data. | Worksheet |
| ~Window where it displays the spreadsheet/worksheet in a workbook | Workbook |
| ~are usually identified by a column letter and a row ~is analogous to a field in database management systems. | Cell |
| ~The sheet tabs at the bottom of the window show | Sheet Tabs |
| ~An active worksheet is the worksheet that is currently open. | Active Worksheet |
| ~Excel is a file that memorizes the current layout of all open windows and workbooks. | Workspace |
| ~is a vertical series of cells in a chart, table, or spreadsheet. | Columns |
| ~is the range of cells that go across (horizontal) the spreadsheet/worksheet. | Rows |
| ~In Excel and other spreadsheet applications, the column header is the colored row of letters used to identify each column within the sheet, or workbook. | Headings |
| ~refers to a cell or a range of cells on a worksheet and can be used in a formula | Cell Reference |
| ~ is the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet. | Name Box |
| ~A toolbar at the top of the Microsoft Excel spreadsheet window that you can use to enter or copy an existing formula in to cells or charts. | Formula Bar |
| ~Allow you to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet. | Formula |
| ~change when a formula is copied to another cell | Relative Reference |
| ~remain constant, no matter where they are copied. | Absolute References |
| ~is either an absolute column and relative row or absolute row and relative column. | Mixed Cell Reference |
| ~is the selected cell in which data is entered when you begin typing. ~It is the cell surrounded by a black border. | Active Cell |
| ~Data that is typed into a cell | Enter Data |
| ~Place or arrange in a row or rows or in a specified order or manner. | Range |
| ~Alternatively referred to as a column separator or row separator. ~are the light gray lines that divide each of the cells, rows, and columns in a spreadsheet. | Gridlines |