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 |