click below
click below
Normal Size Small Size show me how
Functions for Excel
| Term | Definition |
|---|---|
| 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)) |
| 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 |
| 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 |