Flashcards › Math & Programming
Math & Programming
Free Excel Shortcuts & Functions Flashcards
Excel fluency is a career skill measured in keystrokes — and a dozen functions cover 90% of office work. These cards drill the shortcuts and formulas that make spreadsheets fast.
Study these 10 starter cards
QUESTION
Tap the card to reveal the answer
QWhat does VLOOKUP do?
AFinds a value in the first column of a range and returns a value from another column in that row
QWhat is the modern replacement for VLOOKUP?
AXLOOKUP — searches any direction, safer defaults
QWhat does SUMIF do?
ASums values that meet a condition
QWhat does COUNTA count?
ANon-empty cells
QWindows shortcut to sum a column instantly?
AAlt + = (AutoSum)
QWhat does $A$1 mean in a formula?
AAbsolute reference — it won't shift when the formula is copied
QWhat does IFERROR do?
AReturns a fallback value when a formula errors
QShortcut to jump to the edge of a data region?
ACtrl + arrow key (add Shift to select)
QWhat does CONCAT (or &) do?
AJoins text values together
QWhat is a PivotTable for?
ASummarizing large data by categories — drag-and-drop grouping and totals
Turn these into lasting memory
Reading answers is recognition — remembering them next month takes spaced repetition. Build your own excel shortcuts & functions deck and we'll schedule every review at the right moment.
Create your free deck →How to study excel shortcuts & functions with flashcards
- One fact per card. After each recall, air-type the shortcut — finger memory is the actual goal, and it needs the motion.
- Rate honestly. After each card, choose Again, Hard, Good, or Easy — the spaced repetition algorithm uses your answer to decide when the card returns, right before you'd forget it.
- A few minutes daily beats marathons. Ten new cards a day is roughly 3,650 a year, retained. Deep dives: Flashcards for programmers · Interleaving: mix topics, learn more · How to make flashcards that actually work.
Related flashcard topics
Your first deck is free forever
No ads, no credit card — import from Anki or Quizlet, or start from these cards.
Start studying free →