Question 1

Which of the following is not a way to bring up the Go To dialog box?

		A) Alt+F7
		B) F5
		C) Ctrl+G
		D) Name Box

10 points

Question 2

What data does Excel print by default?

		A) The selected range of data
		B) The entire dataset on the active sheet
		C) The entire workbook
		D) There is no default setting for this in Excel.

10 points

Question 3

What is the default data table style?

		A) Normal
		B) Medium 1
		C) Medium 2
		D) None

10 points

Question 4

Which table style option shows the field names when it is checked?

		A) Header Row
		B) Total Row
		C) First Column
		D) Banded Columns

10 points

Question 5

When would you not need to use a fully qualified structured reference?

		A) When referring to a cell outside the table
		B) When referring to a cell on a different worksheet
		C) When referring to a cell on a different workbook
		D) When referring to a cell within the table

10 points

Question 6

What would be the result if you sorted the following dates in ascending order: December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959?

		A) December 25, 2000; December 26, 1959; January 1, 2015; January 16, 1959
		B) January 1, 2015; January 16, 1959, December 25, 2000; December 26, 1959
		C) January 16, 1957; December 26, 1959; December 25, 2000; January 1, 2015
		D) December 25, 2000; January 1, 2015; January 16, 1957; December 26, 1959

10 points

Question 7

Which one of the following filter options is not found on the number filter submenu?

		A) Greater Than...
		B) Between...
		C) Below Average
		D) Bottom 10...

10 points

Question 8

Where does Excel display the Total row in a table?

		A) At the top of the table
		B) After each subtotal in the table
		C) Two rows below the last row in the table
		D) Below the last row in the table

10 points

Question 9

Which conditional formatting option is not found in the Quick Analysis Gallery?

		A) Text Contains
		B) Duplicate Values
		C) Unique Values
		D) Undo Format

10 points

Question 10

If you use the Icon sets conditional formatting, you are limited to how many categories?

		A) One, two, or three
		B) Two, three, or four
		C) Three, four, or five
		D) Four, five, or six