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
unit a excel vocab
unit a excel vocabul
| Term | Definition |
|---|---|
| Worksheet | the electronic spreadsheet you work in |
| workbook | A collection of related worksheets contained within a single file . |
| Templates | to create new worksheets quickly |
| Name box | Box to the left of the formula bar that shows the cell reference or name of the active cell. |
| formula bar | the area above the worksheet grid where you enter or edit data in the active cell |
| cell | the intersection of a column and row in a worksheet, datasheet, or table |
| cell address | Relative and absolute cell addresses. If you want to use the value of a cell in a formula in another cell of the spreadsheet, |
| cell pointer | Alternatively referred to as a cell pointer or selected cell, an active cell is a rectangular box, highlighting the cell in a spreadsheet. It helps identify what cell is being working with and where data will be entered. |
| active cell | An active cell refers to a cell in Excel spreadsheet that is currently selected by clicking mouse pointer or keyboard keys. |
| sheet tabs | identify the sheets in a workbook and let you switch between sheets; located below the worksheet grid. |
| status bar | row at the bottom of a window that displays information about the window, as the status of a Web page load or details of an open document. ... British Dictionary definitions for status bar Expand. |
| mode indicator | Conscious or subconscious manner (mode) that determines the likely way in which a person behaves (perceives or reacts) in different situations. |
| range | Name a Range of Cells. In Excel, you can create names that refer to a single cell, a group of cells on the worksheet, a specific value, or a formula. |
| formula | Using formulas in spreadsheets can allow you to quickly make calculations and get totals of multiple cells, rows, or columns in a spreadsheet. |
| labels | A label most often refers to a text entry such as a heading used to identify a column of data. |
| values | A name that represents a cell, range of cells, formula, or constant value. You can create your own defined name, and Microsoft Office Excel sometimes creates a defined name for you, such as when you set a print area. |
| function | The short answer: a function is a preset formula in Excel and Google Spreadsheets that is intended to carry out specific calculations in the cell in which it is located. Function Syntax and Arguments. |
| arguments | Most of the functions found in Excel require some input or information in order to calculate correctly. For example, to use the AVERAGE function, you need to give it a range of numbers to average |
| formula prefix | Part of the Excel program window that displays the active cell address. Term. Cell. Definition ... |
| calculation operators | Formulas calculate values in a specific order. A formula in Excel always begins with an equal sign (=). The equal sign tells Excel that the succeeding characters constitute a formula. |
| comparison operators | as the name suggests, carries out a comparison between two values in the formula and the result of that comparison can only ever be either TRUE or FALSE. |
| reference operators | There are 3 Reference Operators in Excel: “:” (colon) is the Range operator, which produces one reference to all the cells between two cells references, including the cells written in the reference text, like: |
| enter button | Alternatively referred to as a Return key, when referring to a keyboard, the Enter key is used to send the cursor to the next line or execute a command or operation. |
Created by:
kfennell01
Popular Business sets