Microsoft Office Tutorials and References
In Depth Information
Adding table calculations
The Sort command lets you sort by up to three fi elds.
If you did not select a column before opening the Sort dialog box, select the fi rst sort fi eld
from the Sort by drop-down list. Open the Type drop-down list and click Text, Number,
or Date to match up with the type of data stored in the sort column. Choose Ascending or
Descending depending on whether you want to sort from A to Z, or lowest to highest, or
most recent to least recent — or vice versa for any of those. To sort by additional fi elds,
open the two Then by drop-down lists and click a fi eld name to include up to two of them,
and set the additional type and sort order settings. Click Options to determine additional
settings, including how fi elds are delimited (for non-table sorts), whether to make the sort
case-sensitive, and the sorting language. Click OK to close Sort Options, and then click OK
to apply the sort.
Adding table calculations
Word can perform some calculations using the Formula button in the Data group of the
Layout tab (refer to Figure 9.19). To use it, fi rst create a cell or row where you want to
include formulas, and then select the fi rst cell in which to enter a formula. Note that you
only can select multiple cells when the formula will be the same in each one, such as
summing all the cells above the selection. Click Formula in the Data group of the Layout tab.
Edit the contents of the Formula text box. Or you can click to the right of the equals sign
(=) in the Formula text box and use the Paste function drop-down list to paste in one of
the predefi ned functions and indicate what cells to calculate between the parentheses. If
needed, choose a format from the Number format drop-down list; the selection shown in
Figure 9.25 formats the number with two decimal places. Click OK to insert the formula
in the cell.
Search JabSto ::

Custom Search