Term
|
Definition
| An electronic spreadsheet program |
|
|
Term
| Electronic spreadsheets are used to perform |
|
Definition
| numeric calculations and analyze numeric data |
|
|
Term
| Spreadsheets are also called |
|
Definition
|
|
Term
| Work Sheets are contained in |
|
Definition
|
|
Term
| Default number of work sheets in a workbook |
|
Definition
|
|
Term
|
Definition
a. Enter data quickly and accurately b. Recalculate easily c. Perform "what-if" analyses
d. Change appearance of info
e. Create charts
f. Share info and build and collaborate on previous work |
|
|
Term
|
Definition
| a decision making tool in which data is changed and formulas are rearranged in order to predict various outcomes. |
|
|
Term
|
Definition
| From desktop icon or Search All Programs - MS Office |
|
|
Term
| Worksheets are composed of |
|
Definition
|
|
Term
| Columns are ____________ and are labeled ______________________. |
|
Definition
| Vertical, Alphabetically ex: A-Z, AA-ZZ |
|
|
Term
| Rows are __________________ and are labeled ______________________. |
|
Definition
| Horizontal, Numerically ex: 1,2,3,4 etc |
|
|
Term
|
Definition
| Intersections of columns and rows. They are also the basic unit of the worksheet. |
|
|
Term
|
Definition
| Identifies unique coordinates of the cell based on intersection of the column and row. Ex: A1 |
|
|
Term
|
Definition
| Dark rectangle outlining the cell you are working in (indicates where data will be entered) |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Displays the program name and file name of the open worksheet also contains QAT and resizing buttons. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Displays active cell address |
|
|
Term
|
Definition
| A selection of 2 or more cells. |
|
|
Term
|
Definition
| Equations in a worksheet. |
|
|
Term
|
Definition
| Area above worksheet grid where you can enter data in the active cell. (fx) |
|
|
Term
|
Definition
| Identifies sheets in a worksheet, you can switch back and forth and change their order. |
|
|
Term
|
Definition
| Bottom of windows - displays brief description of active command/mode (ready, edit) |
|
|
Term
|
Definition
| Descriptive text or other info that identifies rows, columns, charts, but is NOT included in calculations. |
|
|
Term
|
Definition
| Includes numbers, formulas and functions used in calculations. |
|
|
Term
| Moving around the worksheet |
|
Definition
| Use your cursor and mouse or cursor movement keys (arrow keys) |
|
|
Term
|
Definition
|
|
Term
| Excel left arrow shortcut |
|
Definition
|
|
Term
| Excel right arrow shortcut |
|
Definition
| Moves 1 cell to the right |
|
|
Term
| Excel [Alt] + [Page Up] shortcut |
|
Definition
| Moves left one full screen |
|
|
Term
| Excel [Alt] + [Page Down] shortcut |
|
Definition
| Moves right one full screen |
|
|
Term
| Excel [CTRL] + [Home] shortcut |
|
Definition
|
|
Term
|
Definition
| Moves to column A in current row |
|
|
Term
|
Definition
a. Press "Find and Select" button, found in Editing group on Home tab.
b. Press F5 - Takes you to "Go-To" dialog box |
|
|
Term
| You start creating a worksheet by |
|
Definition
| typing in your selected cell in a blank worksheet |
|
|
Term
| Once you have finished entering or editing your entry, |
|
Definition
click the green check mark on the formula bar; you may also hit the enter key on your keyboard - this will also move your cell pointer one row down.
Press tab to enter data and move cell pointer 1 column to the right. |
|
|
Term
| If you notice an error after confirming an entry you can |
|
Definition
a. Click undo
b. click back in the cell you want to fix and press F2, then backspace or delete
*F2 IS EDIT MODE |
|
|
Term
|
Definition
| Perform calculations using cell values - simple and complex! |
|
|
Term
| The equal sign (=) is called |
|
Definition
| The formula prefix-starts all calculations |
|
|
Term
|
Definition
| Using cell addresses or ranges |
|
|
Term
|
Definition
+ addition
- subtraction
* multiplication
/ division
do percentage |
|
|
Term
|
Definition
| Predefined worksheet formulas that enable you to perform complex calculations easily. |
|
|
Term
| Remember to always begin function with the |
|
Definition
| formula prefix! The = equal sign |
|
|
Term
|
Definition
| The argument that adds all the numbers in a range of cells. |
|
|
Term
|
Definition
| The argument that returns the arithmetic mean of the argument. |
|
|
Term
|
Definition
|
|
Term
|
Definition
| Displays the smallest value. |
|
|
Term
|
Definition
| Calculates the number of values in a range in the argument. |
|
|
Term
| Function results appear in ____________________ if the range is columns |
|
Definition
|
|
Term
| Function results appear _________________ if the range is in rows |
|
Definition
|
|
Term
| 2 Ways to insert a Function |
|
Definition
a. use the insert function button (fx) on the formula bar
*When you use the fx button, Excel automatically inserts the = sign
b. click the AutoSum button list arrow to enter frequently used functions. (found on the Home tab) |
|
|
Term
| Any information, vlaue, range, text, function inside parenthesis is called an |
|
Definition
|
|
