ICDL Spreadsheets (ICDL) flashcards
ICDL Spreadsheets · Build recall with a focused review session.
33 cards. Read the term and the definition here. The deck at the top of this page is optional.
- Workbook vs worksheet
- A workbook is the entire saved file; a worksheet is one tab or page inside it. A single workbook can contain many worksheets.
- Absolute cell reference
- A reference written with dollar signs, such as $A$1, that stays fixed on the same cell when the formula is copied to other cells.
- Relative cell reference
- A reference like A1 without dollar signs that adjusts its row and column automatically when the formula is copied or filled elsewhere.
- Name Box
- The box left of the formula bar that displays the active cell address and accepts a typed address or range to jump directly to it.
- AutoFill handle
- The small square at a selection's lower-right corner; dragging it copies content or extends a recognized series such as months or numbers.
- Range notation
- Two cell addresses separated by a colon, such as A1:C10, meaning all cells in the rectangular block between those corners, inclusive.
- Paste Special
- A paste option that inserts only chosen attributes of copied cells, such as values, formats, or formulas, instead of everything.
- Merge and Center
- Combines selected cells into one larger cell and centers its content; only the upper-left value is retained after merging.
- Wrap Text
- A cell setting that displays long text across multiple lines inside the same cell, increasing row height instead of column width.
- #### in a cell
- A display indicating the column is too narrow for the numeric or date value; widening the column reveals the actual stored number.
- Sheet tab renaming
- Double-clicking a worksheet tab lets you type a new name; names are limited to 31 characters and cannot contain certain symbols.
- 3D reference
- A formula referencing the same cell across multiple sheets, such as =SUM(Jan:Mar!B2), which totals B2 on every sheet from Jan to Mar.
- Cross-sheet reference
- A formula pointing to a cell on another worksheet, written as Sheet2!A1, with sheet names containing spaces enclosed in single quotes.
- Grouping worksheets
- Selecting multiple sheet tabs with Ctrl so that edits and formatting entered on one sheet apply to all grouped sheets at once.
- Hiding a worksheet
- Removes a sheet's tab from view while keeping its data and any formulas that reference it fully intact and functional.
- Order of operations
- Excel evaluates exponents first, then multiplication and division, then addition and subtraction; parentheses override this default precedence.
- AVERAGE function
- Returns the arithmetic mean of numeric cells in a range, ignoring blank cells and text entries in that range.
- COUNT vs COUNTA
- COUNT tallies cells containing numbers only; COUNTA tallies all non-empty cells, including text and logical values.
- IF function
- Tests a condition and returns one value if true and another if false, written as =IF(condition, value_if_true, value_if_false).
- #DIV/0! error
- Appears when a formula divides by zero or by an empty cell; the divisor must contain a nonzero numeric value.
- #REF! error
- Appears when a formula refers to a cell or range that no longer exists, often after deleting rows, columns, or referenced sheets.
- Percentage number format
- Displays a stored decimal as a percentage by multiplying the display by 100 and appending a percent sign; the stored value is unchanged.
- Format Painter
- A tool that copies all formatting from a selected cell and applies it to other cells; double-click to apply to several targets.
- Conditional formatting
- Automatically applies colors, icons, or data bars to cells whose values meet rules you define, updating as values change.
- Date stored as text
- A date entered as text aligns left and cannot be used in date arithmetic until converted to a real date serial number.
- Pie chart use case
- Shows each category's share of a total and plots only one data series; unsuitable for comparing multiple series or showing trends.
- Line chart use case
- Best for displaying a trend of values over a continuous period, such as monthly sales across a year.
- Chart data source
- The worksheet range a chart is linked to; editing those cells updates the chart automatically because it is not a static image.
- Switch Row/Column
- A chart command that swaps which data dimension is plotted as series versus category axis labels, changing the chart's orientation.
- Print Titles
- A page setup option that repeats specified rows or columns at the top or left of every printed page of a worksheet.
- Print Area
- A defined cell range that is the only part of the worksheet sent to the printer; clearing it restores printing of the used range.
- Fit to Page scaling
- A print setting that shrinks output to fit a chosen number of pages wide and tall without changing any stored cell values.
- Landscape orientation
- A page layout that prints wider than tall, useful when a worksheet has many columns that would otherwise split across pages.