Help
Options
Didn't know it?
click below
click below
Knew it?
click below
click below
Don't Know
Remaining cards (0)
Know
retry
shuffle
restart
0:00
Embed Code - If you would like this activity on your web page, copy the script below and paste it into your web page.
Normal Size Small Size show me how
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 |
Created by:
truly_valla
Popular Computers sets