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.
To fulfill the demand for quickly locating and searching documents.
It is intelligent file search solution for home and business.
Related download
- wemba excel review
- operations maintenance manual o m manual template
- brigham young university idaho
- advanced excel
- ms excel mcq quiz set 1 e library wcl
- la salle university
- introduction to excel formulae and functions
- competency examples with performance statements
- example quality assurance quality control plan
- count and sum your data in excel 2002
Related searches
- write a good review example
- write a company review examples
- overall performance review comments e
- overall performance review comments examples
- review article on financial management
- grammar review worksheet 8th grade
- photosynthesis review worksheet
- needs improvement performance review e
- free printable employee review forms
- microsoft excel help excel 2016
- descargar excel gratis excel 2013
- microsoft excel online download excel 2010