WEMBA Excel Review - Fuqua School of Business
Excel Logic Exercises
for Duke’s
Fuqua School of Business
Decision Models Course
2005
Introduction
These paper based logic exercises for Excel are also available in electronic format. But you may find the paper version more convenient or that it makes it easier to focus on the logic without the distraction of the actual spreadsheet.
A variety of spreadsheet based exercises and learning tools are also available to you, including:
BasicsPractice.xls
ProficiencyExercises.xls
LogicPractice.xls
MoreLogicPractice.xls
ChartingBasics.xls
Addressing.xls
ExcelAuditing.xls
UsingOnlineHelp.xls
FormulaReview.xls
Look for these workbooks on this general Excel review web page:
Paula Ecklund
Duke’s Fuqua School of Business
Fall 2005
Contents
Page
Exercise 1: Using AND, OR, and NOT functions 1
Exercise 2: Using the IF function 2
Exercise 3: More practice with the IF function 3
Exercise 4: IF function practice (from the Proficiency Exercises) 4
Exercise 5: Building and using a Nested IF statement 5
Exercise 6: IF, MIN, and SUMPRODUCT 6
Exercise 7: Write a formula for multiple conditions 8
Answer Key 11
This page intentionally left blank.
Using Logical Functions in Modeling
Exercise 1. Using Excel’s AND, OR, and NOT Functions
File: LogicPractice.xls, Worksheet: “AND OR NOT”
| |A |
|1 |The Data |
|2 |15 |
|3 |9 |
|4 |8 |
A. Write an AND formula to determine if A2>A3 and A2A3 or A259,"D","F"))))
B. =IF(A3>89,"A",IF(A3>79,"B", IF(A3>69,"C",IF(A3>59,"D","F"))))
C. =IF(A4>89,"A",IF(A4>79,"B", IF(A4>69,"C",IF(A4>59,"D","F"))))
Exercise 4 – Page 10
IF Function Practice (From the Proficiency Exercises)
File: LogicPractice.xls Worksheet: Olive Oil Logic - 1
A. =IF(A5 ................
................
In order to avoid copyright disputes, this page is only a partial summary.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related searches
- wharton school of business requirements
- wharton school of business application
- forbes school of business ranking
- wharton school of business courses
- wharton school of business admission
- wharton school of business ranking
- wharton school of business admissions
- wharton school of business online
- wharton school of business mba
- wharton school of business certificates
- wharton school of business undergraduate
- school of business rankings