We will
create a new Bonus spreadsheet that will look up the sales data from
the Sales Subtotal by Rep spreadsheet. 2.
Try it: Create a Bonus Sheet Go to a new
blank spreadsheet.
Double-click the tab. Rename the
spreadsheet: Bonus. Add the
following labels: Select
Cell A1 and type: Sales Rep. Select
Cell B1 and type: Total. If these
are labels (and they are) they need to be formatted BOLD. Select Row
1. Go to Home->Font->Bold. Select
Cell A2 and type: Alex Select
Cell A3 and type: Connie Select
Cell A4 and type: Elizabeth Select
Cell A5 and type: Nikki Keep
going...
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
|
|
| |
