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

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

View Full Document Right Arrow Icon
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
Background image of page 1

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

View Full DocumentRight Arrow Icon
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
Background image of page 2
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.
Background image of page 3

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

View Full DocumentRight Arrow Icon
CS105 Spring 2008 Lab 7 4 The IF Function Flowchart Condition True False Result for  True  Condition Result for  False  Condition
Background image of page 4
CS105 Spring 2008 Lab 7 5 How Does IF Work in Excel? Recall from lecture how the formula 
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

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 Right Arrow Icon
Ask a homework question - tutors are online