Spreadsheets

Question	Answer
What does the sum function do?	Returns the total of cells you put in the brackets.
What symbol does every function begin with?	=
Name a use of conditional formatting...	To check whether a cell is equal to, more than or less than another value or cell.
The button that automatically turns numbers into currency looks like...	Image: excel07currency (image/jpg)
The autosum button looks like...	Image: slide0015_image048 (image/jpg)
The letter in the cell reference refers to the row or column?	Column
The number in the cell reference refers to the row or column?	Row
What does the autosum button do?	Automatically selects the nearest column or row of data and adds it up.
What symbol is used for multiplication?	*
What symbol is used for division?	/
What symbol is used for absolute cell referencing?	$
What is absolute cell referencing?	If you copy formulas along a row or down a column, the cell references will not be adjusted.
How would we find the average of cells C4 and A6 in Excel?	=AVERAGE(C4, A6)
What button is used to filter data?	Sort and Filter
What button can insert functions?	fX button.

Resource summary

	Created by tschaffner almost 11 years ago