School of Information Sciences 1.5

By
Responsive Centered Red Button

Need Help with this Question or something similar to this? We got you! Just fill out the order form (follow the link below), and your paper will be assigned to an expert to help you ASAP.

Order Form

QUESTION

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.

Steps to Perform:
Step Instructions Points Possible
1 Open the downloaded workbook named exploring_e09_grader_h1_IM.xlsx and save it as exploring_e09_grader_h1_IM_LastFirst. 0
2 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 professional membership dues.
• 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.

Hint: -Validation rule as taught with correct specs
-Correct input message Title
-Correct Input message
-Correct Error alert style warning
-Correct Warning Title
-Correct Error message
10
3 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 $200, Myeong $350, Stathopoulos $400. When the error message displays, click No, type 350, and press ENTER.

Hint: -Heading 1 cell style on Bonnet worksheet A1
-Worksheets grouped to fill contents of B3
-B3 in each sheet changed with correct value
-Correct response to Error message warning
6
4 Group the four faculty worksheets. Select the range A1:A6 in the Bonnet worksheet and fill across the other grouped worksheets.

Hint: -Worksheet grouped correctly
-A1:A6 value fill across grouped worksheets
-Correct values
6
5 With the sheets grouped, change the width of column A to 26.
4
6 With the sheets grouped, enter the SUM function in cell B6 of the Bonnet worksheet to total her expenses.

Hint: -Worksheets grouped correctly to fill contents of B6
-SUM function with correct cells reference
-Correct total expenses from the SUM function for each sheet
8
7 With the sheets grouped, format cells B3 and B6 with Accounting Number Format with zero decimal places. Format the range B4:B5 with Comma Style with zero decimal places.

Hint: -Cells B3 and B6 in grouped sheets formatted with Accounting number format with zero decimal places
-Range B4:B5 in grouped sheets formatted with Comma Style with zero decimal places
4
8 With the sheets grouped, apply Underline to cell B5 and Double Underline to cell B6. Ungroup the worksheets.
Note, use the Format Cells dialog box to ensure that the Underline styles Single and Double are applied, rather than Single Accounting or Double Accounting.

Hint: -Worksheets grouped correctly to underline cell B5
-Worksheets grouped correctly to Double underline B6
-Format Cells dialog box used to ensure underline styles single and double are applied.
5
9 In the IM Division sheet in cell B4, enter a formula with a 3-D reference to Bonnet’s professional membership dues. In cell C4, enter a formula with a 3-D reference to Hoffman’s professional membership dues. In cell D4, enter a formula with a 3-D reference to Myeong’s professional membership dues. In cell E4, enter a formula with a 3-D reference to Stathopoulos’s professional membership dues.

Hint: -Used 3-D cell referencing for Formula in IM Division cell B4
-3-D cell reference to Bonnet’s professional membership dues
-Used 3-D cell referencing for Formula in IM Division cell C4
-3-D cell reference to Hoffman’s professional membership dues
-Used 3-D cell referencing for Formula in IM Division cell E4
-3-D cell reference to Stathopoulos’s professional membership dues
-Correct results from 3-D references above
10

Sample Solutions
Lorem ipsum dolor sit amet, consectetuer adipiscing elit. Phasellus hendrerit. Pellentesque aliquet nibh nec urna. In nisi neque, aliquet vel, dapibus id, mattis vel, nisi. Sed pretium, ligula sollicitudin laoreet viverra, tortor libero sodales leo, eget blandit nunc tortor eu nibh. Nullam mollis. Ut justo. Suspendisse potenti.

Get sample solution
Order Now

Sed egestas, ante et vulputate volutpat, eros pede semper est, vitae luctus metus libero eu augue. Morbi purus libero, faucibus adipiscing, commodo quis, gravida id, est. Sed lectus. Praesent elementum hendrerit tortor. Sed semper lorem at felis. Vestibulum volutpat, lacus a ultrices sagittis, mi neque euismod dui, eu pulvinar nunc sapien ornare nisl. Phasellus pede arcu, dapibus eu, fermentum et, dapibus sed, urna.

Morbi interdum mollis sapien. Sed ac risus. Phasellus lacinia, magna a ullamcorper laoreet, lectus arcu pulvinar risus, vitae facilisis libero dolor a purus. Sed vel lacus. Mauris nibh felis, adipiscing varius, adipiscing in, lacinia vel, tellus. Suspendisse ac urna. Etiam pellentesque mauris ut lectus. Nunc tellus ante, mattis eget, gravida vitae, ultricies ac, leo. Integer leo pede, ornare a, lacinia eu, vulputate vel, nisl.
Suspendisse mauris. Fusce accumsan mollis eros. Pellentesque a diam sit amet mi ullamcorper vehicula. Integer adipiscing risus a sem. Nullam quis massa sit amet nibh viverra malesuada. Nunc sem lacus, accumsan quis, faucibus non, congue vel, arcu. Ut scelerisque hendrerit tellus. Integer sagittis. Vivamus a mauris eget arcu gravida tristique. Nunc iaculis mi in ante. Vivamus imperdiet nibh feugiat est.
Ut convallis, sem sit amet interdum consectetuer, odio augue aliquam leo, nec dapibus tortor nibh sed augue. Integer eu magna sit amet metus fermentum posuere. Morbi sit amet nulla sed dolor elementum imperdiet. Quisque fermentum. Cum sociis natoque penatibus et magnis xdis parturient montes, nascetur ridiculus mus. Pellentesque adipiscing eros ut libero. Ut condimentum mi vel tellus. Suspendisse laoreet. Fusce ut est sed dolor gravida convallis. Morbi vitae ante. Vivamus ultrices luctus nunc. Suspendisse et dolor. Etiam dignissim. Proin malesuada adipiscing lacus. Donec metus. Curabitur gravida

How to create Testimonial Carousel using Bootstrap5

Clients' Reviews about Our Services