個案資料
了解個案內容與學習目標，選擇授課教師及使用課程。
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.