QUESTION 6

1. When formatting a cell as an absolute reference or address, you

   	A.	Type a # in front of the column number and row letter
   	B.	Highlight the reference in the formula and Press F4
   	C.	Type a $ in front of the row letter
   	D.	Type a & in front of the column letter and in front of the row number

10 points

QUESTION 7

1. Conditional formatting is powerful because

   	A.	It enables rapid visual analysis of a data set
   	B.	There are so many options
   	C.	It makes the spreadsheet more attractive
   	D.	It only takes a few minutes to set up

10 points

QUESTION 8

1. What is an easy way to transpose a long list of numbers?

   	A.	Copy & Paste Special
   	B.	Just move the cells
   	C.	There is no easy way to do that
   	D.	Copy & Paste

10 points

QUESTION 9

1. How are the Currency and Accounting number formats different?

   	A.	They are not different
   	B.	The currency symbol is flush to the number in the currency format and flush left in the accounting format
   	C.	A zero value is represented as a dash in the accounting format and a 0 in the currency format
   	D.	Both B and C are correct

10 points

QUESTION 10

1. When formatting a cell as a fraction, what is the maximum number of digits that can be displayed?

   	A.	One
   	B.	Two
   	C.	Three
   	D.	Four