click below
click below
Normal Size Small Size show me how
exel
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). |