click below
click below
Normal Size Small Size show me how
Excel vocabs
Term | Definition |
---|---|
Spreadsheet | Spreadsheets present tables of values arranged in rows and columns that can be manipulated mathematically using both basic and complex arithmetic operations and functions. |
workbook | A group of adjacent worksheets |
worksheet | Sheets in an excel workbook |
Workbook Window | is a collection of cells where you keep and manipulate the data. By default, each Excel workbook contains three worksheets. |
cell | A cell is the intersection between a row and a column on a spreadsheet that starts with cell A1. |
Sheet tab | is the current worksheet that is being displayed. |
Active worksheet | is the worksheet that is currently open. |
workspace | A workspace in Excel is a file that memorizes the current layout of all open windows and workbooks. |
columns | is a vertical series of cells in a chart, table, or spreadsheet. |
rows | A row is the range of cells that go across (horizontal) the spreadsheet/worksheet. |
headings | is the colored row of letters used to identify each column within the sheet, or workbook. |
Cell reference | refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate. |
Name box | is the box to the left of the formula bar that displays the cell that is currently selected in the spreadsheet. |
Formula bar | 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 | Using formulas in spreadsheets can allow you to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet. |
Relative reference | When copied across multiple cells, they change based on the relative position of rows and columns. |
Absolute reference | remain constant, no matter where they are copied. |
Mixed reference | A mixed cell reference is either an absolute column and relative row or absolute row and relative column |
Active cell | is the selected cell in which data is entered when you begin typing. |
Enter data | When you enter text or numbers in Microsoft excel worksheets. |
range | A group of selected cells |
Gridlines | A solid lines that marked of the rows and columns in a worksheet |