# Excel2 - CS105 Lab 7 Excel The IF Function Announcements...

This preview shows pages 1–6. Sign up to view the full content.

CS105 Spring 2008 Lab 7 1 CS105 Lab 7 – Excel: The IF Function Announcements MP3 is due on  Saturday, Mar 8 th  at noon . You will lose 10  points if you do not submit MP3 properly. Midterm 1 scores are available in Compass.  You have  until  Saturday, Mar. 8 th  to challenge questions on the  exam. Pick up your feedback form for Midterm 1 today.  You can  view the Midterm 1 exam test forms in Compass. MP2 Gallery is published on cs105 homepage, check it  out

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
CS105 Spring 2008 Lab 7 2 Lab Objectives Learn the IF function. Learn to use nested IF. Learn to reference other worksheets in  Excel. Learn to use Lookup Tables Go to the course website and download the  Excel Worksheet for Lab 7.  http://www.cs.uiuc.edu/class/cs105
CS105 Spring 2008 Lab 7 3 A “real world” Scenario…  This spreadsheet contains sales data for a tea  manufacturing company which sells 3  different brands of tea.  Let’s find out how much of the revenue comes  from each product line. We’ll use the  IF  function to do this.

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
CS105 Spring 2008 Lab 7 4 The IF Function Flowchart Condition True False Result for  True  Condition Result for  False  Condition
CS105 Spring 2008 Lab 7 5 How Does IF Work in Excel? Recall from lecture how the formula

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 18

Excel2 - CS105 Lab 7 Excel The IF Function Announcements...

This preview shows document pages 1 - 6. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online