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 chapter 3 grader project g

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

Excel Chapter 2 Grader Project [Homework 3] (Project G)

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:

Top Essay Tutor
Write My Coursework
Writing Factory
Math Guru
Engineering Mentor
University Coursework Help
Writer Writer Name Offer Chat
Top Essay Tutor

ONLINE

Top Essay Tutor

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.

$48 Chat With Writer
Write My Coursework

ONLINE

Write My Coursework

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$43 Chat With Writer
Writing Factory

ONLINE

Writing Factory

I am an elite class writer with more than 6 years of experience as an academic writer. I will provide you the 100 percent original and plagiarism-free content.

$35 Chat With Writer
Math Guru

ONLINE

Math Guru

I have done dissertations, thesis, reports related to these topics, and I cover all the CHAPTERS accordingly and provide proper updates on the project.

$23 Chat With Writer
Engineering Mentor

ONLINE

Engineering Mentor

I am an academic and research writer with having an MBA degree in business and finance. I have written many business reports on several topics and am well aware of all academic referencing styles.

$19 Chat With Writer
University Coursework Help

ONLINE

University Coursework Help

I have written research reports, assignments, thesis, research proposals, and dissertations for different level students and on different subjects.

$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

Barn owl food web - Josephus problem c++ - Functional areas for nursing informatics - Notes payable due in six months are reported as - Shadow Health: Focused Exam: Cough Results - Nuffield a level physics - To determine the true cash balance - Schneider pm5350 modbus register - Uva ltac - ECON Forum Replies - Case Study - Km group of companies - A person should consume more of something when its marginal - What is a fact pattern - Fast food nation essay - Cfi lesson plan template - Jim cathcart fremantle arts centre - Verdant brink hero's choice chest - Why cell phones should not be allowed in school article - Error code 403 40316 - Exercise 12 1 indirect cash flow classification lo c1 - Nursing practice1 - Appeal to fear fallacy commercial - Moment curvature relationship in plastic analysis - A company's competitive strategy should - 9780078024795 pdf - Personal Statement - Example of an artifact that embodies ethical values - Sociocentric thinking - Business enterprise centre brisbane - Higher biology course specification - Monitoring toddlers and technology is a concern because - Type d adverse drug reactions - Pycnometer is used to determine - Informative speech critique example - Stagecoach x7 leicester to milton keynes - A service blueprint depicts - Aqua-glo 24 /61cm 20w t8 - In a certain region of space the electric potential is - Aged care training melbourne - The danger of a single story questions and answers - Industrial revolution quiz worksheet - Small business dismissal code - Basic rules of derivatives - Homework by helen simpson summary - Databases and Business Intelligence - A1 page size powerpoint - Nccih nih gov health herbsataglance htm - Coventry auto parts mandurah - Ethics in engineering 4th edition pdf - Case analysis - Mcdonalds station observation checklist - Api 20e quick index booklet - Prepare a 1-2-page double spaced journal entry in which you describe Skinner’s Radical Behaviorism. - Tata nano market segmentation - How to make beer's law plot on excel - How to add vice versa in a sentence - ITM Capstone week 8 - Inspire education training and assessment - Cinema audiences blink at the same time - Discussion - Apa citation aca code of ethics - Walt disney company mission and vision statement - Notes Breast Cancer - Help 1 - Grace dental group strathfield - Persuasive speech on tanning beds - A statistics professor asked her students - The basic patterns of the universe are spoken of in the confucian book of - Reasons why government intervene in business - Ringelmann effect in sport - University of ottawa political science - The out of control interview case study answers - Chapter 4 conducting marketing research and forecasting demand - What three words would you use to describe the raven - Excessive glycogen granules in liver - St joseph catholic church largo - Music2go - Woolworths annual report 2013 - Re b [1981] 2 nswlr 372 - The book thief ppt - Sophia introduction to statistics answers - Discussion - Linux - The investment detective case solutions - Penner medical products case study solution - Lizard virtual lab answer key - 101 lindeman road beerwah - Recrystallization of naphthalene from a mixed solvent lab report - Fingerprint basics science spot worksheet answers - Discussion - Lab 2 preparing a research report with a footnote - Nestle ice cream in cuba case study - Excel module 9 sam project 1 - What type of triangle has 2 congruent sides - Unit10AssignLdrshpSk - Electric field of a quadrupole - Ashford university psychology - Shell Corporation Discussion - Worksheet for identifying primary and secondary sources answers