Question 2: All mixed cell references contain a dollar sign before the column letter in the cell reference.

1. True
2. False

Question 3: The formula =5+$B$2 is in cell B3. What would be the result in cell B4 if this formula is copied to cell B4?

1. =5+$B$3
2. =5+$C$2
3. =5+$B$2
4. =5+$C$3

Question 4: Which of these would not enhance worksheet readability?

1. Using conditional formatting to highlight all data
2. Aligning data such that tables, lists, and charts begin in the same column
3. Using borders to distinguish between different data sets
4. Separating different data sets with blank rows and columns

Question 5: The formula =D$4+12 is in cell E8. What would be the result in cell F8 if this formula is copied to cell F8?

1. =E$4+12
2. =D$5+12
3. =E$5+12
4. =C$3+12

Question 6: The ROUND function can round digits on either side of the decimal point.

1. True
2. False