12 4.6 Chapter Assessment
The following are sample questions to test whether you know, understand, and are able to apply your learning from this chapter.
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
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)
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 average for Yusuf Mansur?
a) 48
b) 44
c) 26
d) 47
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)
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.
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
Attribution
Questions by Emese Felvégi based on the chapter practice problems. Edited by Lilliana E. Olmos & Marcella Olmos. CC BY-NC-SA 3.0.