IS225 Lab Week04

IS225 Lab Week04 - IS 225 Lab exercise Week 5 March 28,...

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

View Full Document Right Arrow Icon
IS 225 Lab exercise Week 5 March 28, 2006 Working with multiple worksheets, named ranges, lookups, templates Case 1 – Café Sales 1. Copy the JavaCafe.xls provided by the instructor on the network to your local machine and save it as LastnameFirstname_java.xls. Enter your name and current date in the Documentations worksheet. 2. Insert 3 new worksheets and name them Quarter 2, Quarter 3, and Quarter 4. 3. Group all ‘Quarter’ worksheets. 4. Format cells B5:F8 into currency. Add a border above Total row. 5. Select columns A:F from Quarter 1 and fill contents and formats to the rest of the worksheets using Fill Across Worksheets functionality. Ungroup worksheets. 6. Open Data.xls. In JavaCafe.xls, create cell references to fill the values in each worksheet with data from Data.xls. 7. Change the value for Quarter 1 Coffee Tempe (25000) to 9999 in Data.xls. Save the changes. 8. Close and open the JavaCafe.xls. In the dialog, click to Update reference. The value in JavaCafe.xls should reflect the change to 9999.
Background image of page 1

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

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

This document was uploaded on 10/17/2010.

Page1 / 2

IS225 Lab Week04 - IS 225 Lab exercise Week 5 March 28,...

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

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