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