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

Myitlab answers excel chapter 2

28/10/2021 Client: muhammad11 Deadline: 2 Day

Office 2013 – myitlab:grader – Instructions GO - Excel Chapter 2: Homework Project 3

Inventory

Project Description: In the following project, you will edit a worksheet that summarizes the inventory of bulbs and trees at the Pasadena facility.

Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Instructions Points Possible 1 Start Excel. Download and open the file named go_e02_grader_h3.xls. 0 2 Change the Theme to Slice. Rename Sheet1 as Bulbs and Sheet2 as Trees. Click the Bulbs sheet tab to make it the active sheet. 3 3 To the right of column B, insert two new columns to create new blank columns C and D. By using Flash Fill in the two new columns, split the data in column B into a column for Item # in column C and Category in column D. As necessary, type Item # as the column title in column C and Category as the column title in column D. 5 4 Delete column B. By using the Cut and Paste commands, cut column C—Category—and paste it to column G, and then delete the empty column C. Apply AutoFit to columns A:F. 3 5 Display the Trees worksheet, and then repeat Steps 3 and 4 on this worksheet. 8 6 Without grouping the sheets, make the following calculation in both worksheets: • In cell B4, enter a function to sum the Quantity in Stock data, and then apply Comma Style with zero decimal places to the result. • In cells B5:B8, enter formulas to calculate the Average, Median, Lowest, and Highest retail prices, and then apply the Accounting Number Format. 9 7 Without grouping the sheets, make the following calculation in both worksheets: • In cell B10, enter a COUNTIF function to determine how many different types of Tulips are in stock on the Bulbs sheet and how many different types of Evergreens are in stock on the Trees worksheet. 2 8 Without grouping the sheets, make the following calculation in both worksheets: • In cell G14, type Stock Level. In cell G15, enter an IF function to determine the items that must be ordered. If the Quantity in Stock is less than 75 the Value_if_true is Order. Otherwise the Value_if_false is OK. Fill the formula down through all the rows. 4 9 Without grouping the sheets, apply the following formatting in both worksheets: • Apply Conditional Formatting to the Stock Level column so that cells that contain the text Order are formatted with Bold Italic with a Font Color of Dark Blue, Text 2. Apply Gradient Fill Blue Data Bars to the Quantity in Stock column. 4 10 In the Bulbs sheet, format the range A14:G42 as a table with headers and apply Table Style Light 20. Insert a Total Row, filter by Category for Tulips, and then Sum the Quantity in Stock column. Record the result in cell B11. 6 11 Clear the filter from the table. Sort the table on the Item Name column from A to Z, remove the Total Row, and then convert the table to a range. On the PAGE LAYOUT tab, set Print Titles so that row 14 repeats at the top of each page. 6 12 In the Trees sheet, format the range A14:G42 as a table with headers and apply Table Style Light 19. Insert a Total Row, filter by Category for Evergreens, and then Sum the Quantity in Stock column. Record the result in cell B11. 6 13 Clear the filter from the table. Sort the table on the Item Name column from A to Z, remove the Total Row, and then convert the table to a range. On the Page Layout tab, set Print Titles so that row 14 repeats at the top of each page, and then Save your workbook. 6 14 Group the two worksheets. Merge and center the title in cell A1 across the range A1:G1 and apply the Title cell style. Merge and center the subtitle in cell A2 across the range A2:G2 and apply the Heading 3 cell style. Center the worksheets Horizontally, change the Orientation to Landscape, display the Print Preview, and then change the Settings to Fit All Columns on One Page. 7 15 In Backstage view, on the left click Save, and then click the Bulbs sheet tab to cancel the grouping. Click the Trees sheet tab, and then insert a new worksheet. Change the sheet name to Summary and then widen columns A:D to 23.57 width [170 pixels]. Move the Summary sheet so that it is the first sheet in the workbook. 4 16 In cell A1, type Pasadena Inventory Summary. Merge & Center the title across the range A1:D1, and then apply the Title cell style. In cell A2, type As of December 31 and then Merge & Center the text across the range A2:D2. Apply the Heading 1 cell style. 3 17 On the Bulbs sheet, Copy the range A4:A8. Display the Summary sheet and Paste the selection to cell A5. Apply the Heading 4 cell style to the selection. 2 18 In the Summary sheet, in cell B4, type Bulbs. In cell C4 type Trees. In cell D4 type Bulbs/Trees. Center the column titles, and then apply the Heading 3 cell style. 3 19 In cell B5, enter a formula that references cell B4 in the Bulbs sheet so that the Bulbs Total Items in Stock displays in B5. Create similar formulas to enter the Average Price, Median Price, Lowest Price, and Highest Price from the Bulbs sheet into the Summary sheet in the range B6:B9. 5 20 Enter formulas in the range C5:C9 that reference the Total Items in stock and the Average Price, Median Price, Lowest Price, and Highest Price cells in the Trees worksheet. 5 21 In cells D5, D6, D7, D8, and D9, insert Column sparklines using the values in the Bulbs and Trees columns. Format the sparklines using the styles in the first row as follows: D5: Sparkline Style Accent 1, Darker 50% D6: Sparkline Style Accent 2, Darker 50% D7: Sparkline Style Accent 3, Darker 50% D8: Sparkline Style Accent 4, Darker 50% D9: Sparkline Style Accent 5, Darker 50% 5 22 To the range B5:C5, apply Comma Style with zero decimal places, and to the range B6:C9, apply Accounting Number Format. Center the Summary worksheet Horizontally and change the Orientation to Landscape. 4 23 Insert a custom footer in the left section with the file name. Ensure that the worksheets are correctly named and placed in the following order in the workbook: Summary, Bulbs, Trees. Save and close the worksheet. Exit Excel. Submit the file as directed. 0 Total Points 100

Updated: 03/07/2013 1 E_CH02_GOV1_H3_Instructions.docx

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:

Homework Master
Smart Accountants
Study Master
Smart Tutor
Isabella K.
Academic Mentor
Writer Writer Name Offer Chat
Homework Master

ONLINE

Homework Master

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$50 Chat With Writer
Smart Accountants

ONLINE

Smart Accountants

I will be delighted to work on your project. As an experienced writer, I can provide you top quality, well researched, concise and error-free work within your provided deadline at very reasonable prices.

$30 Chat With Writer
Study Master

ONLINE

Study Master

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$26 Chat With Writer
Smart Tutor

ONLINE

Smart Tutor

I reckon that I can perfectly carry this project for you! I am a research writer and have been writing academic papers, business reports, plans, literature review, reports and others for the past 1 decade.

$35 Chat With Writer
Isabella K.

ONLINE

Isabella K.

As per my knowledge I can assist you in writing a perfect Planning, Marketing Research, Business Pitches, Business Proposals, Business Feasibility Reports and Content within your given deadline and budget.

$49 Chat With Writer
Academic Mentor

ONLINE

Academic Mentor

After reading your project details, I feel myself as the best option for you to fulfill this project with 100 percent perfection.

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

Trivial pursuit bet you know it argos - Et enterprises ltd uxbridge - What does young fortinbras want to do - Rather than strong work ethic a common attitude is - Harlan fiske stone scholar - Nickel and dimed chapter 1 quotes - Maternal and Child Health - Homework Question - Nova becoming human first steps - E vision anglia ruskin university - Reply to my peers - Psychology discussion - Angular distance and displacement - Benchmark research critiques and picot statement final draft - Block ciphers more closely emulate one-time pads. - Week 7 ethics discussions - How to change the theme to retrospect in excel - Literative - Lab report(psychology) spss - Need 1 Page - A-plus students - Define the term cliché penn foster - Nurse practitioner fnp cover letter - Piers harris 3 interpretation overview - Hacking into harvard case answers - Intervention/Delivery of Services Paper - Simple rail fence cipher program in c - Employee training and development noe 5th edition pdf - How Is Policy Formulated? - Port arthur isd pay scale - What is a home in fiction about - How to calculate royalty rate excel - St joseph's college mildura - Paper - Cobit 5 bai09 01 - Price pfister f wk1 68 - Report - Boeing turnover rate - Economics - The blue eyed brown eyed exercise answer key - Week 2 project - Bachelor of accounting curtin - 750 words: Select an organization that has a Global platform and describe the following. - Expectancy value theory definition - Sand and iron filings separation method - Delegation - The keeper of the bees 1925 first edition - The most notable self-imposed personal demand is probably: - Hey whipple squeeze this chapter 2 summary - Kathy schwalbe information technology project management eighth edition pdf - Amoeba sisters sex linked traits answers - Aqa a level physics data sheet - Prefix meaning for pre - 24 poems robert gray techniques - Iacra student pilot application - Hsu vtf 15h mk2 review - Chapter 14 long term liabilities example exam solutions - Different levels of market segmentation - Agcl + nh3 net ionic equation - I need two discussion questions 400 words min each with references. - Arnold prank calls drunk guy - Coming to an awareness of language malcolm x summary - THE TOP FIVE MOST ABUSED DRUGS - Advanced nursing (Due 24 hours) - Assignment 3 - How to make a circle in logo turtle - Week 3 Discussion - How to do g's secret mission - Teaching mood in literature - The main differences between informal and formal proposals are - Space exploration through social science lens - Steps for using an rss feed in ie mindtap - Experiment 2 measurement instruments mass volume density answers - Bailyn contagion of liberty - Principles of distributed database systems solution manual - Cie chemistry data booklet - Cell phones being allowed in school - Gunnersbury catholic school headteacher - Is nala simba's girlfriend - Signs of being in an abusive relationship quiz - Synchronous motor circuit diagram - +61 3 9028 7563 - Difference between isometric and oblique projection - What three ideals make up the project complexity triangle - Example of social history report - Physical measure method of allocating joint costs - Strategic audit worksheet example - Strategic management of coca cola - Input output model example - D2w1 - Risk management case study for students with solution - Phillips exeter academy admissions - Density of carbon tetrachloride - Who moved my cheese ppt free download - 190 x 45 joist span - Bentleigh gym virginia park - Assignment - Molar extinction coefficient symbol - Which of the following is not an organic compound - Why were motte and bailey castles built on hills