Milestone Activity: SALES AND INVENTORY ITEMS

Spreadsheet Applications 2022 Create and edit a basic financial spreadsheet by formatting data, cells, charts, etc.

You have reached a Milestone Activity! Please be sure you complete the Personalized Lesson above before continuing.

Milestone Activities are important stops along your educational journey to check your progress towards mastering the competency and to get feedback and guidance from your tutorial faculty. Please note: You must complete this Milestone Activity before moving on in this competency.

Milestones ask questions that touch upon concepts covered in previous Learning Activities and provide you with the opportunity to see concepts from the perspective of experts in the field, your tutorial faculty. This Milestone Activity is not graded and will not impact your score on your Final Assessment; however, your response must score a “Proficient” or “Exemplary” on each criterion, listed in the rubric below, in order to access and submit your Final Assessment.

To complete this Milestone Activity, read the question below and then provide your response in the comment box. In order to score a “Proficient” or “Exemplary”, your response must be thoughtful and substantive, and you must reference or cite content from this competency. Your tutorial faculty will use the rubric to determine if your post shows the depth of thought required to successfully complete this Milestone. Let’s get started!

SALES AND INVENTORY ITEMS

Download Data File: SC1 Data

SC1 Data File

Data File for Milestone Activity

xlsxSC1-Data%20%282%29.xlsx

A key activity for marketing professionals is to analyze projected sales and inventory information. This is especially important for retail environments. This exercise utilizes the skills covered in this chapter to analyze sales and inventory data.

1.     Open the file named SC1 Data and then Save As [name]SC1 Sales and Inventory (example: Dobbs SC1 Sales and inventory)

2.     In the Sheet1 worksheet, enter the word Totals in cell C14.

3.     Format all the cells in Sheet1 to Century font style and a 12-point font size.

4.     Set the column width for Columns A through G to 13.5.

5.     Edit the entry in cell B2 to read “Item Number.”

6.     Use AutoFill to fill the Item Numbers from B3 into the range B4:B13.  The item numbers should increase by one as they are filled through the range.

7.     Copy the contents of cell A3 and paste them into the range A4:A8.

8.     Delete Column F.

9.     Format the range A1:F2 so the text is Bold.

10.  Set the alignment in the range A2:F2 to Wrap Text.

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 workbook.

32.  Submit the workbook as directed by your instructor.

PLEASE SUBMIT THE SPEADSHEET BACK AS AN ATTACHMENT

• 1683200158-SC1-Data 2.xlsx

SmartExpert

(118)

Status NEW Posted 04 May 2023 11:05 AM My Price 10.00

Spr-----------ead-----------she-----------et -----------App-----------lic-----------ati-----------ons----------- 20-----------22 -----------Cre-----------ate----------- an-----------d e-----------dit----------- a -----------bas-----------ic -----------fin-----------anc-----------ial----------- sp-----------rea-----------dsh-----------eet----------- by----------- fo-----------rma-----------tti-----------ng -----------dat-----------a, -----------cel-----------ls,----------- ch-----------art-----------s, -----------etc-----------.-----------

Attachments

file 1683200168-Answer SC1 Sales and inventory.xlsx preview (15 words )

It-----------emP-----------ric-----------eSa-----------les----------- in----------- Un-----------its-----------Inv-----------ent-----------ory----------- in----------- Un-----------its-----------Sho-----------rts-----------Boo-----------tsT------------Sh-----------irt-----------sSa-----------nda-----------lsS-----------wea-----------ter-----------sTa-----------nk -----------Top-----------sSw-----------eat-----------shi-----------rts-----------Sea-----------son-----------Hat-----------sPo-----------lo -----------Shi-----------rts-----------Jac-----------ket-----------sSc-----------arf-----------sA1-----------500-----------Fal-----------l 2-----------018-----------Spr-----------ing----------- 20-----------19T-----------OTA-----------LSI-----------tem----------- Nu-----------mbe-----------rA1-----------501-----------A15-----------02A-----------150-----------3A1-----------504-----------A15-----------05A-----------150-----------6A1-----------507-----------A15-----------08A-----------150-----------9A1-----------510-----------Sta-----------tus----------- Re-----------por-----------t S-----------ale-----------s a-----------nd -----------Inv-----------ent-----------ory----------- by----------- It-----------em -----------

Not Rated(0)

• Buy Answer