# 3.6 Chapter Assessment

## The following are sample questions to test whether you know, understand, and are able to apply your learning from this chapter.

1. The fastest way to highlight top 10 values in a range is by:
a) Adding a pie chart next to the data.
b) Applying conditional formatting.
c) Quickly selecting the values and changing the border colors by hand.
d) This will always be a lengthy process, especially if you have a large dataset.

2. When you see this error message, the formula refers to an empty cell or to data that is not found or not available.
a) #N/A
b) #NAME
c) #NUM
d) #REF

3. Answer the following based on your work with the Chapter 3 Gradebook Data file. The _____ is best function to return a value for “Points Possible” for “Test 1”?
a) AVERAGE
b) IF
c) MAX
d) MIN

4. Answer the following based on your work with the Chapter 3 Gradebook Data file. Who has the highest Percentage performance in the class?
a) Andrews, DeShea
b) Mansur, Yusuf
c) Taylor, Jaquoya
d) Weller, Elijah

5. Answer the following based on your work with the Chapter 3 Gradebook Data file. What is the best formula to return the highest score for Test 1?
a) =MAX(A1:E24)
b) =MAX(E5:E24)
c) =MAX(E5:E25)
d) =MAX(A1:R25)

6. Answer the following based on your work with the Chapter 3 Gradebook Data file. What is the best formula to calculate the Test 1 average for Yusuf Mansur?
a) =48/50
b) =96%
c) =E12/E25
d) =Student Name/Points Possible

7. Answer the following based on your work with the Chapter 3 Gradebook Data file. What is the Test 1 score for Yusuf Mansur?
a) 48
b) 44
c) 26
d) 47

8. Answer the following based on your work with the Chapter 3 Gradebook Data file. Which formula determines whether Test 2 scores showed improvement from Test 1 for Yusuf Mansur?
a) =IF(I12E12,”Improved”,”Did not improve”)
b) =IF(I12>E12,”Improved”,”Did not improve”)
c) =IF(I12>E12,Improved,Did not improve)
d) =IF(I12>E12,TRUE,FALSE)
9. In VLOOKUP, “table_array” is:
a) the type of matches that are available based on your lookup value.
b) the column that includes the information that we are looking up.
c) the range that contains the value you want returned by the function.
d) the sheet that contains your data.
10. Answer the following based on your work with the Chapter 3 Gradebook Data file. Which formula returns the letter grade for for Yusuf Mansur?
a) =VLOOKUP(\$O\$12,A28:B32,2,TRUE)
b) =VLOOKUP(\$P\$12,A28:B32,2,TRUE)
c) =VLOOKUP(O12,\$A\$28:\$B\$32,2,FALSE)
d) =VLOOKUP(O12,\$A\$28:\$B\$32,2,TRUE)
e) =VLOOKUP(P12,\$A\$28:\$B\$32,2,FALSE)
f) =VLOOKUP(P12,\$A\$28:\$B\$32,2,TRUE)

Solutions:  1b, 2a, 3c, 4c, 5b, 6c, 7a, 8b , 9c, 10f 