Computer Specialist in Spreadsheet Level 2 key terms

The small field left of the formula bar that shows the address of the active cell and accepts a typed reference, range name, or named range to jump directly to that location.

The single currently selected cell that receives typed entries and formatting commands; it is outlined with a thicker border and its address appears in the Name Box.

The horizontal input area above the worksheet grid where the underlying content of the selected cell is displayed and can be edited, including formulas rather than their results.

The tabbed command strip at the top of the application window that groups related tools into tabs and contextual groups, replacing the older menu-and-toolbar layout.

A small customizable button strip, usually beside the title bar, holding frequently used commands such as Save and Undo so they remain reachable regardless of which ribbon tab is open.

The full-window area opened from the File tab that contains document-level commands such as New, Open, Save, Print, Share, and file properties rather than worksheet editing tools.

The saved file that contains one or more worksheets along with charts, defined names, and settings; it is the unit that is opened, saved, and shared.

A single grid page of columns and rows inside a workbook, holding cells in which data and formulas are entered; several worksheets can exist in one file.

The labeled tab at the bottom of the window that identifies each worksheet and is used to activate, rename, color, move, copy, or delete that sheet.

A state in which two or more worksheets are selected together so that entries and formatting applied to one are applied to all selected sheets simultaneously.

A view setting that locks specified rows or columns in place so they stay visible while scrolling through the rest of a large worksheet.

A view feature that divides one worksheet into independently scrollable panes separated by draggable bars, letting a user compare distant parts of the same sheet.

The column-letter and row-number address that identifies a cell, such as B7; it may be relative, absolute, or mixed depending on the dollar signs used.

A cell address written with dollar signs before both column and row, such as $B$7, so it does not shift when the formula is copied to another location.

A cell address without dollar signs, such as B7, that adjusts its column and row automatically when a formula is copied or filled to a new position.

A cell address in which only the column or only the row is locked with a dollar sign, such as $B7 or B$7, so copying changes just one part of the address.

The small square at the lower-right corner of a selection that is dragged to copy content or continue a series into adjacent cells, with AutoFill options offered afterward.

The feature that extends a pattern such as months, weekdays, or a numeric step into neighboring cells when the fill handle or Fill command is used.

A data-entry aid that detects a pattern from examples typed in an adjacent column and automatically fills the remaining rows with the same transformation, without formulas.

A wizard that splits the contents of one column into several columns using a delimiter such as a comma or fixed character widths.

The character, such as a comma, tab, or semicolon, that separates values in imported or pasted text and tells the import or split process where one field ends.

A descriptive label assigned to a cell or range so formulas and navigation can refer to it by name instead of by address, improving readability and maintenance.

A formula syntax that refers to table parts by table and column names, such as a table name with a column in brackets, instead of ordinary cell addresses.

A built-in named routine that performs a calculation on supplied arguments and returns a result, such as SUM, AVERAGE, or IF, entered after an equals sign.

An input value supplied to a function inside its parentheses, which may be a number, text, cell reference, range, or another expression, separated by commas.

A function used as an argument inside another function, as when an IF is placed within a SUM or an AVERAGE is placed inside a ROUND.

A lookup function that searches for a value in the leftmost column of a range and returns a value from a specified column in the same row.

A lookup mode that finds the largest value less than or equal to the search value, requiring the lookup column to be sorted ascending; used for grade or tax brackets.

A lookup mode that returns a result only when the search value is found precisely, typically selected by entering FALSE or zero as the last lookup argument.

A rule-based feature that changes a cell's fill, font, or border automatically when its value meets a specified condition, such as being above average or containing text.

A saved combination of formatting attributes, such as font, number format, alignment, and borders, that can be applied to cells in one step and updated centrally.

The display setting that controls how a numeric value appears, including decimal places, thousands separators, currency symbols, percentages, and date patterns, without changing the stored value.

A command that combines selected adjacent cells into one larger cell and centers its content, commonly used for titles spanning several columns.

A defined range of cells designated to be the only part of a worksheet that prints, ignoring everything outside the specified selection.

Rows or columns set to repeat at the top or left edge of every printed page, keeping header labels visible across a long multi-page report.

A manual or automatic division that determines where one printed page ends and the next begins, adjustable in Page Break Preview view.

A graphic representation of worksheet data in which values are plotted as bars, lines, columns, or other marks, linked to the source cells so it updates when they change.

The set of related values plotted from one row or column of worksheet data, shown as one line, bar set, or slice group within a chart.

The chart element that maps colors or patterns to the data series or categories they represent, helping readers identify what each plotted element stands for.

A tiny chart drawn inside a single cell that shows the trend of a row or column of values without axes or labels, useful in compact dashboards.

A specially formatted range with a name, header row, banded rows, filter buttons, and automatic expansion, enabling structured references and easier sorting and filtering.

A filter control added to column headers that shows drop-down menus for choosing values or conditions, temporarily hiding rows that do not match.

A filtering method that uses a separate criteria range with labeled columns and logical conditions to extract or hide records matching complex multi-column rules.

A separate area of cells containing column headings and the conditions beneath them that the Advanced Filter command uses to decide which records to show.

A summary calculation inserted for groups of sorted records, often with automatic outline levels, that can also count, average, or find the maximum within each group.

Collapsible row or column levels created by subtotals or manual grouping, letting a user hide detail rows and show only summary lines.

An interactive summary object that groups and aggregates large data sets by dragging fields into row, column, value, and filter areas, recalculating as the layout changes.

A chart linked to a PivotTable that reflects the same summarized data and updates when the table's fields, filters, or layout are changed.

A floating set of buttons that filters a PivotTable or table by clicking values, showing the current selection state without opening a drop-down menu.

A date-based filter control for PivotTables that lets a user select a period such as a month, quarter, or year with a slider instead of individual date check boxes.

A set of tools, including data tables, goal seek, and scenario manager, that shows how results change when input values are varied.

A tool that works backward from a desired formula result to find the single input value needed to reach it, adjusting one cell at a time.

A tool that stores named sets of changing input values and switches between them to compare the resulting outcomes without retyping data.

A collaboration setting that records insertions, deletions, and edits made by each user along with the author name and time, allowing review and acceptance.

A note attached to a cell by a reviewer that appears on hover or in a pane, used to discuss content without altering the worksheet values.

A restriction that prevents unauthorized users from changing locked cells, inserting rows, or altering structure until the password, if set, is supplied.

A workbook enabled for simultaneous editing by several users, merging their saved changes and flagging conflicts for resolution.

Real-time collaborative editing in which multiple users work in the same stored workbook at once and see each other's changes appear as they are saved.