You can use the
sample spreadsheet
or enter your own data if you
wish.
Exam 77-882: Microsoft Excel 2010
Core
2. Creating Cell Data
2.1. Construct cell data
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 Go to a new
blank spreadsheet.
Double-click the tab. Rename the
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. Select
Cells A1:B1. Go to Home->Font->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... Home->Font->Bold |
|
| |
