click below
click below
Normal Size Small Size show me how
excell
| Term | Definition |
|---|---|
| Spreadsheet - | - A grid of rows and columns used to organize and store data. |
| Cell - | The individual box in a spreadsheet where data is entered. It’s located at the intersection of a row and a column (e.g., A1, B2). |
| Row | Horizontal lines in a spreadsheet, labeled by numbers (1, 2, 3, etc.). |
| Column - | - Vertical lines in a spreadsheet, labeled by letters (A, B, C, etc.). |
| Formula - | A math equation or function entered into a cell to perform calculations automatically (e.g., =SUM(A1)). |
| Function - | Predefined calculations in Excel (e.g., =SUM, =AVERAGE) that simplify mathematical tasks. |
| SUM - | A function that adds up numbers in a range of cells (e.g., =SUM(A1)). |
| AVERAGE | A function that calculates the average of a set of numbers (e.g., =AVERAGE(B1)). |
| Chart - | - A graphical representation of data (e.g., bar charts, pie charts) to make information easier to understand. |
| Formatting - | - Changing the appearance of cells (e.g., bold, font size, color) to make the spreadsheet easier to read. |
| Cell Reference - | - The name of a cell, identified by the letter of its column and the number of its row (e.g., A1). |
| Range - | A group of selected cells in a spreadsheet (e.g., A1 refers to all cells from A1 to A10). |
| Filter | A tool used to display only specific data in a spreadsheet while hiding other data. |
| Sort | A tool used to arrange data in ascending (smallest to largest) or descending (largest to smallest) order. |
| AutoSum | A quick way to automatically add a range of cells using the SUM function. |
| Worksheet | A single page in an Excel file (workbook) where data is entered. A workbook can contain multiple worksheets. |
| Workbook | An Excel file containing one or more worksheets. |
| Merge Cells | Combining multiple cells into one larger cell. |
| Data Validation | A tool that restricts the type of data that can be entered in a cell (e.g., setting rules like “numbers only”). |
| Conditional Formatting | A feature that changes the appearance of cells based on their values (e.g., highlighting all cells with values greater than 100). |