If you are stuck on a problem in Excel (other than this exam), what should you do?

		Give up
		Search the internet
		Use old spreadsheets as reference
		Ask a friend
		B, C and D

What formula should I use if I want to find the minimum monthly payment on a loan?

		PAYMENT
		PMT
		NPER
		RATE

Which of the following functions allows you to calculate one or more parameters of a regression equation?

		INTERCEPT
		SLOPE
		LINEST
		All of the above
		None of the above

What is the formula to find the average of cells A1, B1, B2, B3, B4 and B5?

		=average(A1,B1:B5)
		=avg(A1,B1:B5)
		=average(A1:B1:B2:B3:B4:B5)
		=avg(A1, B1, B2, B3, B4, B5)

Imagine you have the following table: Values Characters 1 - 1 2 - 1 B 0 4 1 D 5 2 E 6 2 F 7 5 G If I do a custom sort like shown below, what will be the character in the 2nd row? Sort 1 Add Level X Delete Level Copy Level Options... My data has headers Sort On Order Column Sort by Values Then by Characters Values Smallest to Largest Z to A Values OK Cancel OD