Exam 77-420 Microsoft Excel 2013
1. Create and Manage Worksheets and Workbooks
1.3 Format Worksheets and Workbooks: Insert and Delete Columns and Rows

Create the Reference Cells

Before You Begin: Go to the Pigs sheet. Please select Row 1 and Insert four more Rows. This will give us room to work.


1. Try This: Enter the Labels

In Cell A1 type: Price

In Cell A2 type: Start

In Cell A3 type: Increment

If these are Labels (yep, they are) then select Cells A1:A3 and format the Font Bold.
Go to Home->Font->Bold.


OK, Now Try This: Enter the Data
n Cell B1 type: 3.25.

Format Cell B1 for Accounting.

Keep going, please...


Memo to Self: This lesson continues with the

Legs Eggs and Pigs.xlsx spreadsheet

Home->Cells ->Insert