Microsoft Office Tutorials and References
In Depth Information
Apply Your Knowledge
What decisions will you need to make when creating workbooks in the future?
1. Determine the workbook structure.
a) Determine the formulas and functions you will need for your workbook.
b) Sketch a layout of your data and functions.
2. Create the worksheet.
a) Enter the titles, subtitles, and headings.
b) Enter the data, desired functions, and formulas.
3. Format the worksheet.
a) Determine the theme for the worksheet.
b) Format the titles, subtitles, and headings using styles.
c) Format the totals, minimums, maximums, and averages.
d) Format the numbers and text.
e) Resize columns and rows.
Apply Your Knowledge
Reinforce the skills and apply the concepts you learned in this chapter.
Cost Analysis Worksheet
Note: To complete this assignment, you will be required to use the Data Files for Students. Visit for detailed instructions or contact your instructor for
information about accessing the required les.
Instructions: The purpose of this exercise is to open a partially completed workbook, enter
formulas and functions, copy the formulas and functions, and then format the worksheet titles and
numbers. As shown in Figure 2 – 70, the completed worksheet analyzes the costs associated with a
taxi company’s eet of vehicles.
Figure 2 – 70
Continued >
Search JabSto ::

Custom Search