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 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.

Wild Card

A character used to represent one or more unspecified characters in a formula or filter.

Symbolic Reference

Referring to cells or ranges by meaningful names instead of their cell addresses, improving clarity and reducing errors.

Filtering

Selecting specific rows from a spreadsheet based on certain criteria.

Conditional Formatting

A feature that applies specific formatting to cells based on defined criteria.

Auto Filtering

A basic filtering tool that allows users to filter data in columns using predefined criteria.

Pivot Table

A tool for summarizing and analyzing data by grouping and aggregating values.

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.

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.

XML Tag

Markup used in XML to define the beginning and end of an element.

Database Table

A structured format for organizing data into rows and columns.

Fundamental Database Operations

Essential tasks performed on database tables, including Select, Project, Union, Difference, Product, Join.

SQL (Structured Query Language)

A programming language used to manage and manipulate relational databases.

Primary Key

A unique identifier for each record in a database table.

Database Schema

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