IFS 105 Computer Assignment 4

In the Lab 1 Ex 58-59

Quarterly Sales Analysis Worksheet

(see page Ex 58 (FIGURE 1-82) for model)

Hints and Corrections:

  1. In step 6 on page Ex 59, drag the right side of chart to A10:F21, notA10:H20 as listed in the book. (see FIGURE 1-82 on page EX 58 it is correct!) Also check that the text on the chart is the right size compared to FIGURE 1-82 on page EX 58, you need to change the Font size to 10.25  by using the following steps. Click on an open area of the chart to select it, right-click on the chart, from the short-cut menu click on Format Object... ,click on the Font tab, type 10.25 into the Size text box, click the OK button.
  2. In step 7 on page Ex 59, include the section number when entering the course entry (example BIS 105-N91). When entering the date in step 7 on page Ex 59, type a single quote (') before typing the month name to type the field as a string rather than date data type. example: 'July 14, 2008
  3. In step 8 on page Ex 59, Save the workbook as YourLastName Lab 1-1 Trevor's Global Golf Outlet 3rd Quarter.
  4. In step 9 and 11 on page Ex 59, you don't need to print worksheets as you will submit the files electronically.
  5. In step 11 on page Ex 59, instead of not saving the changes save the revised workbook as YourLastName Lab 1-1 Trevor's Global Golf Outlet 3rd Quarter revised.

Number of Excel files required: 2

Return to IFS 105 Computer Assignments Menu