Excel Midterm Summer 1 09

Excel Midterm Summer 1 09 - CISY1225.C Summer 1 Excel...

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

View Full Document Right Arrow Icon
CISY1225.C Summer 1 Excel Midterm June 2009 Paul Sherwood Excel 35 point Midterm: 5 points for each Worksheet Name: ____________________________ A Number: ____________ Time Out: _________ NOTE: Do not embed your data; use functions wherever possible; use absolute references where necessary; make your formulas or functions so they can be copied down columns where appropriate. . A. Open the Excel Midterm.xlxs file from Blackboard; save it on your Desktop and rename the file with your name. For example PaulSherwood.xlxs . Save your work often – power failures can happen! B. Open the SUBTOTAL worksheet. Use the subtotal command to show the minimum, maximum and average selling price and average lending rate for homes by house type. Also show the number of homes with a fireplace. Collapse the report to show the details only for the house type (instead of each individual house). C. Open the TEXT worksheet. The name in cell C3 is an email address with the following format: [email protected]
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 note was uploaded on 02/16/2011 for the course CISY 1221 taught by Professor Shreenan during the Summer '09 term at Saint Mary's University Texas.

Page1 / 2

Excel Midterm Summer 1 09 - CISY1225.C Summer 1 Excel...

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