Computer Specialist in Spreadsheet Level 2 flashcards

36 cards. Read the term and the definition here. The deck at the top of this page is optional.

Name Box

A field at the left of the formula bar that shows the active cell reference and accepts typed references or defined names to jump directly to that location.

Status Bar Statistics

The bottom status bar can display Average, Count, Numerical Count, Min, Max, and Sum for selected cells; right-click it to choose which statistics appear.

Contextual Ribbon Tabs

Extra tabs such as Table Tools, Chart Tools, and PivotTable Tools appear only when the matching object is selected, then disappear when the selection changes.

Grouped Sheets

Multiple sheets selected with Ctrl+click or Shift+click accept identical entries and formatting at once. Ungroup by right-clicking a tab before making further edits.

Freeze Panes

Locks rows above and columns left of the active cell so they stay visible while scrolling. Unfreeze Panes on the View tab restores normal scrolling behavior.

Protect Workbook

A Review tab option that blocks structural changes such as inserting, deleting, renaming, or moving sheets, while leaving cell contents editable unless sheets are also protected.

Move or Copy Sheet

A dialog that relocates a sheet within or across workbooks; checking Create a copy duplicates it instead of moving it, and the To book list picks the destination.

Ctrl+Enter Fill

After typing a value in a multi-cell selection, pressing Ctrl+Enter enters that same value into every selected cell without repeating the typing.

Flash Fill

Triggered with Ctrl+E, it detects a pattern from one or two typed examples and fills the remaining column with static results, not formulas.

Paste Special Transpose

A paste option that swaps rows and columns of copied data, turning a horizontal list into a vertical one while optionally pasting only values or formats.

Data Validation

A restriction on cell input by list, whole number, decimal, date, time, or custom formula, optionally paired with an input message and an error alert.

Absolute Reference

A reference written with dollar signs, such as $A$1, that keeps both column and row fixed when the formula is copied to other cells.

VLOOKUP Exact Match

Setting the fourth argument to FALSE or 0 forces an exact match; omitting it defaults to approximate match, which requires sorted data and can return wrong values.

IFERROR Function

Returns a specified alternative when a formula produces any error, including #N/A, #DIV/0!, and #VALUE!; IFNA handles only the #N/A error.

INDEX and MATCH

MATCH finds a value's position in a range and INDEX returns the item at that position, enabling lookups to the left of the key column.

SUMIFS Function

Adds values meeting multiple criteria across separate ranges. All criteria ranges must match the sum range in size and shape, and criteria combine with AND logic.

Accounting Number Format

Aligns currency symbols at the left of the cell and shows a dash for zero values, unlike Currency format, which places the symbol directly beside each number.

Conditional Formatting Rules Manager

Controls priority order of rules on a range and offers Stop If True, which prevents lower-priority rules from applying when a condition is met.

Center Across Selection

A horizontal alignment option that visually centers text over adjacent empty cells without merging them, preserving separate cell references and sorting behavior.

Print Titles

A Page Layout setting that repeats chosen header rows at the top and chosen columns at the left of every printed page of a multi-page worksheet.

Scatter (XY) Chart

Plots one numeric variable against another to reveal correlation or clustering; both axes are value axes, unlike line charts where the category axis is not numeric.

Secondary Axis

An additional value axis used in combo charts so series with very different scales, such as units and percentages, can be plotted legibly together.

Sparklines

Miniature Line, Column, or Win/Loss charts drawn inside a single cell that summarize a row or column of data without occupying chart space.

Select Data Source

A chart dialog for editing series names, series values, and category labels, and for switching whether rows or columns are interpreted as series.

AutoFilter

Toggled with Ctrl+Shift+L, it adds drop-down buttons to headers for filtering by value, text condition, date period, color, or number; filtered rows are hidden, not deleted.

Advanced Filter Criteria Range

A separate range of header and condition cells; conditions on the same row combine with AND, while conditions on separate rows combine with OR.

Subtotal Command

Inserts grouped summary rows using functions such as SUM or AVERAGE and creates outline levels; the data must first be sorted by the grouping column.

Remove Duplicates

Deletes rows sharing identical values in the selected columns and reports the count removed; the action permanently alters data and cannot be reversed after saving.

PivotTable Values Area Default

Dropping a numeric field into Values summarizes it with Sum, while a text field defaults to Count; the aggregation can be changed in Value Field Settings.

Slicer

A floating visual filter button panel for PivotTables and Tables; Report Connections lets one slicer drive several PivotTables that share the same source field.

GETPIVOTDATA

A function that extracts a value from a PivotTable by naming a data field and item pairs; typing an equals sign and clicking a pivot cell inserts it automatically.

Goal Seek

A What-If Analysis tool that adjusts one input cell until a dependent formula reaches a specified target value, solving a single-variable equation.

Co-authoring

Simultaneous editing by several people of a workbook stored on OneDrive or SharePoint; AutoSave must be on and the file must be in a cloud location.

Mark as Final

Sets a workbook to read-only and displays a warning to anyone opening it, discouraging edits; the setting can be turned off by any user.

Compatibility Checker

A File > Info > Check for Issues command that lists features unsupported by older formats such as .xls before the workbook is saved in that format.

Page Break Preview

A View tab mode that shows page boundaries as blue lines, which can be dragged to reposition breaks; Reset All Page Breaks removes manual breaks.