Microsoft Office Tutorials and References
In Depth Information
Review Questions
REVIEW QUESTIONS
Use the data set in the sheet named Review in the chapter
s workbook to format the
area. The data and its chart are shown here.
1. The following data, which you can
s workbook, contains
Dow Jones Volume and Prices for June 4 through June 12, 2012. Insert a Line
and a Column Sparkline for the Volume and the Closing price.
nd in the chapter
X 2
Y 2 , create
2. Using the data of the Review spreadsheet for the formula Z
¼
þ
the four types of Surface Chart.
3. Use the model and the Data Table and Chart on the sheet Review 2 and create
two scroll bars to animate the chart. Add a dynamic Text Box that displays the
Break-Even Chart as it changes.
Profit Analysis
$500,000
Sales Units
20,000
$20
$16
$50,000
$400,000
$370,000
$30,000
$450,000
Unit Price
Cost per Unit
Fixed Monthly Expenses
Revenue
Total Cost
Profit
$400,000
$350,000
$300,000
$250,000
$200,000
$150,000
$100,000
$50,000
Break-Even Point
12,500
$0
0
2,500
5,000
7,500 10,000
Units Sold
12,500 15,000 17,500 20,000
 
Search JabSto ::




Custom Search