Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel module 2 sam exam answers

02/05/2021 Client: muhammad11 Deadline: 2 Day

Author: Note: Do not edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from SAM website. Shelly Cashman Excel 2016 | Module 2: SAM Project 1a Rough Stitch Clothing FORMULAS, FUNCTIONS, AND FORMATTING Faisal Alazaima edit this sheet. If your name does not appear in cell B6, please download a new copy of the file from the SAM website. Rough Stitch Clothing Sales Department Women's Men's Children's Babies' Total Average Highest Lowest 2018 150,200 123,615 85,680 75,000 2019 88,600 47,100 15,417 40,300 2020 125,000 114,580 74,250 62,358 2021 178,956 145,698 105,600 86,400 2020 125,340 45,600 70,200 1,680 242,820 2021 168,950 52,350 70,200 2,050 293,550 Expenses Items Cost Payrol Rent Other Total $ 2018 148,500 52,689 68,900 15,230 285,319 $ 2019 79,850 42,350 70,200 12,364 204,764 $ $ Profit 2018 Amount 2019 2020 2021 Employee Name Stephanie Michaelski Maria Angeles Jayson Ellerbee Lily Minamoto Lauren Ramirez Last updated Employee Discount Listing Department Dept Code Women's 010 Women's 010 Men's 021 Children's 034 Babies' 043 Friday, March 9, 2018 Employee ID SM-WO-010 Hiring Date Discount 1/20/2021 0.05 2/5/2018 0.22 3/7/2019 0.18 5/8/2018 0.22 7/15/2018 0.22 Shelly Cashman Excel 2016 | Module 2: SAM Project 1a Rough Stitch Clothing FORMULAS, FUNCTIONS, AND FORMATTING GETTING STARTED • Open the file SC_EX16_2a_FirstLastName_1.xlsx, available for download from the SAM website. • Save the file as SC_EX16_2a_FirstLastName_2.xlsx by changing the “1” to a “2”. o • If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically. With the file SC_EX16_2a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. o If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS 1. You are an assistant manager at Rough Stitch Clothing, a boutique clothing store. The store owner has asked you to generate a report detailing the financials of the store from 2018 to 2021 and, at the same time, format the store’s staff list. Switch to the Profit Analysis worksheet and apply the Office theme to the workbook. 2. 3. Update the column and row sizes in this worksheet as described below: a. Change the width of column A to 15.00. b. Apply AutoFit to row 1, so that the row height best fits the content it contains. In cell B9, create a formula using the SUM function to total the values in the range B5:B8 to determine the total sales in 2018 across all departments. Copy the formula you just created in cell B9 to the range C9:E9 to calculate the total sales for the following three years. 4. Format the range B9:E9 using the Accounting number format with zero decimal places and $ as the symbol. (Hint: Depending on how you complete this action, the number format may appear as Custom instead of Accounting.) 5. Change the fill color of the range A9:E9 to Yellow (4th column, 1st row of the Standard Colors palette). 6. Apply a Top and Thick Bottom Border cell border to the range A9:E9. Shelly Cashman Excel 2016 | Module 2: SAM Project 1a 7. You want to calculate some business statistics (average, highest, and lowest sales figures) from each year across all departments. In cell B10, create a formula using the AVERAGE function to calculate the average sales figure across all departments (as shown in the range B5:B8) in 2018. Using the Fill Handle, copy the formula you just created in cell B10 to all cells in the range C10:E10. 8. In cell B11, create a formula using the MAX function to determine the highest sales figure across all departments (as shown in the range B5:B8) in 2018. Copy the formula you just created in cell B11 to the range C11:E11. 9. In cell B12, create a formula using the MIN function to determine the lowest sales figure across all departments (as shown in the range B5:B8) in 2018. Copy the formula you just created in cell B12 to the range C12:E12. 10. You need to determine the profit generated each year across all departments. In cell B22, create a formula without using a function that subtracts the total expenses for 2018 (cell B19) from the total sales for 2018 (cell B9). Copy the formula you created in cell B22 to the range C22:E22. 11. You want to visually highlight any year with a loss (i.e., a negative profit). Apply a conditional formatting rule to the range B22:E22 as described below: 12. 13. a. Use the New Rule option. [Mac Hint: In the "New Formatting Rule" dialog box, select "Classic" from the Style list drop-down box.] b. Select the Rule type Format only cells that contain. c. Change the Rule Description to format only cells with a cell value of less than 0 with a Red fill color (2nd column, 1st row of the Standard Colors palette). Modify the worksheet format as described below: a. Change the page orientation of the worksheet to Portrait. b. Change the margins to Narrow. Add a header to the worksheet, and then enter Rough Stitch Clothing Profit Analysis in the center section. Return to Normal View. 14. Click on cell A1, and then check the Spelling to identify and correct any spelling errors on the worksheet. (Hint: You should find and correct at least one spelling error.) 15. Switch to the Employee Discount worksheet. Rough Stitch Clothing offers employees discounts based on how long an employee has worked at the store. All employees forgot to enter their employee IDs, so you need to input this information. The ID of an employee consists of the first letter of his/her first name and last name together followed by a dash, the first two letters of the department followed by a dash, and the department code. Shelly Cashman Excel 2016 | Module 2: SAM Project 1a For instance, in cell D4, enter the text MA-WO-010. Select the range D3:D7, and then use Flash Fill to fill the range.

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

Peter O.
Professional Accountant
Professional Coursework Help
Assignment Hut
Instant Assignment Writer
Fatimah Syeda
Writer Writer Name Offer Chat
Peter O.

ONLINE

Peter O.

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$43 Chat With Writer
Professional Accountant

ONLINE

Professional Accountant

I have read your project details. I can do this within your deadline.

$42 Chat With Writer
Professional Coursework Help

ONLINE

Professional Coursework Help

I have read your project details. I can do this within your deadline.

$43 Chat With Writer
Assignment Hut

ONLINE

Assignment Hut

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$31 Chat With Writer
Instant Assignment Writer

ONLINE

Instant Assignment Writer

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$37 Chat With Writer
Fatimah Syeda

ONLINE

Fatimah Syeda

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$48 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Social psychology 9th edition pdf aronson - Assignment #090 - Evaluate the elements of critical thinking (evidence, reasoning, fallacy) - Mona lisa mona lisa men have named you - Discussion Question 100 words - Written Assignment(follow the attached file) - Order 2316287: art appreciation - Written assignment - Capital budgeting examples with solutions pdf - Reduce similarities - The public sphere worksheet answers - Climate of doubt discussion questions - Cosine compound angle formula - What is a teaching philosophy statement samples - Scraped away eroded crossword clue - Discussion Question - Leadership Skills & Development Plan - Cowarra park preschool & long day care - Readings in the western humanities 7th edition - Wimpey no fines wall thickness - Web services ppt slideshare - Rams direct debit form - Topic 1: Genetic Inheritance and Mutation - Spiral model risk management - 479 kj to calories - What's the matching principle in accounting - A Pay Model - Acids and alkalis for year 7 - Information systems - Camping near mt kosciuszko - Cima late exam entry - Human communication in society 4rd ed alberts nakayama and martin - Cite your sources using apa format week 5 assignment - Positive and negative aspects of a magnificent catastrophe - Due tomorrow - Cidb malaysia contractor grading table - Creswell chapter 7 data collection - Bach stradivarius trumpet serial numbers - Smart parking space app - Expressed arguments in the media - New york times kfc ghana - Chem skills worksheet 10 percent error - Can technology save sears case study answers - Northern general hospital sheffield chesterman wing - Principles of management charles wl hill pdf - 4 8 12 16 sequence - Armfield distillation column - What is the magnitude of the electron's acceleration - Rabbit proof fence gracie - Leaf cross section labeled - AstroloGy bAbA 7340613399 OnLinE reaL VashIKaraN sPecIaLIsT IN Satara - Alfred ledger solicitors rochdale - Unit 7 business law assignment - Mindtools com pages article leadership style quiz htm - Townsendpress.net sign in - Premier's reading challenge booklist sa - The redstockings manifesto - Ancient egyptian garden design - Security Assessment - Macbeth study guide questions act 1 - Assigment: framework health system with brief presented als poster - Intermediate accounting chapter 23 statement of cash flows solutions - The true benefit of using an array lies in your ability to use a ____ as a subscript to the array. - Removing acrylics with acetone - Lpkf pcb milling machine - Science and Engineering Practices and Science Process Skills Presentation - Mha/ 516 - Sci 207 week 3 lab - Are there few or many nuclei at the end plate - What pricing strategy does bentley motors use - 4/19 vicars avenue north bondi - EASY ENGLISH 1302 ASSIGNMENT - New Works 08/10 - Resistor color code experiment report - Project management case study answers - Belbin team roles test questionnaire free - Five most important elements of tco - Devilbiss 525ks oxygen concentrator - Discussion for business organization - Essay - Student exploration mouse genetics one trait answer key pdf - Principles of magnetic resonance imaging a signal processing perspective pdf - 23.3 sponges and cnidarians study guide answers - Captured lives australia's wartime internment camps - Which method of computing net cash provided by operating activities does apple use? - CHCCCS025 - Support relationships with carers and families - Lizard evolution virtual lab student handout answer key - Identifying Variables - Ratio of carbon hydrogen and oxygen in lipids - Feasibility Study Paper - Hospital for surgical excellence of oakbend health system - Serving in florida barbara ehrenreich thesis - Assignment #1: Research Specialty Care Paper .Rubric attached - At green mountain the company is departmentalized by - Queen mary dentistry admissions - Square root of 18 - Words with the suffix mony - Implement a hexadecimal calculator for iOS. - Determination of solubility product of calcium hydroxide - Edps video surveillance guidelines