#4 I'm having problems with if functions, help. I'm not really sure on where it says display empty cell using ""

Art A Lawyer More than Adequately Attired in Fine Print A Place of Her Own A Place of Her Own All That She Had Angel Unaware Angel Unobserved Angel with Epaulet Angels of My Village Arise and Shine Forth Arise and Shine Forth Benediction Benediction Cecelia Cecelia Conversation Around Fish Courtship Dusk Faith, Hope and Charity Faith, Hope and Charity Faith, Hope and Charity False Magic Finding Your Fish Fiona Fiona First Rose Garden Rendezvous Garden Rendezvous Guardian in the Woods Guardian in the Woods Hold to the Rod, the Iron Rod Hold to the Rod, the Iron Rod If Pigs Could Fly Isabella Isabella Jonah Lawrence Pretended Not to Notice That A Bear Had Become Madonna with Two Angeles framed Man Taking a Leek on a Tiled Wall for a Walk Men and Angels Men and Angels Monarch of All He Surveys Monarch of All He Surveys Music of Heaven Olde World Santa Once Upon a Time One Light Outside the Box Parables Passage by Faith Passage by Faith Pilates Pilgrim Angel Poofy Guy on a Short Leash Poofy Guy on a Short Leash Portrait with Red Berries Portrait with Red Berries Princess in the Tower Resistance Training Saint with White Sleeves Saint with White Sleeves Shakespearean Fantasy Shakespearean Fantasy Sleeper Lost in Dreams Sleeper Lost in Dreams Sometimes the Spirit Touches Us Through Our Weaknesses St. Brendan The Navigator St. Brendan The Navigator St. Nicholas of Myra Tempus Fugit Ten Lepers Ten Lepers The Beggar Princess and the Magic Rose The Blind Leading the Blind The Blind Leading the Blind The Bride The Bride The Burden of the Responsible Man The Chess Match The Chess Match The Enoch Altarpiece framed The Golden Ball The Listener The Listener The Messenger The Nest The Oldest Angel The Pink Ribbon The Responsible Woman The Return of the Fablemaker The Return of the Fablemaker The Rich Young Ruler The Royal Processional The Tie That Binds The Tie That Binds The Yellow Rose Three Wise Men in a Boat Touching the Hem of God Touching the Hem of God Twilight Twilight Two Sisters Virtue We Three Kings We Three Kings Analysis for Most Expensive Art 1. What was the largest issue size? 2. How many pieces are some sort of "Masterwork"? 3. How many pieces are not sold out? 4. Which piece had the highest issue price? 5. What type of art was the highest issue price piece? Type Anniversary Edition Canvas Limited Edition Canvas Masterwork Canvas Edition Limited Edition Canvas Limited Edition Canvas Smallwork Canvas Edition Limited Edition Canvas Limited Edition Print Masterwork Canvas Edition Poster Anniversary Edition Canvas Masterwork Anniversary Edition Limited Edition Print Masterwork Canvas Edition Poster Limited Edition Canvas Limited Edition Canvas Limited Edition Canvas Limited Edition Print Masterwork Canvas Edition Limited Edition Canvas Smallwork Canvas Edition Limited Edition Canvas Limited Edition Print Smallwork Canvas Edition Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Canvas Limited Edition Print Anniversary Edition Canvas Anniversary Edition Canvas Limited Edition Canvas Smallwork Canvas Edition Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Print Limited Edition Canvas Anniversary Edition Canvas Edition Size Release Date Issue Price 250 Sep-12 $ 475 250 Aug-08 $ 525 50 Aug-08 $ 1,450 450 Dec-08 $ 395 250 Oct-09 $ 295 350 Mar-10 $ 225 550 Dec-06 $ 150 650 Jan-07 $ 165 25 Mar-12 $ 1,250 Apr-12 $ 20 300 Jul-10 $ 495 50 Jul-10 $ 995 350 Sep-05 $ 195 250 Aug-05 $ 995 Sep-02 $ 20 375 Sep-08 $ 495 300 Jan-04 $ 495 275 Jul-02 $ 695 550 Jul-02 $ 185 100 Jul-02 $ 1,850 375 Apr-08 $ 225 375 Oct-09 $ 225 400 Sep-07 $ 495 450 Sep-07 $ 165 250 Apr-09 $ 195 Jun-02 $ 695 Jun-02 $ 185 200 Jun-12 $ 395 250 Jun-12 $ 195 550 Jun-07 $ 295 1820 Jan-12 $ 175 350 Jan-06 $ 325 375 Oct-03 $ 395 750 Oct-03 $ 150 450 Apr-10 $ 425 501 May-08 $ 525 375 Jun-05 $ 595 450 Aug-12 $ 195 350 Sep-06 $ 375 550 Sep-06 $ 135 250 Jan-02 $ 325 750 Jan-02 $ 135 450 Oct-07 $ 225 375 Oct-02 $ 395 Sold Out Yes Yes Yes Yes Yes Limited Availability Limited Availability Yes Yes Limited Availability Yes Yes Limited Availability Yes Yes Yes Yes Yes Limited Availability Yes Yes Limited Availability Yes Yes Yes Yes Yes Masterwork Anniversary Edition Anniversary Edition Canvas Limited Edition Canvas Masterwork Anniversary Edition Limited Edition Canvas Limited Edition Print Smallwork Canvas Edition Smallwork Canvas Edition Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Canvas Limited Edition Canvas Limited Edition Print Limited Edition Canvas Masterwork Canvas Edition Limited Edition Canvas Limited Edition Print Anniversary Edition Canvas Limited Edition Canvas Limited Edition Print Limited Edition Canvas Smallwork Canvas Edition Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Print Anniversary Edition Canvas Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Canvas Limited Edition Canvas Limited Edition Print Limited Edition Print Limited Edition Canvas Anniversary Edition Canvas Limited Edition Canvas Anniversary Edition Canvas Limited Edition Canvas 300 250 325 75 250 250 350 250 300 650 350 550 250 550 300 550 250 150 150 550 550 275 650 450 450 200 550 650 550 450 175 450 600 300 500 250 275 175 350 200 200 350 250 450 125 Mar-04 May-12 Feb-09 Dec-09 Nov-12 Nov-12 Oct-10 Mar-12 Aug-04 Aug-04 Jun-03 Jun-03 Oct-12 Apr-07 Mar-05 Mar-05 May-11 May-11 Jan-03 Jan-03 Aug-09 Jan-04 Jan-04 Aug-04 Apr-10 Oct-02 Sep-02 Mar-07 May-07 May-07 May-05 May-05 Nov-07 Feb-11 Feb-11 Jun-04 Sep-10 Mar-06 Mar-06 Jun-04 Sep-11 Nov-10 Oct-05 Aug-06 Aug-09 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 1,750 245 595 995 475 165 275 225 495 160 295 135 245 295 395 150 495 950 295 135 295 250 140 260 195 650 185 395 550 165 475 145 425 695 225 1,595 325 650 195 775 495 395 250 650 495 Yes Limited Availability Limited Availability Limited Availability Yes Yes Yes Yes Limited Availability Yes Yes Yes Yes Limited Availability Yes Limited Availability Yes Yes Yes Limited Availability Yes Yes Yes Yes Yes Limited Availability Limited Availability Yes Masterwork Canvas Edition Limited Edition Canvas Masterwork Anniversary Edition Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Canvas Limited Edition Canvas Limited Edition Print Limited Edition Canvas Limited Edition Print Anniversary Edition Canvas Limited Edition Canvas Limited Edition Canvas Limited Edition Print 25 550 215 250 550 250 250 475 750 300 550 200 550 450 950 Aug-09 Mar-08 Jan-05 Feb-10 Feb-10 May-09 Nov-11 Mar-03 Mar-03 Oct-04 Oct-04 Mar-12 Jan-08 Sep-03 Sep-03 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 995 545 1,250 750 250 495 295 650 185 495 160 695 525 695 160 Yes Limited Availability Yes Limited Availability Yes Yes Yes Limited Availability Limited Availability Office 2013 - myitlab:grader - Instructions Excel Project EXP ECH04 H3 - Artwork 2.2 Project Description: You work for a gallery that is an authorized Greenwich Workshop fine art dealer (www.greenwichworkshop.com). Customers in your area are especially fond of James C. Christensen's art. Although customers can visit the Web site to see images and details about his work, they have requested a list of all his artwork. Your assistant prepared a list of artwork: art, type, edition size, release date, and issue price. In addition, you included a column to identify what pieces are sold out at the publisher, indicating the rare, hard-to-obtain artwork that is available on the secondary market. You now want to convert the data to a table so that you can provide information to your customers. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step 1 2 3 4 5 6 Points Possible Instructions Start Excel. Download and open the file named e04_grader_H3.xlsx. 0 Convert the data to a table and apply Table Style Medium 5. 5 Sort the table by the Type in alphabetical order, and then by Release Date from newest to oldest. 5 Type Total Original Value in cell G1. In cell G2, enter a structured formula: If Edition Size is greater than 0, then multiply Edition Size by Issue Price; otherwise display an empty cell using "". Format the range G2:G105 with Accounting Number Format with zero decimal places. Delete the two rows containing Poster art types. 7 Turn on the table total row. Delete the total in cell G104. In cells C104 and E104, select the function that shows the largest edition size and the most expensive issue price. Type Largest Edition Size and Highest Issue Price in cell A104. 8 Create a custom conditional format for the range E2:E103 using the 4 Traffic Lights icon set (Black, Red, Yellow, Green). Edit the rule so that the red icon displays when the number value is greater than or equal to 1000; the yellow icon displays when the number value is less than 1000 and greater than or equal to 500; the green icon displays when the number value is less than 500 and greater than or equal to 250; and the black icon displays when the value is less than 250. Be sure to change the Type to Number before setting the rule for each icon. Filter the table by the Red Traffic Light conditional formatting icon. Note from Instructor: Don't skip this just because it is not worth any points, it will cause errors in other areas. 9 Answer the first question below the worksheet data based on the filtered table. Type your answer in cell B107. 7 Updated: 01/21/2015 12 1 9 10 0 5 Current_Instruction.docx Office 2013 - myitlab:grader - Instructions Step Excel Project Points Possible Instructions 10 Answer the second question below the worksheet data based on the filtered table. Type your answer in cell B108. 5 11 Answer the third question below the worksheet data based on the filtered table. Type your answer in cell B109. 5 12 Answer the fourth question below the worksheet data based on the filtered table. Type your answer in cell B110. 5 13 Answer the fifth question below the worksheet data based on the filtered table. Type your answer in cell B111. 5 14 Set the column width for column A to 46.0. Select Landscape orientation, and set the scaling to fit the data to 1 page. 8 15 Set 1-inch top and bottom margins. Set 0.3-inch left and right margins. 6 16 For column B, set the column width to 30. For columns C and D, set 8.5 column widths and apply Wrap Text. 7 17 Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and the file name code on the right side. 6 18 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed. 0 Total Points Updated: 01/21/2015 2 100 Current_Instruction.docx