Short, plain-language definitions for terms you’ll run into in the menus of these apps — the kind of thing you half-understand until you actually look it up once.
Word
Style
A saved set of formatting (font, size, color, spacing) applied to text with one click. Changing a style updates every piece of text using it at once, instead of reformatting each one by hand.
Section break
A marker that lets one part of a document have different page settings — margins, orientation, headers — than another part, without splitting it into separate files.
Track Changes
A review mode that marks every insertion and deletion instead of silently editing the text, so a document can be reviewed and either accepted or rejected line by line.
Navigation Pane
A sidebar (Ctrl+F) that lists every heading in the document, letting you jump between sections or reorder them by dragging — only works if headings use actual Heading styles.
SmartArt
A designed diagram (process, hierarchy, cycle) that Word can generate automatically from a plain bulleted list, keeping the original wording.
Excel
Cell reference
The address of a cell, like B7, used inside formulas to point at a value instead of typing the number directly.
Formula vs. function
A formula is anything starting with =. A function is a named formula that does something specific, like SUM() or VLOOKUP() — every function is used inside a formula, but not every formula uses a function.
PivotTable
A tool that summarizes a large table — totals, averages, counts — by dragging column headers into rows, columns, and values, without writing a single formula.
Absolute reference
A cell reference locked with dollar signs (like $A$1) so it doesn’t shift when the formula is copied to other cells — toggled with the F4 key.
Named range
A plain-English name (like SalesQ1) assigned to a cell or range, so formulas can reference =SUM(SalesQ1) instead of =SUM(B2:B40).
Conditional formatting
Formatting that changes automatically based on a cell’s value — color scales, data bars, or icons that update as the underlying numbers change.
Flash Fill
A feature that detects a pattern from one or two examples you type and fills in the rest of a column automatically, without a formula.
PowerPoint
Slide Master
The underlying template every slide is built from. Editing it once — a font, a logo position — updates every slide using that layout at the same time.
Placeholder
A predefined box on a slide layout (for a title, body text, or image) that keeps content aligned consistently — different from a text box you draw yourself.
Transition vs. animation
A transition is how PowerPoint moves between two whole slides. An animation is how one object behaves within a single slide. They’re controlled from two separate tabs and often confused.
Presenter View
A view shown only to the presenter on a second screen — notes, a timer, and the next slide — while the audience sees only the current slide, full-screen.
Morph
A transition that compares two slides (usually duplicates of each other) and automatically animates the difference between them, instead of requiring manual animation.
Canva
Brand Kit
A saved set of colors, fonts, and a logo tied to your account, so every new design can pull from the same palette instead of it being re-entered each time.
Magic Switch
A tool that resizes an entire finished design to a new format (like turning an Instagram post into a printable flyer) and automatically reflows the layout.
Element
Canva’s catch-all term for anything you place on the canvas that isn’t your own uploaded photo — shapes, icons, illustrations, grids, and frames.
Template
A pre-built design meant as a starting point — swap the text, photos, and colors rather than building the layout from a blank canvas.
Frame / Grid
A shape that holds a photo in a fixed position and proportion — dragging a new photo onto it replaces the image without disturbing the layout around it.