Microsoft Office Tutorials and References
In Depth Information
Introduction
one fi eld
appears in
each column
Age is one of ten
fi elds in table
conditional
formatting
adds icon
based on rules
column
headings are
fi eld names
(A8:J8)
one record
appears in
each row
table, also
called a
database
value in % of
Quota fi eld
determined
from formula
value in
Grade fi eld
determined by
VLOOOKUP
function
(a)
database functions
use these criteria to
determine gender
averages and count of
reps with grade of A
database functions
determine
averages and
count
SUMIF and
COUNTIF
functions sum
and count
selected values
VLOOKUP function
uses table to determine
entries in Grade fi eld
in column J based on
% of Quota fi eld
(b)
Figure 5–1
 
 
Search JabSto ::




Custom Search