I need help with Excel for my ICS101 Class I will attach all the needed information below.

This activity requires students to submit a project that they have completed in the live Office Office 2013 environment. Students must download the starting files available below, and then follow the instructional steps to finish the project

 

Ofce 2013 – myitlab:grader – InstructionsGO - Excel Chapter 2: Homework Project 3InventoryProject Description:In the following project, you will edit a worksheet that summarizes the inventory of bulbs and treesat the Pasadena facility.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Start Excel. Download and open the ²le namedgo_e02_grader_h3.xls.02Change the Theme to Slice. Rename Sheet1 asBulbsand Sheet2 asTrees. Clickthe Bulbs sheet tab to make it the active sheet.33To the right o± column B, insert two new columns to create new blank columns Cand D. By using Flash Fill in the two new columns, split the data in column B into acolumn ±or Item # in column C and Category in column D. As necessary, typeItem#as the column title in column C andCategoryas the column title in column D.54Delete 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 tocolumns A:F.35Display the Trees worksheet, and then repeat Steps 3 and 4 on this worksheet.86Without grouping the sheets, make the ±ollowing calculation in both worksheets:• In cell B4, enter a ±unction to sum the Quantity in Stock data, and then applyComma Style with zero decimal places to the result.• In cells B5:B8, enter ±ormulas to calculate the Average, Median, Lowest, andHighest retail prices, and then apply the Accounting Number Format.97Without grouping the sheets, make the ±ollowing calculation in both worksheets:• In cell B10, enter a COUNTIF ±unction to determine how many di³erent types o±Tulipsare in stock on the Bulbs sheet and how many di³erent types o±Evergreensare in stock on the Trees worksheet.28Without grouping the sheets, make the ±ollowing calculation in both worksheets:• In cell G14, typeStock Level. In cell G15, enter an IF ±unction to determine theitems that must be ordered. I± the Quantity in Stock is less than75theValue_i±_true isOrder. Otherwise the Value_i±_±alse isOK. Fill the ±ormula downthrough all the rows.49Without grouping the sheets, apply the ±ollowing ±ormatting in both worksheets:• Apply Conditional Formatting to the Stock Level column so that cells that containthe textOrderare ±ormatted with Bold Italic with a Font Color o± Dark Blue, Text 2.Apply Gradient Fill Blue Data Bars to the Quantity in Stock column.4Updated: 03/07/20131E_CH02_GOV1_H3_Instructions.docx

Pasadena Facility: Inventory Status of BulbsAs of December 31Total Items in StockAverage PriceMedian PriceLowest PriceHighest PriceTulip TypesTulip Total Quan±tyQuan±ty in StockItem #/CategoryItem NameRetail PriceSize78 1239-Da²odilsExo±c10.9818"88 1265-Da²odilsBell Song7.4518"109 1285-DahliasHaley Jane8.5812"49 1296-Da²odilsYellow Hoop6.9818"175 1325-Da²odilsSplit Crown4.7518"128 1356-DahliasContessa7.8912"55 1365-Da²odilsJonquilla6.8918"165 1368-GladiolusBu³er´y Mix8.2525'136 1379-BegoniasFringed Mix12.9915"49 1389-DahliasDecora±ve Glory6.9812"222 1425-GladiolusMon Amour7.5825"56 1436-DahliasTopmix Yellow5.9512"165 1452-Da²odilsCampernella5.2518"123 1453-TulipsApeldoom Elite11.2510"89 1456-DahliasStars Lady8.5912"126 1456-BegoniasPendula Cascade9.8915"52 1456-CallasZantedeschia Mix10.9520"75 1463-Da²odilsManley7.8518"25 1465-TulipsGolds±ck9.5910"42 1465-DahliasTopmix Color7.5212"49 1468-CallasEllioµana White4.9920"52 1469-BegoniasMul±´ora9.8915"70 1478-Da²odilsNarcissa Mixed9.9818"129 1482-GladiolusNathalie16.5825"255 1482-GladiolusMorning Gold7.8525"75 1489-TulipsMaureen12.8510"135 1489-TulipsPurple Flag14.8510"75 1498-TulipsPassionate8.5910''

• 1495606455-go_e02_grader_h3.xlsx
• 1495606456-Assignment 2 specification.pdf

ComputerScienceExpert

(11)

Status NEW Posted 24 May 2017 06:05 AM My Price 11.00

-----------

Attachments

file 1495606457-Solutions file 2.docx preview (51 words )

H-----------ell-----------o S-----------ir/-----------Mad-----------am ----------- Th-----------ank----------- yo-----------u f-----------or -----------you-----------r i-----------nte-----------res-----------t a-----------nd -----------buy-----------ing----------- my----------- po-----------ste-----------d s-----------olu-----------tio-----------n. -----------Ple-----------ase----------- pi-----------ng -----------me -----------on -----------cha-----------t I----------- am----------- on-----------lin-----------e o-----------r i-----------nbo-----------x m-----------e a----------- me-----------ssa-----------ge -----------I w-----------ill----------- be----------- qu-----------ick-----------ly -----------onl-----------ine----------- an-----------d g-----------ive----------- yo-----------u e-----------xac-----------t f-----------ile----------- an-----------d t-----------he -----------sam-----------e f-----------ile----------- is----------- al-----------so -----------sen-----------t t-----------o y-----------our----------- em-----------ail----------- th-----------at -----------is -----------reg-----------ist-----------ere-----------d o-----------n -----------THI-----------S W-----------EBS-----------ITE-----------. ----------- Th-----------ank----------- yo-----------u -----------

Not Rated(0)

• Buy Answer