Appendix D. Spreadsheet Tips
These Spreadsheet Tips complement the Spreadsheet Solutions that appear throughout this book. Use these tips as a starting point to learn more about how to use Microsoft Excel or OpenOffice.org Calc 3 to obtain your own customized results. The tips are divided into three groups:
• Chart Tips that assist you in creating and refining your own charts.
• Function Tips that explain the worksheet statistical functions used in Spreadsheet Solutions
• Analysis ToolPak Tips that review how to use selected Analysis ToolPak statistical procedures (Microsoft Excel only)
CT: Chart Tips
CT1 Arranging Data in Categorical Charts
You can sort your data to display categories in largest to smallest order. ...