Microsoft Office Tutorials and References
In Depth Information
EX 84
Excel Chapter 2 Formulas, Functions, Formatting, and Web Queries
Figure 2–2
Overview
As you read this chapter, you will learn how to create the worksheet shown in
Figure 2–1 by performing these general tasks:
• Enter formulas and apply functions in the worksheet
• Add conditional formatting to the worksheet
• Apply a theme to the worksheet
• Work with the worksheet in Page Layout View
• Print a part of the worksheet
• Perform a Web query to get real-time data from a Web site and create a new
worksheet
• E-mail the worksheet
Aesthetics versus
Function
In designing a worksheet,
functional considerations
should come fi rst, before
visual aesthetics. The
function, or purpose, of a
worksheet is to provide a
user with direct ways to
accomplish tasks. Avoid
the temptation to use
fl ashy or confusing visual
elements within the
worksheet, unless they
will help the user more
easily complete a task.
C6161_EXC_02.4c.indd 84
C6161_EXC_02.4c.indd 84
3/6/07 3:27:59 PM
3/6/07 3:27:59 PM
Search JabSto ::




Custom Search