click below
click below
Normal Size Small Size show me how
Rutiri-Sprdsht Les 1
Excel Basics
| Term | Definition |
|---|---|
| Active Cell | Cell in the worksheet in which you can type data. |
| Active worksheet | This is a worksheet that is displayed in the work area. |
| Cell | It is the intersection of a column and a row in a table or worksheet. |
| Cell Reference | It is a unique identifier for a cell, which is formed by combining the cell’s column letter and row number. |
| Column | It is a vertical stack of cells in a table or worksheet. |
| Formula: | This is an equation that calculates a new value from values currently in a worksheet. |
| Formula Bar | This is a box to the right of the Name Box that displays a formula when the cell of a worksheet contains a calculated value or the results of the formula. |
| MS Office Excel 2007 | This is a spreadsheet program in Microsoft Office. |
| Name Box | This is a cell reference area located below the Ribbon, which displays the cell reference of the active cell. |
| Range | This is a group of selected cells. |
| Range Reference | Unique identifier for a range, which is the cell in its upper-left corner and the cell in its lower-right corner, separated by a colon. |
| Row | Horizontal placement of cells in a table or worksheet. |
| Sheet tab | Worksheet identifier that appears at the bottom of the workbook window. |
| Spreadsheet: | Grid of rows and columns in which you enter text, numbers, and the results of the calculations. |
| Workbook | File used to store worksheets; usually a collection of related worksheets. |
| Worksheet | Computerized spreadsheet in Excel and can contain text, numbers, and formulas. |
| Purpose of a Spreadsheet | To solve problems involving numbers. |
| Print Preview | You should print preview before printing pages. |
| Hyperlink in Excel | Right click the cell and select hyperlink, paste in the address bar. |
| Chart in Excel | Select the insert tab on ribbon and click the charts group. |
| Clearing data in Excel | Select the home ribbon, and click the editing group and clear all. |