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 |