WEMBA Excel Review



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.

Google Online Preview   Download