I don't know how to do these questions in the file attached. Could someone post the solutions for the excel file? the instructions are in the word file

 

Ofce 2013 – myitlab:grader – InstructionsExcel ProjectEXP ECH07 H3 - Greenwich Workshop 2.2Project Description:You are an analyst for an art gallery that is an authorized Greenwich Workshop Fne art dealer(www.greenwichworkshop.com). Customers in your area are especially fond of James C.Christensen’s art. You prepared a list of artwork: art, type, edition size, release date, issue price,and estimated market value. You want to identify highly sought-after pieces based on age,percentage of value increase, and sold-out status. In addition, you want to perform an advancedFlter and identify speciFc details from the Fltered data.Instructions:For the purpose o± grading the project you are required to per±orm the ±ollowing tasks:StepInstructionsPointsPossible1Openexploring_e07_grader_h3_Art.xlsxand save it asexploring_e07_grader_h3_Art_LastFirst.0.0002Make sure the Valuable worksheet is active and enter a nested logical function in the Comments columnto displayHighly Valuableif either condition is met:*The release date is on or before December 31, 1989, or*The sold-out status is Yes, the percentage increase in value is at least 500%, or the Edition Size wasless than 400.Enter an empty text string if the two conditions are not met.Hint: You will need to nest two logicalfunctions within the logical test argument. Use cell references to set all conditions. Copy the functiondown the column.12.0003In cell N8, enter a database function to count the number of highly valuable pieces of artwork indicatedin column K. Use the criteria in cells P2:P3 in your function.12.0004In cell N9, enter a database function to average the estimated values (Est. Value) of highly valuablepieces of artwork indicated in column K. Use the criteria in cells P2:P3 in your function.In cell N10, enter a database function to total the estimate values (Est. Value) of the highly valuablepieces of artwork indicated in column K. Use the criteria in cells P2:P3 in your function.12.0005Display the Database worksheet. Assign a range name calleddatabaseto the range A14:J178.10.0006Assign a range name calledCriteriato the range A7:J9.10.0007Create column labels for the Criteria range (in Row 7) by copying the labels from Row 14, and thenreplaceEdition Sizewith a secondRelease Datecolumn label (in E7).5.0008Set the following conditions in the Criteria range:*Sold-out limited-edition canvases (Yesin cell H8) released after1/1/2000(in E8) and before12/31/2003(in F8).*Sold-out limited-edition prints (Yesin cell H9) released after1/1/2000(in E9) and before12/31/2003(in F9).6.000Updated: 03/30/20161Current_Instruction.docx

A Christensen Character Cleverly Camoufaged3500Mar-00 $135$21559.3%A Lawyer More than Adequately ATred950May-98 $150Yes$1,530920.0%A Man and His Dog950Feb-99 $145Yes$26683.4%A Place o± Her Own250Aug-08 $525Yes$71035.2%A Place o± Her Own50Aug-08 $1,450Yes$2,22053.1%A²er Clouds, Sun (with Some³mes the Spirit ´ouches Us Porcelain)1950Aug-99 $275Yes$42052.7%All ´hat She Had450Dec-08 $395$61254.9%All the World's a Stage3000Sep-00 $225$31640.4%All the World's a Stage275Oct-00 $795Yes$1,03730.4%Angel Unaware250Oct-09 $295Yes$2950.0%Angel with Epaulet550Dec-06 $150Yes$17013.3%Angels o± My Village650Jan-07 $165$1777.3%Balancing Act3000Sep-95 $195Yes$2097.2%Benedic³on950Mar-98 $150Yes$779419.3%Cecelia250Aug-05 $995Yes$9950.0%Cecelia350Sep-05 $195Yes$635225.6%College o± Magical Knowledge4500Mar-93 $185Yes$744302.2%College o± Magical Knowledge (Remarque)500Mar-93 $425Yes$77582.4%Conversa³on Around FishSep-02 $20$200.0%Court o± the Faeries3500Oct-96 $245Yes$536118.8%Court o± the Faeries: Believer's Etching Edi³on1000Oct-96 $840$8632.7%Courtship375Sep-08 $495$69340.0%Dusk300Jan-04 $495$4950.0%Jonah850Oct-86 $95Yes$1,3031271.6%EdiTonSizeReleaseDateSoldOut%Increase

• 1495091317-EXP_ECH07_H3_-_Greenwich_Workshop_22_Instructions.docx
• 1495091317-Madarasz_exploring_e07_grader_h3_Art_START.xlsx

SuperTutor

(15)

Status NEW Posted 18 May 2017 07:05 AM My Price 9.00

-----------

Attachments

file 1495091320-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