學門類別
最新個案
- Leadership Imperatives in an AI World
- Vodafone Idea Merger - Unpacking IS Integration Strategies
- V21 Landmarks Pvt. Ltd: Scaling Newer Heights in Real Estate Entrepreneurship
- Snapchat’s Dilemma: Growth or Financial Sustainability
- Did I Just Cross the Line and Harass a Colleague?
- Predicting the Future Impacts of AI: McLuhan’s Tetrad Framework
- Porsche Drive (A) and (B): Student Spreadsheet
- Porsche Drive (B): Vehicle Subscription Strategy
- TNT Assignment: Financial Ratio Code Cracker
- Winsol: An Opportunity For Solar Expansion
Introduction to Logic Functions in Microsoft Excel
內容大綱
The purpose of this note is to introduce the concept of logical statements in Microsoft Excel and to illustrate the use of Excel’s built-in logic functions. The note includes practice exercises and their solutions, and a supporting Excel workbook for students.
學習目標
After completion of this note and its associated activities, students should be able to do the following:<ul><li>Compare values using =, >, and <</li><li>Use the built-in functions in Microsoft Excel to evaluate compound logical statements (such as AND and OR).</li><li>Use the IF function to produce a specific output in response to a true or false outcome resulting from a logical assessment.