|
Excel: Work Smarter
You can use
the
sample spreadsheet
or enter your own data if you wish.
The previous example demonstrated the VLookup
function. "V" is for vertical. The VLookup finds the answers in the
columns. The HLookup function searches for the answers in the
rows.
Try It: Create the Reference
Open the Rainfall 2007 spreadsheet.
Insert a blank Spreadsheet.
Add the Labels as shown:
A1: Rainfall
A2: Conditions
Add the data as shown, too.
Select the Range: A1 through F2.
Name the Range: Conditions.
This Named Range will be the rows that you use
in the HLookup sample.
Keep going, please... Formulas -> Insert
-> Insert Sheet |
|||
|
| |||
Microsoft Excel 2007 Exam 77-602 Topic: 1. Creating and Manipulating Data
1.5. Manage worksheets 1.5.5. Insert and delete worksheets