Question: Set up as Excel Spreadsheet. Table fits on page 1. Apply Wrap Text as needed. Do not crowd or abbreviate words. Formula screen shot &

Set up as Excel Spreadsheet. Table fits on page 1. Apply Wrap Text as needed. Do not crowd or abbreviate words. Formula screen shot & chart fit on pg. 2. Apply monetary values, as below All numbers and words are black, 10 pt. TNR, unless noted. Formatting One Table Note: Enter information so that the upper left corner is cell Al 1. Center Title (Consolidated Shipping) in row 1 with 14 pt.; center Subtitle (Spring Order) in row 2 with 12 pt., both in bold white TNR (A1:H2); standard blue fill in Title/Subtitle rows; no line between rows. 2. Center, Middle-Align column titles in row 3; apply Heading 3; convert font back to 10 pt. TNR, bold (A3:H3); add single line border to bottom of row 3. Insert blank row below Totals' row. This remains blank 4. Use 'Total Cell Style' in Totals row; convert font back to 10 pt. TNR, bold 5. Vertical, single lines (A3:G14), and (B16:G18); horizontal 'minimum' lower cell border lines (A4:H12), and (A16:H17). 6. Single upper border in row for Lowest. 7. Row headings and values of Lowest, Highest, Average in bold 10 pt. TNR 8. Bold exterior border for entire table (A1:H18). Computation: Note-Use Absolute Cell Reference formula for computing Total insurance, Total Shipping 9. Total Value: multiply Quantity times Value 10. Total Insurance: 1.25% ofTotal Value 11. Total Shipping: multiply Total Value by 4.5% 12. Total Shipping&Insurance: Add Total Shipping and Total Insurance 13. Monetary: Accounting Format with S, commas, and 2 decimal places 14. Screen Shot: All formulation (with absolute cell references) must be shown on page 2. Do not write formulas and take screen shot of them. Chart: 15. Bar Chart of Total Shipping & Insurance categories exceeding $40,000. 16. Colors are your choice for Chart. Make sure categories and axes are labeled, as in done with ICW5. Use bold 10 pt. TNR Axes. 17. Title: 'Consolidated Shipping', 14 pt. bold TNR Results: write answers below chart 18. Which Craft Category had highest insurance? 19. Which Individual Craft cost the most to ship? 20. If a 45' Sailboat is ordered, how much would it cost, including Shipping&Insurance? Extra Credit: Given the answer found in Question 20, what is the % additional cost (Shipping & Insurance) to the Craft Value Cost

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

I got this big assignmnet for Quantitative methods for business i really need help Azimi, Hamida - azihy004 AH Share Comments Delete this page before submission Q-Constructions - building your future...

i want complete solution for my assignment and it should be without plagiarism COIT20274: Information Systems for Business Professionals, Term One 2016 Assignments 1 & 2 Requirements Assignment 1 -...

I know its a bit harsh but see if you can finish it in before tomorrow? thanks QUEENSLAND UNIVERSITY OF TECHNOLOGY QUT Business School School of Accountancy AYN416 Financial Accounting 1 Semester 2...

we work with excel here is the file she gave us to start working with! Member Problem 8 - Payroll Register (PAYROLL) Learning Objectives Prepare and use a payroll register for a sole proprietorship...

Hello wanted to know if someone could help me with an Excel assignment. Personal Budget Exercise - MS Excel Use the project description HERE to complete this activity. For a review of the complete...

Set Student Name: 1. Describe the relationship between two variables that have a correlation coefficient value: a. Near -1 b. Near 0 c. Near 1 2. Data was collected where a weightlifter was asked to...

Personal Budget Exercise - MS Excel Use the project description HERE to complete this activity. For a review of the complete rubric used in grading this exercise, click on the Assignments tab, then...

AH ? CGOP ... Document1 Home Insert Draw Design Layout References Mailings Review View ? Tell me Share Comments Calibri (Bo... v 12 A" A Aa Ap EEVEEVEE AaBbCcDdEe AaBbCcDdEe AaBbCcDc AaBbCcDdEE AaBb(...

Advertisements say that a new type of superball will rebound to 9/10 of its original height. If it is dropped from a height of 10 ft, how far, based on the advertisements, will the ball travel before...

James and Joanna Buckle are 40 years old and want to retire at age 60. Joanna works for the Federal government, which allows her to retire with a pension that will pay her $40,000 per year, indexed...

Explain the concept of aggregate operation planning framework of solar energy system.

magine you are a managerial accountant in charge of operations for an architectural firm whose work focuses on green building initiatives. To be consistent with the firm s principles, you propose...

1. Stephen M.R. Covey, author of The Speed of Trust, says that every employee in the organization should assume responsibility for building trust. Do you agree? Is this a realistic expectation?...

1. This chapter reveals that a persons needs serve as motivators toward achieving challenging goals. Analyze what you believe drives persons like Phelps, Cox, and Armstrong to achieve these extremes.

3. One of the books most powerful questions is What would you do if you were not afraid? As you look to your future and grasp the attitudes Spencer Johnson suggests, share your answer to that...