Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1 1 . Prepare A 1 :F 1 for the title text by changing the fill color of the cells in the range A 1

11. Prepare A1:F1 for the title text by changing the fill color of the cells in the range A1:F1 to Red, Accent 2, Darker 25%.
12. Make the following font changes to the range A1:F1: set the font color to white, add italics, and set the font size to 14.
13. Merge and center the cells in the range A1:F1.
14. Enter the title for this worksheet in the range A1:F1. The title should appear on two lines. The first line should read Status Report. The second line should read Sales and Inventory by Item.
15. Increase the height of Row 1 so the entire title is visible.
16. Format the values in the range C3:C13 with dollar signs and two decimal places.
17. Format the values in the range E3:F13 with comma style, zero decimal places.
18. In cell E14, use AutoSum to calculate the sum of the values in the range E3:E13.
19. In cell F14, use AutoSum to calculate the sum of the values in the range F3:F13.
20. Apply All Borders to the range A1:F14.
21. Add a thick bottom border to row 2; add a thick bottom border to row 13.
22. Add a thick line border around the perimeter of the range A1:F14.
23. Insert a new blank worksheet in the workbook (this will be Sheet4).
24. Delete Sheet3.
25. Move Sheet4 ahead of Sheet2 so the order of the worksheets is Sheet1, Sheet4, and Sheet2.
26. Rename the Sheet1 worksheet tab to Status Report.
27. Change the orientation of the Status Report worksheet so it prints landscape instead of portrait.
28. Add a header to the Status Report worksheet that shows the date (needs to update) in the upper left corner and your name in the center.
29. Add a footer to the Status Report worksheet that shows the page number in the lower right corner with the word Page before the number.
30. Center the worksheet both horizontally and vertically on the sheet.
31. Check the spelling of the worksheet and make any necessary changes. Save the SC1 Sales and Inventory workbook.
32. Submit the SC1 Sales and Inventory workbook as directed by your instructor.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Practical Database Programming With Visual Basic.NET

Authors: Ying Bai

1st Edition

0521712351, 978-0521712354

More Books

Students also viewed these Databases questions