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 illustrate 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, borders, formatting numbers and text, conditional formatting, changing the
widths of columns and heights of rows, spell checking, 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
The project in this chapter follows proper design guidelines and uses Excel to create
the worksheet shown in Figure 2 – 1. HyperMass Online Storage established its
online website to provide online storage for its customers. The owners pay employees
to maintain the servers and handle customer requests. 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, number of dependents,
hours worked, hourly pay rate, tax information, net pay, and hire date. As the
complexity of the task of creating the summary increases, the owners want to use
Excel to create a salary report.