Excel and Spreadsheet Terminology

Front

Arithmetic Operators

Back

Basic math operations like addition (+), subtraction(-), multiplication (*), and division(/).

Tags

CCSS.7.NS.A.1D

Front

AutoSum

Back

A feature in Excel that automatically performs a calculation (like addition) on a group of numbers.

Tags

CCSS.6.SP.B.5C

Front

Formula

Back

A set of calculations that are applied to values in a spreadsheet. Formulas range from simple mathematical operations to complex statistical calculations.

Front

Formula Bar

Back

A workbook tool that displays the contents of the active cell; it can be used to enter new values and formulas.

Front

Function

Back

A computational procedure that performs a specific operation.

Tags

CCSS.8.F.A.1

CCSS.HSF.IF.A.1

Front

Function Arguments

Back

The values inside the parentheses of a function.

Tags

CCSS.8.F.A.1

CCSS.HSF.IF.A.1

Front

Absolute Reference

Back

A method of identifying cells in a spreadsheet formula based on their locations, rather than the location of the formula.

Front

AVERAGEIF

Back

A function that calculates the average value of a group of numbers based on a given criteria.

Tags

CCSS.6.SP.B.5C

Front

COUNTIF

Back

A function that counts the number of cells within a specified range that meet a given criteria.

Front

IF

Back

A function that evaluates a condition as TRUE or FALSE, then returns a unique result for each outcome.

Tags

CCSS.HSS.MD.B.6

CCSS.HSS.MD.B.7