Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.1 Create Worksheets and Workbooks: Add Worksheets to Existing Workbooks

graphic2
pic1

graphcic1
graphci3

The HLookup Function

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.

 

1. Try it: Create the Customers Sheet

Click the plus sign (+) at the bottom by the sheet tabs to add a new blank spreadsheet.

Double-click the tab.

Rename this spreadsheet: Customers.

 

Add the following labels:

Select Cell A1 and type: Category.

Select Cell B1 and type: Total.

If these are labels (and they are) they need to be formatted BOLD.

 

Add some data:

Select Cell A2 and type: Corporate

Select Cell A3 and type: Educational

Select Cell A4 and type: Government

Select Cell A5 and type: Private

Keep going...