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)
You can sort your data to display categories in largest to smallest order. For ...