ICDL Spreadsheets (ICDL) flashcards
ICDL Spreadsheets · Build recall with a focused review session.
32 cards. Read the term and the definition here. The deck at the top of this page is optional.
- Cell reference
- A cell address formed by its column letter and row number, such as C7. It identifies one cell in a worksheet and is used in formulas and for navigation.
- Save As
- A command that stores the current workbook under a new file name, folder or file format while leaving the previously saved original unchanged on disk.
- CSV file format
- A plain-text format storing cell values separated by commas. It keeps data but loses formulas, formatting, charts and all worksheets except one.
- Name Box
- The box to the left of the formula bar that shows the address of the active cell and accepts a typed address or range name to jump straight there.
- Cell range
- A rectangular block of cells defined by two corner addresses separated by a colon, for example A1:C3. Formulas and formatting can be applied to the whole range at once.
- Fill handle
- The small square at the bottom-right corner of a selection. Dragging it copies the content or continues a recognised series such as months, weekdays or numbers.
- Paste Special
- A paste option that inserts only chosen attributes of copied cells, such as values, formulas, formats or column widths, instead of pasting everything at once.
- Non-adjacent selection
- Two or more cells or ranges that are not next to each other, selected by holding Ctrl while clicking. Any action then applies to every selected area.
- AutoFill series
- The behaviour that continues a recognised pattern when the fill handle is dragged, for example Jan, Feb, Mar or 2, 4, 6. Unrecognised entries are simply repeated.
- Worksheet tab
- The label at the bottom of the window naming a worksheet. Double-clicking it renames the sheet and right-clicking opens insert, delete, move and hide options.
- Freeze Panes
- A view command that locks the rows above and the columns to the left of the active cell so those headings stay visible while the rest of the sheet scrolls.
- Grouped worksheets
- Two or more sheets selected together with Ctrl+click or Shift+click on their tabs. Data typed or formatting applied affects every sheet in the group.
- Move or Copy sheet
- A dialog that relocates a worksheet within or between workbooks and creates a duplicate of it when the Create a copy box is ticked.
- Absolute reference
- A cell address written with dollar signs before both parts, such as $B$4, that stays fixed when the formula is copied or filled to another cell.
- IF function
- A logical function written =IF(condition, value_if_true, value_if_false). It returns one of two results depending on whether the stated condition is met or not.
- COUNT and COUNTA
- COUNT totals only the cells containing numbers, whereas COUNTA totals every non-empty cell including text. Both ignore cells that are genuinely empty.
- #DIV/0! error
- The error displayed when a formula divides by zero or by an empty cell. The fix is to correct the divisor or wrap the formula in IFERROR.
- SUMIF function
- A function that adds only the values meeting a criterion, written =SUMIF(range, criteria, sum_range). It produces conditional totals such as sales for one region.
- Operator precedence
- The order in which a formula is calculated: parentheses first, then exponentiation, then multiplication and division, then addition and subtraction, working left to right within each level.
- Percentage format
- A number format that multiplies the displayed value by 100 and adds a percent sign, so a stored value of 0.25 appears on screen as 25%.
- Merge & Center
- A command that combines the selected cells into one larger cell and centres its content. Merged cells cannot be sorted normally and break fill operations.
- Format Painter
- A tool that copies only the formatting of a selected cell, such as font, colour, borders and number format, and applies it to other cells.
- Conditional formatting
- Formatting applied automatically when a cell meets a rule, for example values above a threshold, the top ten items, a colour scale or a data bar.
- #### in a cell
- The display produced when a numeric value is too wide for its column. The stored value is unchanged; widening the column or reducing decimals reveals the number.
- Pie chart
- A chart that shows each category as a slice of one whole data series. Values should be non-negative and together represent 100 per cent of the total.
- XY scatter chart
- A chart that plots pairs of numeric values against horizontal and vertical axes to reveal the relationship or correlation between two measured variables.
- Data series
- The set of values plotted from one row or column of the source range. Each series appears in a distinct colour and is named in the chart legend.
- Switch Row/Column
- A chart command that exchanges which dimension of the source range supplies the data series and which one supplies the category labels along the axis.
- Print Area
- A defined range that is the only part of the worksheet sent to the printer. Setting it excludes every other cell from the printed output.
- Print Titles
- Rows or columns marked to repeat at the top or left of every printed page, keeping column headings visible across a table that spans several pages.
- Fit Sheet on One Page
- A scaling option that shrinks the printout until the whole print area fits onto a single sheet, regardless of the original page breaks.
- Header and footer
- Text printed in the top or bottom margin of every page. Codes such as &P for the page number and &D for the date insert changing values.