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.
- Workbook versus worksheet
- A workbook is the entire spreadsheet file, whereas a worksheet is one grid or page within that file; a single workbook can contain many worksheets.
- Quick Access Toolbar
- A small row of icons that stays visible above or below the ribbon, holding commands such as Save, Undo and Redo regardless of which ribbon tab is active.
- Saving as CSV
- CSV stores only cell values separated by commas, keeping no formulas, formatting or additional worksheets; it is used to move data between different programs.
- Find and Replace shortcut
- Ctrl+H opens the Find and Replace dialog, which locates text or values in a worksheet and substitutes new content for them, either one match or all matches at once.
- Absolute cell reference
- A reference written with dollar signs, such as $A$1, which continues to point at the same cell when the formula is copied to other cells.
- Fill handle
- The small square at the bottom-right corner of a selection; dragging it copies the contents or continues a series such as months, weekdays or consecutive numbers.
- Delete versus Clear Contents
- Delete removes the selected cells and shifts the remaining cells to fill the gap, whereas Clear Contents empties the cells but leaves them in their original position.
- Confirming a cell entry
- Type the value and confirm with Enter, Tab or an arrow key; press Esc to cancel the entry, or F2 to edit the existing content in place.
- Default cell alignment
- Text is left-aligned and numbers, dates and times are right-aligned by default, which helps identify numbers that have been accidentally stored as text.
- Renaming a worksheet
- Double-click the sheet tab, or right-click it and choose Rename; a sheet name may be up to 31 characters and cannot contain \ / ? * [ ] :
- Copying a worksheet
- Hold Ctrl while dragging the sheet tab, or use Move or Copy with Create a copy ticked, to duplicate a sheet together with all its data and formatting.
- Freeze Panes
- A View tab command that locks chosen rows or columns in place so that headings stay visible while scrolling through the rest of a large worksheet.
- Grouping worksheets
- Selecting several sheet tabs with Ctrl or Shift groups them, so entries, edits and formatting apply to every grouped sheet at once; click one tab to ungroup.
- Order of operations in formulas
- Spreadsheet formulas calculate exponentiation first, then multiplication and division, then addition and subtraction; brackets override this order and are evaluated before anything else.
- COUNT versus COUNTA
- COUNT returns the number of cells containing numbers, while COUNTA returns the number of non-empty cells, including those holding text, dates or logical values.
- IF function
- IF tests a condition and returns one value when the condition is true and another when it is false, for example =IF(A2>=50,"Pass","Fail").
- SUMIF function
- SUMIF adds the values in a range that meet a single condition, written as SUMIF(range, criteria, sum_range), where the sum_range argument is optional.
- #REF! error
- This error appears when a formula refers to a cell that no longer exists, typically after the rows, columns or sheets used by the formula have been deleted.
- ROUND function
- ROUND(number, digits) rounds a value to a set number of decimal places; ROUNDUP always rounds away from zero and ROUNDDOWN always rounds toward zero.
- Format Cells dialog
- Opened with Ctrl+1, it provides tabs for Number, Alignment, Font, Border, Fill and Protection, offering settings that are not available directly on the ribbon.
- Format Painter
- A Home tab button that copies formatting from a selected cell or range and applies it elsewhere; double-click it to paste the format into several separate places.
- Conditional formatting
- Formatting that changes automatically according to a cell's value or a defined rule, such as colouring every score below 50 in red so exceptions stand out.
- Merging cells
- Combining two or more selected cells into one larger cell; only the value in the upper-left cell is kept and the contents of the other cells are discarded.
- Pie chart suitability
- A pie chart shows the proportions of a single data series, so all values should be parts of one whole and none of them should be negative.
- Chart legend
- The key on a chart that identifies which colour or pattern belongs to each data series; it can be repositioned or removed using the chart element options.
- Switch Row/Column
- A chart command that swaps which data is plotted as series and which is plotted as categories, used when a chart appears transposed or reversed.
- Line chart purpose
- A line chart plots values joined by lines to show a trend or a change over time, such as monthly sales figures across a full year.
- Embedded chart versus chart sheet
- An embedded chart sits as an object on a worksheet beside its data, while a chart sheet occupies its own separate tab in the workbook.
- Print Titles
- A Page Setup option that repeats chosen rows at the top, or chosen columns at the left, of every printed page of a long worksheet.
- Page Break Preview
- A View tab mode that shows where pages will break when printed and lets you drag the blue lines to change the printed layout.
- Headers and footers
- Text printed at the top or bottom of every page, often holding page numbers, the date, the file name or a title, set through the Insert tab or Page Setup.
- Fit to one page wide
- A scaling option in Page Setup that shrinks the printout so that all columns fit across a single page width, whatever the length of the sheet.