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




Custom Search