{oapdf_gg}
Office software is closely linked to the PDF,the PDF is also must have to control!      Set home Page  Add to Favorites  
You are here:Home > OA application skills > EXCEL skills
EXCEL skills
Excel database function application function detailed tutorial (with examples)
Finishing by: Date:2009-04-11 12:39:35 Popularity: Tags:tutorial


(4) As the second asked for the sake of the largest apple and pear profits, so re-establishment of a query - pear, as shown in Fig.


Figure 5

(5) the use of DMAX function to derive the largest apple and pear profits DMIN same function can be used to derive more than 10 feet high minimum profit of apple trees. Specific formula is:

= DMAX (A4: E10, "Profit", A1: A3) to derive the largest apple and pear profit 105

= DMIN (A4: E10, "Profit", A1: B2) obtained more than 10 feet high minimum profit of apple trees 75

(6) can be obtained using DSUM function of the total profits of all the apple trees.

Formula: = DSUM (A4: E10, "Profit", A1: A2) the total profit of 225

(7) asked other similar functions can be used to solve in detail the formula as shown.


Figure 6

there isArticle InformationsComment Information
Category column

Site Help | Site Map | Feedback |
OAPDF.COM Copyright 2009 V1.1