Like this study set? Create a free account to save it.

Sign up for an account

Already have a Quizlet account? .

Create an account

spreadsheet functions

predefined formulas that perform calculations by using specific values, called arguments, in a specfic order

cell reference

indicates a cell's location and provides instructions for how cell data is copied or used in calculations

relative cell reference

cell value changes as the formula is copied

absolute cell reference

cell value remains static when copied to other locations

mixed cell reference

indicates the combination of an absolute cell and a relative cell, such as $A4


control the order of operations

conditions or criteria

tell the function how to calculate the results and what data to use


adds the range of cells

Average (AVG)

determines the average of the range of cells

Maximum (MAX)

finds the highest number in the range of cells

Minimum (MIN)

finds the lowest number in the range of cells

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions and try again


Reload the page to try again!


Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

Voice Recording