Comma Training Page 113

Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.2 Format Cells and Ranges: Change Font and Font Styles

Create a Bonus Spreadsheet

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.