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 project a

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.

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:

Top Rated Expert
Quality Assignments
Engineering Help
Financial Solutions Provider
Homework Master
Premium Solutions
Writer Writer Name Offer Chat
Top Rated Expert

ONLINE

Top Rated Expert

I have read and understood all your initial requirements, and I am very professional in this task.

$41 Chat With Writer
Quality Assignments

ONLINE

Quality Assignments

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

$39 Chat With Writer
Engineering Help

ONLINE

Engineering Help

I have read and understood all your initial requirements, and I am very professional in this task.

$43 Chat With Writer
Financial Solutions Provider

ONLINE

Financial Solutions Provider

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

$15 Chat With Writer
Homework Master

ONLINE

Homework Master

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

$28 Chat With Writer
Premium Solutions

ONLINE

Premium Solutions

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

$21 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

PSY 361 -2 - The jessica banks case - Rinnai solar 20 pilot light - Managing a quality service - Cash cow win page - Cambridge lawn tennis club membership - A researcher conducts an independent measures two factor study - Turbine blades mounted to a rotating disc - Vaccines - Literary devices in bohemian rhapsody - Basic Stat HW Ch 7 - World War 2 - Hard candy tattoo helper utah - Speelman v bellingham - Perth demons football club - Sociology 4 - Chateau margaux launching the third wine case analysis - What was the ghazu what was the ummah - Crieff to comrie bus - Which word is the predicate nominative in this sentence - What was not a cause of the great depression - Are you done with your assignment - 300 words..APA format - Sexual harassment workplace authority and the paradox of power - Chapter 17 managing business finances worksheet answers - Eth 321 week 1 alternative dispute resolution - Item total correlation spss - Advantages of radio waves - Oo de lally banjo tab - One – Group Assessment - Essay completion - Bottled water should not be banned - Speech - Adjustment letter in business communication - Gatsby chapter 1 quotes - Not a homework - Diversity always involves course hero - Joint form of general conditions - Cyber security naics code - Colour of sodium bicarbonate on ph paper - Explain the ethical and social implications of offshoring - Dr wei ning huang - How to critique a theoretical framework - Alphabet symmetry worksheet answers - The australian shipowners association - Suppose that a small town has seven burger shops whose respective shares of the local hamburger - I too sing america annotations - Nasm assessment chart - Bacp accreditation criteria 6 - VT #4 - 1628 jasmine drive schertz tx - Strategic management text & cases 9th edition - Complete the external environmental scan for your organization - Cloud Computing - Explain how built in stabilizers work - Fall of humanity then and now worksheet - What does literature offer an individual - What is transactional processing system - Huckleberry ridge ash bed - Textile industry project cost - Renunciation of probate victoria - Cessna 208b grand caravan price - Gamescape week 2 answers - Zimra rtgs banking details - Weeko 1 res - Explain why a linear function may not be adequate for describing the supply and demand functions. - Wikisummary - A rush to judgement case study answers - Took the children away book - 4page essay -hdjskc - How many pounds are in one ton - Mk commando socket outlets - Formal analysis example - DRI - Static muscular endurance test - After an entry in the medical record has been written or keyed and an error is discovered - Ethical Stories - How to find outliers in jmp - Thursford christmas show 2016 - Team performance productivity and rewording teamwork - Whole foods market financial ratios - Ib online curriculum centre - Bedford hospital children's outpatients - Essays Guru only - Dis - How to monitor ssas cube processing - Matt kroc bench press - Simple presentation evaluation form - A tale of two cities book 3 chapter 3 - BE CS7 - Eyfs learning goals 2014 - Career day activities for kindergarten - Shark tank season 9 episode 2 stream - Presentation Work - The navajo origin legend - Comparation/ Constrast Essay - Get help with java homework - Which of the following statements regarding fixed costs is incorrect - Hospital case mix index calculation - POWERPOINT