AST - Logical Functions Lesson
Logical Functions
Introductions
How can Excel make use of the same logic we use in everyday life? In this lesson you will learn about advanced Excel logical functions that use complex arguments to solve business problems. For example, we can ask that Excel totals only certain sales that meet our specifications. Excel can do that instantly, thus saving us time and effort that would be required if we searched for the same information manually.
This lesson demonstrates how to perform logical function calculations using Excel.
Logical Functions
Tamales!
Produce Growing Contest
Congratulations, you have been invited to judge the giant produce growing contest at the county fair! You and other judges have already measured the weight of all submitted produce. Since you are an Excel expert, you have been asked to analyze the data.
Create an Excel worksheet using the information below. Use appropriate logical functions to calculate the Total Weight, Average Weight, and Number of Entries for each category of produce. Check your answer by watching the County Fair Contest Demo Video below. There is no audio with the video.
Checking for Errors
One of Excel’s most useful features is its ability to detect many errors that users commonly make. In this video, you will see some of the error messages you are likely to encounter in Excel, as well as how to resolve them.
IMAGES CREATED BY GAVS