Adding the data to an Excel Spreadsheet
Use the data below with the tutorial: Step by Step Excel Formatting.
To enter the data accurately,
- Open a blank Excel spreadsheet file
- Select the cell indicated by the cell reference provided.
- Type the corresponding data into the selected cell.
Cell DataA2 - Deduction Calculations for Employees
B4 - Deduction Rate:
C4 - .06A6 - Last Name
B6 - Gross Salary
C6 - Deduction
D6 - Net Salary
A7 - Smith B.
B7 - 45789
A8 - Wilson C.
B8 - 41245
A9 - Thompson J.
B9 - 39876
A10 - James D.
B10 - 43211
A12 - Date:
