NP Excel 2016
Module 08
Quick Check Answers
Session 8.1
1. The table style is applied to all rows in the new column; the range of the Excel table
3. In cell Q7, enter =IF(Q5*Q6>10000,Q5*Q6,10000).
5. In cell Y5, enter =IF(AND(X5>0,R5>R1),“Outstanding”,“”).
7. Ignore; all tests are False so the OR function returns FALSE.
Session 8.2
1. A nested IF function is when one IF function is included inside another IF function.
3. An exact match compares the lookup value to the first column in the lookup table. They
must be equal for a value to be returned from the lookup table. An approximate match also
4. the VLOOKUP function
5.
7. =IF(W25=0,“Dividing by zero”,W5/W25)
8. HLOOKUP
Session 8.3
1. No. Duplicate last names do not necessarily mean that the data is a duplicate; it could be
that two or more people have the same last name.
box
3. It counts the number of females in the Employee table.
5. It sums the annual salaries of all full-time employees.
7. COUNTIF