Lab mannual ch.3

Lab mannual ch.3 - CSE 1520.03 Computer Use: Fundamentals...

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

View Full Document Right Arrow Icon
CSE 1520.03 The Glade Computer Use: Fundamentals Laboratory Handbook Chapter 3: The IF Function and Table Lookup Objectives This laboratory focuses on the use of IF and LOOKUP functions, while continuing to introduce other functions as well. Here is a partial list of what the lab covers: Further practice of good design techniques More practice using logical functions Creating and using lookup tables and functions Preparation To be able to complete this laboratory in about 3 hours it is essential that you are properly prepared. You should read the whole of this lab very carefully. Introduction This lab continues the examination of logical functions and expands on techniques that allow a choice to be made between which values to use in a calculation. One of the common ones is the LOOKUP function. Exercise 1 - Sales Person Bonus Model Open the file Exercise 1 in Support Files (Chapter 3) on the course website. This model has two worksheets – the Comments worksheet and the Sales_Record worksheet. Your aim is to add a column to the Sales_Record worksheet, which identifies whether the particular sales person has made sales less than the average of all sales or equal to or greater than the average. The cells in the new column might contain Equal/Above or Below , for example. To do this you must first calculate the average of the sales. Enter a label such as Sales Average in a cell at the bottom of the column of names and in the cell next to it compose the formula that will calculate the average of the sales. You’ll need to use the AVERAGE function, which you have seen in a previous chapter. If you name the Sales column your formula will simply look like this: =AVERAGE(Sales) Next enter a heading for the new column – perhaps Compared to Average . Make sure the heading is appropriately formatted for the cell width and also by font size etc. You’ll probably want to choose, in Excel 2003 the Wrap text option from the Alignment tab in the Format Cells window (Figure 3.1) or, in Excel 2007 the Home tab and Wrap Text 3-1
Background image of page 1

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

View Full DocumentRight Arrow Icon
The Glade CSE 1520.03 Computer Use: Fundamentals Laboratory Handbook within the Alignment group, and to increase the cell height for the row that contains the column headings. Figure 3 .1 – the Alignment tab in the Format Cells window The IF Function Now you need to enter the formula that will decide whether the words Below or Equal/Above will appear in the first cell. Select that first cell and click on the Function button in the tool bar: The IF function can be found in the Logical group of functions (see Figure 3.2), and after pressing the OK button the argument specification panel shown in Figure 3.3 appears. Figure 3 .2 – pasting the IF function Figure 3.3 –argument panel 3-2 The Function button:
Background image of page 2
CSE 1520.03 The Glade Computer Use: Fundamentals Laboratory Handbook The Logical_test argument needs to compare the sales figure (for this sales person) to the average sales. If you didn’t name the average sales value that you calculated recently then
Background image of page 3

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

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

Page1 / 21

Lab mannual ch.3 - CSE 1520.03 Computer Use: Fundamentals...

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

View Full Document Right Arrow Icon
Ask a homework question - tutors are online