• Share

Discuss in my forum

# Data for Excel Basic Format Tutorial

## How to Copy the Tutorial Data into an Excel Worksheet

Data for Excel Basic Format Tutorial

Note: This tutorial gives instructions for copying the sample data shown below into an Excel worksheet.

The data accompanies the Excel Basic Format Tutorial.

### Use Copy and Paste Special to Transfer Tutorial Data

1. Drag select the data in the table below to highlight all of it. Be sure to select the entire table.

3. Open Excel 2010.

4. Click on cell A2 in the worksheet to make it the active cell.

5. Click on the Home tab.

6. Click on the down arrow below the Paste button on the ribbon to open the drop down menu.

7. Choose Paste Special from the menu to open the Paste Special dialog box.

8. Choose Paste as Text from the options in the dialog box.

Each piece of data should be pasted into a separate cell in the worksheet. The data should fill the range A2 to F11.

If your data does not end up in cells A2 to F11 it probably means you didn't use Paste Special correctly. Use Excel's Undo feature to remove the data and then try steps 4 to 8 above again.

Note: The dollar signs ( \$ ) located in the Deduction formulas in the table below are used to indicate absolute cell references rather than currency formatting.

## Tutorial Data for the Basic Excel 2010 Spreadsheet Tutorial Part 2

 Deduction Calculations For Employees Date: =Today() Deduction Rate 0.06 Name Yearly Salary Bonus Total Income Deduction Net Salary Smith B. 45789 4578.9 =B8+C8 =D8*\$C\$5 =D8-E8 Wilson C. 41245 4124.5 Thompson J. 39876 3987.6 James D. 43211 4321.1

Ted French