Use Named Ranges to create Lookup
tables. Use a formula to lookup
the best answer.
Complete the Practice Activity on page 141.
Review the Test Yourself questions on page 142.
This lesson introduces
the
Formulas Ribbon.
1.
Formula ->
Function Library>Lookup & Reference->VLookup,
page 115
2.
Formula ->
Function Library>Lookup & Reference->HLookup,
page 125
3.
Formula
->Function Library ->Logical ->IF, page 131
4.
Formula
->Function Library ->Logical ->AND,
page 133
5.
Formula
->Function Library ->Logical ->OR,
page 135
6.
Formula
->Function Library ->Logical ->NOT,
page 136
7.
Formula
->Function Library ->Logical ->IFERROR,
page 137 |
|
|
|
