Flashcards › Technology & Coding › Computer Skills

Spreadsheet Formulas and Terms

Cells, formulas and common functions in Excel and Google Sheets.

63 cardsGrades 6–8, Grades 9–12, College, Adult#spreadsheet#Excel#Google Sheets#formulas

0 of 63 known
63 cards
  • CellTerm
    One box in a spreadsheet where a row and column meet
  • Cell referenceTerm
    The cell's address, like B3
  • RowTerm
    A horizontal line of cells, labeled with numbers
  • ColumnTerm
    A vertical line of cells, labeled with letters
  • RangeTerm
    A group of cells, like A1:A10
  • Worksheet (sheet)Term
    A single page of cells in a workbook
  • WorkbookTerm
    A file holding one or more sheets
  • FormulaTerm
    A calculation that starts with an equals sign
  • FunctionTerm
    A built-in formula like SUM
  • =A1+B1Term
    Adds two cells
  • =A1*B1Term
    Multiplies two cells
  • =SUM(A1:A10)Term
    Adds a range
  • =AVERAGE(A1:A10)Term
    Finds the mean of a range
  • =MIN(A1:A10)Term
    Finds the smallest value
  • =MAX(A1:A10)Term
    Finds the largest value
  • =COUNT(A1:A10)Term
    Counts cells with numbers
  • =COUNTA(A1:A10)Term
    Counts non-empty cells
  • =ROUND(A1,2)Term
    Rounds to two decimal places
  • =IF(A1>10,'Yes','No')Term
    Returns one value if true and another if false
  • =AND() and =OR()Term
    Test several conditions
  • =COUNTIF(range,criteria)Term
    Counts cells that meet a rule
  • =SUMIF(range,criteria,sum_range)Term
    Adds cells that meet a rule
  • =VLOOKUP()Term
    Looks up a value in the first column of a table
  • =XLOOKUP()Term
    A modern lookup function
  • =INDEX() and =MATCH()Term
    A flexible way to look things up
  • =CONCATENATE() or =A1&B1Term
    Joins text
  • =LEFT(A1,3)Term
    Takes the first 3 characters
  • =LEN(A1)Term
    Counts characters in a cell
  • =UPPER(A1)Term
    Makes text uppercase
  • =TODAY()Term
    Shows today's date
  • =NOW()Term
    Shows the date and time
  • Absolute referenceTerm
    Locks a cell with dollar signs, like $A$1
  • Relative referenceTerm
    A reference that changes when copied
  • Fill handleTerm
    The small square in the corner of a cell you drag to copy
  • AutoSumTerm
    A button that adds a column or row quickly
  • SortTerm
    Arrange rows in order
  • FilterTerm
    Show only rows that meet a condition
  • Conditional formattingTerm
    Changing cell colors based on values
  • Pivot tableTerm
    A summary table made from many rows of data
  • ChartTerm
    A visual graph of data
  • Bar chartTerm
    Compares categories with bars
  • Line chartTerm
    Shows change over time
  • Pie chartTerm
    Shows parts of a whole
  • Header rowTerm
    The top row naming each column
  • Freeze panesTerm
    Keeps the header row visible while scrolling
  • Merge cellsTerm
    Combine cells into one
  • Data validationTerm
    Limits what can be entered in a cell
  • #DIV/0!Term
    Error from dividing by zero
  • #REF!Term
    Error from a broken cell reference
  • #NAME?Term
    Error from a misspelled function name
  • #VALUE!Term
    Error from the wrong type of value
  • CSVTerm
    A simple text file for spreadsheet data
  • Google SheetsTerm
    A free online spreadsheet tool
  • Microsoft ExcelTerm
    A popular spreadsheet program first released in 1985
  • VisiCalcTerm
    The first popular spreadsheet program, from 1979
  • MeanTerm
    The average, found by adding and dividing
  • MedianTerm
    The middle value when ordered
  • ModeTerm
    The most common value
  • Order of operationsTerm
    Parentheses, exponents, multiplication and division, then addition and subtraction
  • Percent formulaTerm
    =A1/B1 formatted as a percent
  • Number formatTerm
    Controls how a number looks: currency, date, percent
  • TemplateTerm
    A premade spreadsheet layout
  • Named rangeTerm
    A name given to a group of cells

Download this deck

Want paper cards? Paste the plain-text download into the flashcard maker.

More Computer Skills decks