Chat with us, powered by LiveChat Assignment4_Document.xlsx - STUDENT SOLUTION USA

Assignment4_Document.xlsx

Grading

Grade Available
2 1. Open the Assignment 4_Document file in Excel. In the File tab, save the file as an Excel Macro-Enabled Workbook, with the name Firstname_Lastname_Assignment4, where Firstname and Lastname are replaced with your first and last names. Note that when you save a workbook as an Excel Macro-Enabled workbook, the file extension will be xlsm, rather than xlsx.Note that if you do not save your workbook in this format, then the macro you will be completing in steps 6, 7, and 8 will not be included in your assignment and therefore cannot be graded, resulting in a 0 for these steps.
Student Grades worksheet
8 2. Apply data validation over the cell range C3 through G11 that allows only decimal numbers in the range 0 through 1 to be entered. Note that 1 represents 100%. The data validation must include the input message Enter student grade. Additionally, set an error alert of style Stop, with the error message Grade must be a decimal number between 0 and 100%. Do not include a title for either the input message or error alert.Make sure to test that your data validation rejects invalid data by attempting to enter a negative number (for example -1), a number greater than 100% (for example 101%). Also try re-entering the original value in one of the cells to make sure that it is accepted. Make sure that all of the data is left at the original values when done.
2 3. Apply the 4 Traffic Lights icon set conditional formatting over the cell range C3 through G11.
12 4. Modify the conditional formatting rule you applied in the previous step as follows: • a Green Circle icon of type Number is displayed for values greater than or equal to 0.8 (representing 80%). Note: Set the type box to Number before setting the values for the icons, just like you did in the learning activity. • a Gray Circle icon of type Number is displayed for values less than 0.8 and greater than or equal to 0.6 (60%). Do not confuse gray with black – make use of the tool tips to help you. • a Yellow Circle icon is displayed for values less than 0.6 and greater than or equal to 0.5 (50%). • a Red Circle With Border icon is displayed for values less than 0.5.When done you should see that grades less than 50% have a red stop light icon, grades in the 50’s have a yellow stop light icon, grades greater than or equal to 60 and less than 80 have a gray stop light icon, and grades 80 and above have a green stop light icon.
Music Collection worksheet
5 5. Import the MusicCollection csv file beginning at cell A2 in the Music Collection worksheet. Note that the csv file uses a comma delimiter and it includes a header row.
Macro worksheet
2 6. Create a macro with the name SalesFormatting and has the shortcut key Ctrl+m. Do not begin recording the macrountil the next step.
6 7. Record the macro so that it performs only the following tasks: • Merge and centre cells A1 through D1. • Apply the Total cell style to cells A11 through D11.Make sure that you are in the Macro worksheet before starting the recording, as you must not include switching between worksheets in your macro.
Macro Test worksheet
2 8. Run the SalesFormatting macro in the Macro Test worksheet to ensure that it performs the required tasks.
Home Inventory worksheet
2 9. Sort the cell range A3 through E33 alphabetically by the type of room.
8 10. Using the Subtotal feature, apply a subtotal to the cell range A2 through E33, such that it groups by room type, includes a Sum for only the Qty and Total columns, applies a page break between groups, and sets the total summary so that it displays above the data.
2 11. Adjust the outline level so that only the room totals and grand total are displayed.
Gull Corporation worksheet
3 12. Insert the picture file named Seagull that you downloaded previously, such that the upper left corner of the picture is located in cell B3.
2 13. Change the height of the seagull picture to be 4 inches (or 10.2 cm). Make sure to use a technique that keeps the height to width ratio the same, so that the picture does not become distorted.
2 14. Apply the picture effect Soft Edges with a setting of 50 Point to the seagull picture.
2 15. Adjust the colour of the seagull picture to a recolor of Grayscale.
2 16. Apply the Crisscross Etching artistic effect to the seagull picture.
2 17. Insert a WordArt with the WordArt style Fill: Blue, Accent color 5; Outline: White, Background color 1; Hard Shadow: Blue, Accent color 5. Do not adjust the size of the WordArt.
2 18. Set the text of the WordArt to Gull Corp. (including the period).
2 19. Place the WordArt so that it is just covering the seagull's feet (approximately).
2 20. Insert a Name and Title Organization Chart SmartArt graphic to the right of the seagull picture.
2 21. Alter the organization chart so that it has four boxes on the third row instead of three.
3 22. Insert text in each box (name and title) of the organization chart as follows: top row – C. (Charlie) Gull is President, secondrow – Izzy Gull is Admin, third row – Henry Gull is Left Wing, Madi Gull is Drumstick, Grant Gull is Giblets, and Zach Gull isRight Wing. Make sure to put the titles (e.g. President) in the white title boxes. If you do not see the white title boxes, then youselected the wrong SmartArt graphic type.
2 23. Change the SmartArt style to Polished.
2 24. Change the SmartArt colours to Colored Outline – Accent 5.
1 25. Turn off display of the gridlines.
0.0 80
0.0%

Student Grades

Student Name Course
Last First Math English Excel Physics Chemistry
Carrey Jim 79% 49% 88% 69% 54%
O'Hara Catherine 63% 85% 74% 47% 53%
Gosling Ryan 87% 69% 78% 95% 52%
McAdams Rachel 44% 94% 80% 88% 49%
Meyers Mike 100% 90% 66% 62% 62%
Reeves Keanu 89% 96% 92% 51% 81%
Reynolds Ryan 83% 40% 60% 79% 59%
Elliot Page 49% 63% 71% 56% 83%
Shatner William 53% 73% 100% 88% 77%

Music Collection

Music Collection

Macro

We're Pretty Good Trucking Inc.
"We do it all with just one truck!"
First Quarter Sales
Customer January February March
Acme Organic Apple Orchards $ 367 $ 290 $ – 0
The Dairy Emporium 3,589 5,735 7,336
Put'em Down Animal Rendering 7,345 5,890 19,564
Only the Lonely Perfumes Inc. 1,239 967 245
Atomic Energy Limited (Nuclear Waste Disposal Division) 17,634 35,765 63,678
Get Well Soon Pharmaceuticals 9,534 6,745 8,795
Total $ 39,708 $ 55,392 $ 99,618

Macro Test

We're Pretty Good Trucking Inc.
"We do it all with just one truck!"
First Quarter Sales
Customer January February March
Acme Organic Apple Orchards $ 367 $ 290 $ – 0
The Dairy Emporium 3,589 5,735 7,336
Put'em Down Animal Rendering 7,345 5,890 19,564
Only the Lonely Perfumes Inc. 1,239 967 245
Atomic Energy Limited (Nuclear Waste Disposal Division) 17,634 35,765 63,678
Get Well Soon Pharmaceuticals 9,534 6,745 8,795
Total $ 39,708 $ 55,392 $ 99,618

Home Inventory

Home Inventory for Insurance
Room Item Qty Value Total
Bedroom Bed 1 $ 1,000 $ 1,000
Miscellaneous Books 25 $ 10 $ 250
Kitchen Chair 4 $ 50 $ 200
Living Room Chair 2 $ 75 $ 150
Bedroom Clock 1 $ 12 $ 12
Bedroom Computer 1 $ 475 $ 475
Living Room Couch 1 $ 300 $ 300
Kitchen Cups 4 $ 2 $ 8
Kitchen Cutlery Set 1 $ 25 $ 25
Bedroom Desk 1 $ 200 $ 200
Living Room End Table 2 $ 85 $ 170
Kitchen Frying Pan 1 $ 20 $ 20
Kitchen Glasses 4 $ 2 $ 8
Bathroom Hair Dryer 1 $ 25 $ 25
Living Room Knick Knacks 17 $ 6 $ 102
Bedroom Lamp 1 $ 15 $ 15
Bathroom Linen 5 $ 15 $ 75
Bathroom Mirror 1 $ 10 $ 10
Kitchen Oven 1 $ 500 $ 500
Living Room Piano 1 $ 800 $ 800
Kitchen Plates 4 $ 3 $ 12
Kitchen Pots and Pans 1 $ 100 $ 100
Bathroom Razor 1 $ 50 $ 50
Kitchen Refrigerator 1 $ 700 $ 700
Kitchen Table 1 $ 200 $ 200
Living Room Television 1 $ 750 $ 750
Kitchen Toaster 2 $ 15 $ 30
Miscellaneous Tools 10 $ 12 $ 120
Miscellaneous Vacuum Cleaner 1 $ 200 $ 200
Living Room Video Game Player 1 $ 350 $ 350
Living Room Video Games 10 $ 45 $ 450

Gull Corporation

Get Your Paper Before the Deadline. Our Services are 100% private and Confidential

Useful Links That Will Help You Around

Link to new order   https://studentsolutionsusa.com/orders/stud/new

link to login page   https://studentsolutionsusa.com/orders/login

New user registration link   https://studentsolutionsusa.com/orders/register

Forgot Password https://studentsolutionsusa.com/orders/forgot/password

 

FREQUENTLY ASKED QUESTIONS

Question: How does this work?

Answer: Good Question. We are a group of a freelance board of students and professional essay writers. At our website, you may get help with any type of academic assignments: essay, coursework, term paper, business plan, case study, article review, research paper, presentation, and speech. Top writers can help with complex assignments such as dissertations, thesis papers, etc. All of them are professionals possessing excellent knowledge in their field of expertise, perfect writing skills, quality, and speed. When you place an order on our website, we assign it to the best writer.  Once the writer finishes the work, the paper is submitted to our quality assurance desk who go through it and ensure it is unique and plagiarism free and that the instructions were followed to the detail. After this step we upload the paper in your account, we also send a copy to the email that you used to register the account with. we can guarantee you that the paper will be 100% plagiarism free. Besides, our services are 100% private and confidential

Question: How do I place an Order after getting to the order page

Answer: There are three major steps in the ordering process

Step 1 ....................................................paper details In this step, you will fill in the instructions of your paper; you can upload any materials that you feel will make your assignment a success. Besides, you can also email us at [email protected] Remember to specify the correct academic level. Please note that sources mean the number of references.

Step 2...................................................... Price calculation Kindly specify the number of pages, type of spacing and the correct deadline. This step will give you the estimated cost minus discount -- you may add the extra features if you wish.

Step 3 ....................................................discount and payment Use the discount code HAPPY2018 to enjoy up to 30% discount of your total cost After this step, proceed to safe payment; you can checkout using your card or PayPal Please note we will send the complete paper to the email you will provide while registering. A copy will also be uploaded to your account

 

Question: How will I know when my paper is complete? or How will I get the complete Paper?

Answer: Once we are done with the paper, we will be uploaded to your account. A copy will also be sent to the email you registered with. We can guarantee you the following:- 1. Our service is private and confidential; we don't spam or share your contacts with anyone  2. The final paper will be plagiarism free. We will send a Turnitin Report to the email you registered with 3. At our company, willing to do free unlimited revisions until you are satisfied with your paper

Question:- Am a new client, How can I get the guarantee that the paper will be completed and sent to me before my deadline?

Answer: Thank you for expressing your concerns. We would love to have you as our loyal customer. We are certain if we do good work, you will come back for me. Besides, you will give us referrals to your friends and family. For that reason, we can’t fail to deliver your paper within your specified time frame. We will ensure we submit the paper on time so that you can have enough time to go through it, if you have problems with the paper delivered, you can request a free revision. You are entitled to as many revisions as you would wish until you get a paper that satisfies you

 

Useful Links That Will Help You Around

Link to new order   https://studentsolutionsusa.com/orders/stud/new

link to login page   https://studentsolutionsusa.com/orders/login

New user registration link   https://studentsolutionsusa.com/orders/register

Forgot Password https://studentsolutionsusa.com/orders/forgot/password

 

error: Content is protected !!