PDF Excel Logic Exercises for DecMod - Duke University
[Pages:16]Excel Logic Exercises
for Duke's Fuqua School of Business
Decision Models Course
Paper based logic exercises for Excel.
2004
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 your Duke MBA program Excel review web site or on this general Excel review web page:
Paula Ecklund Duke's Fuqua School of Business
Spring 2004
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 A2 ................
................
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
- pdf declaration of unity problems other than
- pdf private pilot practical test standards for lighter than air
- pdf excel logic exercises for decmod duke university
- pdf answer explanations sat practice test 3
- pdf retrieval practice produces more learning than elaborative
- pdf how to write a good hypothesis using if then because
- pdf some practice problems for the c exam and solutions for the
- pdf math 433 induction practice problem 1 prove by induction that
- pdf drazen s dozen articles that changed practice since 2000
- pdf extra practice with 2 1 and 2
Related searches
- excel 2016 exercises for beginners
- 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