Project Description: You are the financial manager for the School of Information Sciences. Your school has three divisions: Information Management, Information Systems, and Information Technology. You need to complete a workbook to track faculty professional development expenses for each division. Instructions: For the purpose of grading the project you are required to perform the following tasks: Points Possible Step Instructions Open the downloaded workbook named exploring e09 grader_hl IM.xlsx and save it as exploring e09_grader h1 IM LastFirst 0.000 In cell B3 in the Bonnet sheet, create a validation rule with these specifications: Whole number less than or equal to $350 Input message title Professional Membership and input message Enter the amount of the annual 2 professional membership dues 10.000 Error alert style Warning, alert title Too Expensive, and error message The amount you tried to enter exceeds $350. Please select a less expensive membership. On the Bonnet worksheet, in cell A1, apply the Heading 1 cell style. Group the four faculty worksheets, fill the contents of cell B3 from the Bonnet worksheet to the other three faculty worksheets. Use the option that fills all. Ungroup the worksheets and change the values in cell B3 in these sheets: Hoffman S200, Myeong S350, Stathopoulos $400. When the error message displays, click No, type 350, and press ENTER 6.000 Group the four faculty worksheets. Select the range Al:A6 in the Bonnet worksheet and fill across the 4 other grouped worksheets. 6.000 With the sheets grouped, change the width of column A to 26 4.000 With the sheets grouped, enter the SUM function in cell B6 of the Bonnet worksheet to total her 6 expenses 8.000 With the sheets grouped, format cells B3 and B6 with Accounting Number Format with zero decimal 7 places. Format the range B4:B5 with Comma Style with zero decimal places. 4.000 Project Description: You are the financial manager for the School of Information Sciences. Your school has three divisions: Information Management, Information Systems, and Information Technology. You need to complete a workbook to track faculty professional development expenses for each division. Instructions: For the purpose of grading the project you are required to perform the following tasks: Points Possible Step Instructions Open the downloaded workbook named exploring e09 grader_hl IM.xlsx and save it as exploring e09_grader h1 IM LastFirst 0.000 In cell B3 in the Bonnet sheet, create a validation rule with these specifications: Whole number less than or equal to $350 Input message title Professional Membership and input message Enter the amount of the annual 2 professional membership dues 10.000 Error alert style Warning, alert title Too Expensive, and error message The amount you tried to enter exceeds $350. Please select a less expensive membership. On the Bonnet worksheet, in cell A1, apply the Heading 1 cell style. Group the four faculty worksheets, fill the contents of cell B3 from the Bonnet worksheet to the other three faculty worksheets. Use the option that fills all. Ungroup the worksheets and change the values in cell B3 in these sheets: Hoffman S200, Myeong S350, Stathopoulos $400. When the error message displays, click No, type 350, and press ENTER 6.000 Group the four faculty worksheets. Select the range Al:A6 in the Bonnet worksheet and fill across the 4 other grouped worksheets. 6.000 With the sheets grouped, change the width of column A to 26 4.000 With the sheets grouped, enter the SUM function in cell B6 of the Bonnet worksheet to total her 6 expenses 8.000 With the sheets grouped, format cells B3 and B6 with Accounting Number Format with zero decimal 7 places. Format the range B4:B5 with Comma Style with zero decimal places. 4.000
