Microsoft Office Tutorials and References
In Depth Information
Exhibit 4.30 Advanced filter of projects X and Y for question 5
OR , NOT , FALSE , and TRUE functions. There will many opportunities in later
chapters to use logical cell functions.
In the Chap. 5 we will examine ways to perform hard analysis of qualitative
data. Also, we will learn how to generate PivotChart and PivotTable reports. Beside
their analytical value, these tools can also greatly simplify the presentation of data,
and although it is somewhat similar to the material in this chapter, because of its
importance and widespread use, it deserves a separate exposition.
Key Terms
Qualitative Data
Soft Data Analysis
Hard Data Analysis
Record
Field
Form
Validation
Transpose
Array
Logical IF
Nested IF’s
AND, OR, NOT, FALSE, TRUE
Absolute Address
VLOOKUP/HLOOKUP
LOOKUP
Tab Delimited
Search JabSto ::




Custom Search