Comma Training Page 59

Exam 77-420 Microsoft Excel 2013
2. Create Cells and Ranges
2.1 Insert Data In Cells and Ranges: Copy and Paste Data (Paste Special)

Paste Special: Values

7. Try it: Paste the Sample Data

Go to the Eggs spreadsheet.
Select Row 2 through Row 24.
(Do not include the Total in Row 25.)
Go to Home->Clipboard->Copy.
Go to the new spreadsheet, Sheet 2.
Select Cell A25. Go to Home->Clipboard->Paste-> Paste Special->Values and number formats.

Go to the Legs spreadsheet.
Select Row 2 through Row 24.
Go to Home->Clipboard->Copy.
Go to the new spreadsheet, Sheet 2.
Select Cell A48. Go to Home->Clipboard->Paste-> Paste Special->Values and number formats.

Try This, Too: Rename the spreadsheet

Double-click the tab for this spreadsheet. Type: Original Data for TEXT Formulas.

8. Try This: Save the Spreadsheet
Go to File->Save.
Go to your Documents folder, if you wish.
Type the Name: Counting Chickens 2013.
Click on SAVE.

Home->Clipboard-> Paste ->Paste Special ->Values