Google Sheets

formulas

a series of data put together to perform calculations

SUM

adds all the numbers in a range to provide a total

AVERAGE

adds all the numbers in a range, & then divides the total by the total number of values

descending

begin a list with a Z or the highest number

ascending

begin a list with an A or a 1

cells

boxes created where the columns and rows meet

column headers

cells containing text that informs what data is contained in the rest of the cells in that column

row headers

cells containing text that informs what data is contained in the rest of the cells in that row

merge

combine two or more cells within a single rectangular area into a merged cell

pattern

content that repeats in a consistent way

auto-fill

copy data to adjacent cells

COUNT

counts the total number of values in a range

rows

horizontal spaces running through the table; labeled 123

spreadsheet

layout of information arranged in rows & columns in a table

sort

rearrange the order of a range of cells or the rows based on ABC or 123 order

MAX

return the maximum value in a range

MIN

returns the minimum value in a range

range

selected set of data in a table; two cell names separated by a colon

freeze

stops the topmost row(s) or leftmost column(s) from moving as the user scrolls through the document

conditional formatting

the formatting characteristics of a data set changes when user-specified conditions are met

columns

vertical spaces running through the table; labeled ABC