Spreadsheets programs can also performcalculationson the data usingformulas.
Formulas entered in subsequent steps make use of the cell references of the data entered now.
To correct this problem so that the data is fully visible, thecolumnscontaining that data need to be widened.
Lifewire / Adrian Mangel
As with all Microsoft programs, there aremultiple ways of widening columns.
The steps below cover how to widen columns using the mouse.
Excel has a number ofdate functionsthat make it easy to enter the date into a worksheet.
Entering the Tutorial Data.
Adding the Date with the TODAY function
The steps below will add theTODAYfunction tocell C2of the worksheet.
Instead, they display the######error.
To correct the problem, widencolumn Cusing the method described in the preceding step of the tutorial.
Widening Columns to Display the Data.
In this tutorial, the nameratewill be given tocell C6to identify the deduction rate applied to employee salaries.
The named range will be used in thededuction formulathat will be added tocells C6toC9of the worksheet.
This name will be used to simplify creating theDeductions formulasin the next step of the tutorial.
Adding a Named Range to the Worksheet.
The results of the formula will update automatically once the data changes.
The first formula created incell C6will multiply theGross Salaryof the employee B. Smith by the deduction rate incell C3.
As a result, the worksheet is currently complete for only one employee -B. Smith.
Entering the Deduction Formula.
The fill handle has a number of uses including copying a cells contents to adjacent cells.
filling cells with a series of numbers or text labels, and copying formulas.
This step will merge and center the worksheet title -Deduction Calculations for Employees.
Entering the Net Salary Formula.
Using the Fill Handle to Copy Formulas.
Adding Number Formatting to the Worksheet.
Applying Cell Formatting to the Data.
