Microsoft Office Tutorials and References
In Depth Information
CHAPTER THREE What-If Analysis, Charting, and Working with Large Worksheets
3 What-If Analysis,
Charting, and Working
with Large Worksheets
Objectives
You will have mastered the material in this chapter when you can:
Rotate text in a cell
Create Sparkline charts
Create a series of month names
Use the Format Painter button to
format cells
Create a 3-D Pie chart on a separate
Copy, paste, insert, and delete cells
Format numbers using format symbols
chart sheet
Rearrange worksheet tabs
Freeze and unfreeze rows and
columns
Show and format the system date
Change the worksheet view
Answer what-if questions
Use absolute and mixed cell
references in a formula
Use the IF function to perform a
Goal seek to answer what-if
questions
logical test
Search JabSto ::




Custom Search