WEMBA Excel Review - Duke University
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 download
- more formulae and functions exercises
- advanced excel statistical functions formulae
- ms excel weebly
- wemba excel review duke university
- chapter 4 multiobjective value analysis
- introduction to excel formulae functions exercises
- excel functions to examine the properties of probability
- conditional functions if table lookup
- functions in excel
Related searches
- duke university nonprofit certificate program
- duke university nonprofit management program
- duke university certificate in nonprofit
- is duke university a 501c3
- duke university executive leadership program
- duke university nonprofit leadership
- duke university ein number
- duke university hospital leadership
- duke university directions
- duke university certificate program online
- duke university graduate certificate programs
- duke university undergraduate application