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

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...