1. You can ---------------------------------------- ( DONT HAVE TO ANSWER ALL I need help thank you ! )

   	A.	Change the row height
   	B.	Hide a row
   	C.	Insert and delete a row
   	D.	All of the above

10 points

QUESTION 3

1. You can

   	A.	Insert a column
   	B.	Hide a column
   	C.	Both A and B are correct
   	D.	None of the above

10 points

QUESTION 4

1. Hardcoding a variable means

   	A.	Including the value of a variable in a formula
   	B.	Using an absolute reference in a formula
   	C.	Typing a cell reference in a formula rather than pointing to it
   	D.	None of the above

10 points

QUESTION 5

1. Why would you use an absolute cell reference in a formula?

   	A.	Preference, there is no real difference
   	B.	Using the absolute cell reference requires you to type each formula separately, thereby ensuring no errors
   	C.	Using an absolute reference allows you to fill a formula down while still pointing to the absolute reference
   	D.	Using an absolute reference makes the formula easier to reverse engineer

10 points

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