Page 323 - Excel 2013 All-in-One For Dummies

To use the Quick Analysis tool, all you have to do is select the worksheet table’s cells and then click the Quick Analysis tool that automatically appears in the lower-right corner of the last selected cell. When you do this, a palette of options (from Formatting to Sparklines) appears right beneath the Quick Analysis tool. (See Figure 1-3.)
To add totals to your selected table data, you first click the Totals tab. You can then use your mouse or Touch pointer to have Live Preview show you totals in a new row at the bottom by highlighting the Sum or Running Total button (with a spreadsheet containing a Sigma) or in a new column on the right by highlighting the second Sum button (with the spreadsheet with the last column highlighted). To actually add the SUM formulas with the totals to a new row or column, you simply click the Sum or Running Total button of choice.
If you have trouble selecting the Quick Analysis tool to open its palette for any reason, simply right-click the cell selection and choose the Quick Analysis item on its shortcut menu.
Formulas 101 305
Figure 1-3:
Adding arowof totals with the Quick Analysis tool’s Sum button.
Building formulas with operators
Many of the simpler formulas that you build require the sole use of Excel’s operators, which are the symbols that indicate the type of computation that is to take place between the cells and/or constants interspersed between them. Excel uses four different types of operators: arithmetic, comparison, text, and reference. Table 1-1 shows all these operators arranged by type and accompanied by an example.
Book III Chapter 1
Building Basic Formulas