March 2008
Beginner
960 pages
24h 34m
English
After you add your data to a worksheet and define ranges to simplify data references, you can create a formula, or an expression that performs calculations on your data. For example, you can calculate the total cost of a customer’s shipments, figure the average number of packages for all Wednesdays in the month of January, or find the highest and lowest daily package volumes for a week, month, or year.
To write an Excel 2007 formula, you begin the cell’s contents with an equal (=) sign; when Excel 2007 sees it, it knows that the expression following it should be interpreted as a calculation, not text. After the equal sign, type the formula. For example, you can find the sum of the numbers in cells C2 and C3 ...
Read now
Unlock full access