3024.S08.HW2.KEY

3024.S08.HW2.KEY - ISE 3024/S08: HW2KEY - 1 of 4 ISE 3024...

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

View Full Document Right Arrow Icon
ISE 3024/S08: HW2KEY - 1 of 4 ISE 3024 Data Management for IEs Spring 2008 Homework Assignment #2 Solution Key (8) 1. (a) Average Inventory worksheet: • Lock all cells. • Fully protect the worksheet (i.e., user cannot select anything). Weekly inventory count worksheets: • Lock all cells except C2:C6 . • Protect the worksheet such that the user can select unlocked cells only. (b) Protect the workbook structure. (c) Protect the workbook window display. (14) 2. (a) On the weekly inventory count worksheet: (i) Select cells C2:C5 Select Data Validation… Settings tab: Allow: Whole number Data: between 0 (minimum) and 80 (maximum) Error Alert tab: Style: Stop Title: Incorrect Quantity Error message: Value must be between 0-80 (ii) Select cell C6 Select Data Validation… Settings tab: Allow: Whole number Data: between 0 (minimum) and 40 (maximum) Error Alert tab: Style: Warning Title: Incorrect or Abnormal Quantity Error message: Values normally between 0-40 (b) Yes: have Excel generate a suitable input message . (i) Select cells C2:C5 Select Data Validation… Input Message tab: Title: Inventory quantity Input Message: Enter a value between 0-80
Background image of page 1

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

View Full DocumentRight Arrow Icon
ISE 3024/S08: HW2KEY - 2 of 4 (10) 3. Sub NewInventoryWorksheet() ' ' NewInventoryWorksheet Macro
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 4

3024.S08.HW2.KEY - ISE 3024/S08: HW2KEY - 1 of 4 ISE 3024...

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

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