Microsoft Office Tutorials and References
In Depth Information
2 Formulas, Functions,
In Chapter 1, you learned how to enter data, sum values, format a worksheet to make
it easier to read, and draw a chart. This chapter continues to highlight these topics and
presents some new ones.
The new topics covered in this chapter include using formulas and functions to
create a worksheet. A function is a prewritten formula that is built into Excel. Other
new topics include option buttons, verifying formulas, applying a theme to a worksheet,
adding borders, formatting numbers and text, using conditional formatting, changing the
widths of columns and heights of rows, spell checking, using alternative types of worksheet
displays and printouts, and adding page headers and footers to a worksheet. One alternative
worksheet display and printout shows the formulas in the worksheet instead of the values.
When you display the formulas in the worksheet, you see exactly what text, data, formulas,
and functions you have entered into it.
Project — Worksheet with Formulas and Functions
The project in this chapter follows proper design guidelines and uses Excel to create
the worksheet shown in Figure 2 – 1. The Mobile Masses Store opened its doors when
consumer demand for mobile devices, such as mobile phones and PDAs, had just begun.
The store’s owners pay each employee on a biweekly basis. Before the owners pay the
employees, they summarize the hours worked, pay rate, and tax information for each
employee to ensure that the business properly compensates its employees. This summary
includes information such as the employee names, hire dates, number of dependents,
hours worked, hourly pay rate, net pay, and tax information. As the complexity of
the task of creating the summary increases, the owners want to use Excel to create
a biweekly payroll report.