August 2000
Intermediate to advanced
512 pages
14h 50m
English
Content preview from Word 2000 in a Nutshell
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
Name
Table → Formula
Synopsis
Use the Formula command to perform calculations on cells with numbers. For example, a column of numbers can be summed and the total presented at the bottom of the table. Place the insertion point in the cell that should contain the results of the formula and choose Table → Formula (Figure 10-24).
Figure 10-24. Constructing formulas that reference cells in a table
Word always suggests a formula based on the position of the active cell when the command is issued. This formula is rarely what is really needed. Just erase it to build your own. All formulas must start with an equals sign. After this, formulas are composed of three parts:
- Operators
Common mathematical operators such as +, -, *, and /.
- Functions
Special procedures provided by Word. Functions always appear outside parentheses. Examples of common functions are SUM, which is used to add specified values together, AVERAGE, which calculates the average of specified values, and MIN, which calculates the smallest of any specified values. Enter the name of a function directly into the Formula box or choose a function from the Paste Function list. Choosing from the list enters the value in the Formula box at the insertion point.
- Values
Simple numbers or the data in specific cells in a table. Values that are acted on by functions appear inside parentheses to the right of the function. For example, in the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.