Multiple Choice Quiz

Click on the correct response for each question below.

1		To see how closely a linear line approximates the existing data, you would use which function?
			A)	FORECAST
			B)	GROWTH
			C)	RSQ
			D)	TREND
2		The TREND function can be accessed by:
			A)	Typing it directly in the cell
			B)	Using the Paste Function () button
			C)	Using the Fill Handle
			D)	All of the above
3		Which of the following is not a regression type available in Excel?
			A)	Moving Average
			B)	Linear
			C)	Infantile
			D)	Exponential
4		Which of the following is the correct syntax for an array formula?
			A)	{=TABLE(,C12)}
			B)	=TABLE(,C12)
			C)	[=TABLE(,C12)]
			D)	None of the above
5		To select multiple worksheets, hold down the ________ while clicking the sheet tab.
			A)	SHIFT key
			B)	ALT key
			C)	CTRL key
			D)	F1 key