Excel

Cell Pointer: The highlighted outline or cursor that indicates the active cell where data can be entered or edited.

Menu Bar: The top interface in spreadsheet software providing access to functions and commands like file operations, formatting, and inserting objects.

Edit Line: The formula bar above the spreadsheet grid where the content of the active cell (e.g., text, number, or formula) is displayed and can be edited.

Column Header: The labels at the top of each column, typically letters (A, B, C, etc.), used to identify and refer to entire columns or specific cells.

Sheet Tab: Located at the bottom of the spreadsheet, these allow navigation between multiple sheets within a single workbook.

Spreadsheet Row: Horizontal lines of cells in a spreadsheet, identified by numbers (1, 2, 3, etc.), used to organize and locate data.

Spreadsheet Column: Vertical lines of cells in a spreadsheet, identified by letters (A, B, C, etc.), used to organize and locate data.

Cell Range: A group of cells specified by their starting and ending cell references, separated by a colon (e.g., A1:B5).

Spreadsheet Function: Predefined operations like SUM, AVERAGE, or MAX that perform calculations on specified cell ranges or data.

Absolute Reference: A fixed cell reference that does not change when a formula is copied to another cell, denoted with $ (e.g., $A$1).

Relative Reference: A cell reference that adjusts relative to the position where a formula is copied (e.g., A1 becomes B1 when copied to the next column).

Spreadsheet Formula: An equation starting with = that performs calculations using cell references, numbers, and operators (e.g., =A1+B1).

Auto Fill: A tool that replicates a formula, sequence, or pattern across selected cells, often using the fill handle.

Column Chart: A graphical representation of data using vertical bars, ideal for comparing discrete values.

Pie Chart: A circular chart divided into slices representing proportions of a whole.

Line Graph: A chart displaying data points connected by lines, often used for showing trends over time.

Primary Key (Sorting): The main column or data category used to sort a spreadsheet.

Secondary Key (Sorting): The subsequent column or data category used for sorting when rows have identical primary key values.

Named Range: A symbolic name assigned to a cell or a range of cells to simplify referencing them in formulas. For example, a range named salesData can replace A1:A10 in formulas.

Wild Card: A character used to represent one or more unspecified characters in a formula or filter. For example, in =COUNTIF(G1:G10,"A") matches any entry starting with "A".

Symbolic Reference: Referring to cells or ranges by meaningful names (e.g., fuelCost) instead of their cell addresses (e.g., B2), improving clarity and reducing errors.

Filtering: Selecting specific rows from a spreadsheet based on certain criteria, such as only displaying rows where a value exceeds a threshold.

Conditional Formatting: A feature that applies specific formatting to cells based on defined criteria, such as highlighting cells with values above average in bold or red.

Auto Filtering: A basic filtering tool that allows users to filter data in columns using predefined criteria, such as showing only rows with specific text or numerical values.

Pivot Table: A tool for summarizing and analyzing data by grouping and aggregating values, such as calculating totals or averages across categories.

Drop-Down Menu: A list of predefined choices embedded in a cell, allowing users to select one value from the list.

Data Validation: A tool that ensures data entered into a cell meets specific criteria, such as restricting inputs to numbers within a range.

Filter: A general term for tools that limit visible rows in a spreadsheet based on conditions applied to column data.

XML: Extensible Markup Language, used to store and transport data in a structured, readable format. It allows the creation of custom tags to define the meaning of the data.

XML Tag: Markup used in XML to define the beginning and end of an element (e.g., <name> and </name>). Tags can represent identification, relationships, or collections in the data.

Database Table: A structured format for organizing data into rows and columns, where rows represent individual records, and columns represent attributes of those records.

Fundamental Database Operations: Essential tasks performed on database tables, including:

Select: Retrieve specific rows.

Project: Retrieve specific columns.

Union: Combine rows from two tables with the same schema.

Difference: Find rows in one table but not in another.

Product: Combine every row from one table with every row from another.

Join: Combine rows from two tables based on a related column.

SQL (Structured Query Language): A programming language used to manage and manipulate relational databases, enabling tasks such as querying, updating, and creating tables.

Primary Key: A unique identifier for each record in a database table, ensuring no two rows have the same key value.

Database Schema: The structure of a database, defining tables, columns, data types, relationships, and constraints.