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:StepPointsPossibleInstructions1 Start Excel. Download and open the file named e04_grader_H3.xlsx.0.0002 Convert the data to a table and apply Table Style Medium 5.5.0003 Sort the table by the Type in alphabetical order, and then by Release Date from newest to oldest.5.0004 Type Total Original Value in cell G1. In cell G2, enter a structured formula: If Edition Size is greaterthan 0, then multiply Edition Size by Issue Price; otherwise display an empty cell using “”. Format therange G2:G105 with Accounting Number Format with zero decimal places.12.0005 Delete the two rows containing Poster art types.7.0006 Turn on the table total row. Delete the total in cell G104. In cells C104 and E104, select the function thatshows the largest edition size and the most expensive issue price. Type Largest Edition Size andHighest Issue Price in cell A104.9.0007 Create a custom conditional format for the Issue Price range E2:E103, with these specifications:â¢4 Traffic Lights icon set (Black, Red, Yellow, Green)â¢Red icon when the number is greater than 1000 Numberâ¢Yellow icon when the number is less than or equal to 1000 and greater than 500 Numberâ¢Green icon when the number is less than or equal to 500 and greater than 250 Numberâ¢Black icon when the number is less than or equal to 250.10.0008 Filter the table by the Red Traffic Light conditional formatting icon.0.0009 Answer the first question below the worksheet data based on the filtered table. Type your answer in cellB107.5.000Updated: 04/18/20141Current_Instruction.docxStepPointsPossibleInstructions10 Answer the second question below the worksheet data based on the filtered table. Type your answer incell B108.5.00011 Answer the third question below the worksheet data based on the filtered table. Type your answer in cellB109.5.00012 Answer the fourth question below the worksheet data based on the filtered table. Type your answer incell B110.5.00013 Answer the fifth question below the worksheet data based on the filtered table. Type your answer in cellB111.5.00014 Set the column width for column A to 46.0. Select Landscape orientation, and set the scaling to fit thedata to 1 page.8.00015 Set 1-inch top and bottom margins. Set 0.3-inch left and right margins.6.00016 For column B, set the column width to 30. For columns C and D, set 8.5 column widths and apply WrapText.7.00017 Insert a footer with the text Exploring Series on the left side, the sheet name code in the center, and thefile name code on the right side.6.00018 Save the workbook. Close the workbook and then exit Excel. Submit the workbook as directed.0.000Total Points100.000
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.Read more
Each paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.Read more
Thanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.Read more
Your email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.Read more
By sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.Read more