EX16XLCH09GRADERCAPHW_-_School_of_Information_Sciences_15_Instructions.docx

This preview shows page 1 - 2 out of 3 pages.

The preview shows page 1 - 2 out of 3 pages.
Grader - InstructionsExcel 2016 ProjectEX16_XL_CH09_GRADER_CAP_HW - School of Information Sciences 1.5Project Description:You are the financial manager for the School of Information Sciences. Your school has three divisions: InformationManagement, Information Systems, and Information Technology. You need to complete a workbook to track facultyprofessional development expenses for each division.Steps to Perform:StepInstructionsPointsPossible1Open the downloaded workbook namedexploring_e09_grader_h1_IM.xlsxand save it asexploring_e09_grader_h1_IM_LastFirst.02In cell B3 in the Bonnet sheet, create a validation rule with thesespecifications:• Whole number less than or equal to$350.• Input message titleProfessional Membershipand input messageEnter the amount of the annual professional membership dues.• Error alert style Warning, alert titleToo Expensive, and errormessageThe amount you tried to enter exceeds $350. Pleaseselect a less expensive membership.Hint: On the Data tab, in the Data Tools group, click Data Validation.

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 3 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Winter
Professor
HollyHilary
Tags
Decimal, Bonnet, School of information, cell b3

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture