Unit#3 | Formulas & Functions in Spreadsheets

equal sign ( = )

All formulas begin with...?

colon ( : )

The two cell references used for a range are separated by...?

spreadsheet

a computer program that is used for storing, organizing and manipulating data

range

a group or block of cells that has been selected

function

a pre-defined formula that performs a calculation

cell

a single box at the intersection point of a vertical column and a horizontal row

worksheet

a single page or sheet in a workbook

plus sign ( + )

add

workbook

an individual spreadsheet file

COUNT function

counts the number of cells that have a numerical value in a range of cells = COUNT (A1:A10)

forward slash ( / )

divide

MAX function

finds the highest numerical value in a range of cells = MAX(D2:D9)

MIN function

finds the lowest numerical value in a range of cells =MIN(D2:D9)

AVERAGE function

finds the mean of all the cells in a range of cells =AVERAGE(B1:B4)

SUM function

finds the total of all the cells in a range of cells =SUM(A3:A7)

Error Value

indicates when a formula in a spreadsheet contains an error

operator

mathematical symbols used for calculating data

asterisk ( * )

multiply

minus sign ( - )

subtract

data

text or numbers stored in cells

row

the horizontal series of cells

cell reference

the location of a cell

argument

the part of the function enclosed in round brackets (parentheses) following the function's name

column

the vertical series of cells

formula

used to perform calculations on values entered and stored in the spreadsheet