Lesson 06 - Working with Functions


1	What would be the result of =SUM(A1,250), if A1=25?
	A)	275
	B)	6250
	C)	225
	D)	250



2	Which function removes the decimal portion of a value?
	A)	CUTOFF
	B)	ROUNDUP
	C)	TRUNC
	D)	TRIM



3	What category in the Format Cells dialog box is used to define a unique format for a date?
	A)	Custom
	B)	Date
	C)	Special
	D)	Text



4	Why might you want to group worksheets?
	A)	To view each one separately
	B)	To format them all the same way
	C)	To add labels particular to each sheet
	D)	To apply a group template



5	What symbols might be shown by an icon set conditional formatting rule?
	A)	Shaded bars
	B)	Gradient filled cells
	C)	Various arrows
	D)	I-beam pointers



6	What appears in the title bar when worksheets are grouped?
	A)	[Grouped]
	B)	[Band]
	C)	[Set]
	D)	[Group]



7	Which function might display different results on three different computers?
	A)	TODAY()
	B)	SUM
	C)	SUMIF
	D)	TRUNC



8	What does the AVERAGE function calculate for a range of cells?
	A)	Mean
	B)	Sum
	C)	Median
	D)	Mode



9	Which function tallies all cells in a range whether the cell has a value or a label?
	A)	COUNT
	B)	SUMA
	C)	COUNTA
	D)	TOTAL



10	What statement describes this function: =SUMIF(D7:D14, ">1")?
	A)	It adds the values in cells D7:D14 if the value is greater than 1.
	B)	It adds all the negative values in cells D7:D14.
	C)	If the value in a cell is greater than 1, it is added to the other values in column D.
	D)	If the value in a cell is greater than 1, the range D7:D14 is placed on a summary sheet.

Notes		(What is this?)

Add a note
1.	(optional) Enter a note here:
2.	(optional) Select some text on the page (or do this before you open the "Notes" drawer).
3.	Highlighter Color:
4.

Home > Excel > Lesson 06 Quiz