You are an analyst for an art gallery that is an authorized Greenwich Workshop fine art...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
You are an analyst for an art 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. 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, percent- age of value increase, and sold-out status. In addition, you want to apply an advanced filter and identify specific details from the filtered data. a. Open e07m2Art and save it as e07m2Art_LastFirst. b. Make sure the Valuable worksheet is active and enter the YEARFRAC function in cell G2 to calculate the number of years from the release date and the date in cell Q2. Use relative and mixed references correctly. Format the value with Comma Style with one decimal place. Copy the function to the range G3:G165. c. Enter a nested logical function in cell L2 to display Highly Valuable if either condition is met: . The release date is on or before December 31, 1989, or • The sold-out status is Yes and the percentage increase in value is at least 500% and the Edition Size was less than 400. Enter an empty text string if the conditions are not met. Hint: You will need to nest two logical functions within the logical test argument. Use cell references to the two conditions. d. Copy the function from cell L.2 to the range L3:165. e. Click cell 010 and enter the database function to count the number of art pieces where the comment is Highly Valuable. The criteria range is located in the range N6:N7. f. Click cell 011 and enter the database function to calculate the average of art pieces where the comment is Highly Valuable. The criteria range is located in the range N6:N7. g. Click cell 012 and enter the database function to calculate the total estimated value of art pieces where the comment is Highly Valuable. The criteria range is located in the range N6:N7. h. Display the Database worksheet. Assign a range name called database to the range A14:J178. Assign a range name called Criteria to the range A7:19. i. Create column labels for the criteria range and replace the Edition Size with a second Release Date column label. Set the following conditions in the criteria range: . Sold-out limited-edition canvases released after 1/1/2000 and before 12/31/2003 Sold-out limited-edition prints released after 1/1/2000 and before 12/31/2003 . j. Create an advanced filter using the database list and criteria range. Filter the records in place. k. Enter the appropriate database function in cell C2 in the Summary Statistics area to calculate the highest estimated value of the filtered records. Apply Currency format and left-align the value. 1. Enter a nested function using INDEX and MATCH to display the title (in cell C3) and the release date (in cell C4) for highest estimated valued filtered artwork. Left-align and format the date. m. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side on each worksheet. n. Save and close the file. Based on your instructor's directions, submit e07m2 Art_LastFirst. You are an analyst for an art 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. 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, percent- age of value increase, and sold-out status. In addition, you want to apply an advanced filter and identify specific details from the filtered data. a. Open e07m2Art and save it as e07m2Art_LastFirst. b. Make sure the Valuable worksheet is active and enter the YEARFRAC function in cell G2 to calculate the number of years from the release date and the date in cell Q2. Use relative and mixed references correctly. Format the value with Comma Style with one decimal place. Copy the function to the range G3:G165. c. Enter a nested logical function in cell L2 to display Highly Valuable if either condition is met: . The release date is on or before December 31, 1989, or • The sold-out status is Yes and the percentage increase in value is at least 500% and the Edition Size was less than 400. Enter an empty text string if the conditions are not met. Hint: You will need to nest two logical functions within the logical test argument. Use cell references to the two conditions. d. Copy the function from cell L.2 to the range L3:165. e. Click cell 010 and enter the database function to count the number of art pieces where the comment is Highly Valuable. The criteria range is located in the range N6:N7. f. Click cell 011 and enter the database function to calculate the average of art pieces where the comment is Highly Valuable. The criteria range is located in the range N6:N7. g. Click cell 012 and enter the database function to calculate the total estimated value of art pieces where the comment is Highly Valuable. The criteria range is located in the range N6:N7. h. Display the Database worksheet. Assign a range name called database to the range A14:J178. Assign a range name called Criteria to the range A7:19. i. Create column labels for the criteria range and replace the Edition Size with a second Release Date column label. Set the following conditions in the criteria range: . Sold-out limited-edition canvases released after 1/1/2000 and before 12/31/2003 Sold-out limited-edition prints released after 1/1/2000 and before 12/31/2003 . j. Create an advanced filter using the database list and criteria range. Filter the records in place. k. Enter the appropriate database function in cell C2 in the Summary Statistics area to calculate the highest estimated value of the filtered records. Apply Currency format and left-align the value. 1. Enter a nested function using INDEX and MATCH to display the title (in cell C3) and the release date (in cell C4) for highest estimated valued filtered artwork. Left-align and format the date. m. Create a footer with your name on the left side, the sheet name code in the center, and the file name code on the right side on each worksheet. n. Save and close the file. Based on your instructor's directions, submit e07m2 Art_LastFirst.
Expert Answer:
Answer rating: 100% (QA)
Step 1 of 1 A Open exploree07graderh3Artxlsx and save it as exploree07graderh3ArtLastFirst Easy Step ... View the full answer
Related Book For
Accounting concepts and applications
ISBN: 978-0538745482
11th Edition
Authors: Albrecht Stice, Stice Swain
Posted Date:
Students also viewed these finance questions
-
You are an analyst for a large public pension fund and you have been assigned the task of evaluating two different external portfolio managers (Y and Z). You consider the following historical average...
-
You are an analyst at Oil Patch Semiconductors Inc. (OPS), a small high-tech firm specializing in the design of proprietary chips used by oil companies to help find new sources of oil and natural...
-
You are an Analyst for the professional service firm, BUSI 1043 LLP. Your firm specializes in providing a wide variety of internal business solutions for different clients. It is your first day on...
-
Find a couple of bad project management examples from around the world. What were the reasons for the failure? (500 words max) Find a couple of good project management examples from around the world....
-
The following accounts appear on the worksheet of Santos Craft Store at December 31, 2016. Indicate the section of the classified balance sheet in which each account will be reported. SECTIONS OF...
-
Identify and describe four types of work teams.
-
In the Sumet Company, two employees were terminated for falsifying their time records. The two employees had altered overtime hours on their time cards after their supervisors had approved the hours...
-
You have been assigned to select an MUS sample from Whitney Company's detailed inventory records as of September 30. Whitney's controller gave you a list of the 23 different inventory items and their...
-
Now that you've completed your Westlaw Fundamentals Certification, you will learn about another type of legal research tool that is often used by small firms that either don't want to pay or don't...
-
For this exercise, we use JTRAIN.RAW to determine the effect of the job training grant on hours of job training per employee. The basic model for the three years is hrsempit = (0 + (1td88t + (2d89, +...
-
In this hypothetical case study and writing assignment, you will assess whether a particular state can enact trade barriers that conflict with the North American Free Trade Agreement (NAFTA). Write a...
-
Southwest Dry Cleaners believes that it will need new equipment in 6 years. The equipment will cost $26,000. What lump sum should be invested today at 8% compounded semiannually, to yield $26,000?...
-
The world-wide population of Bengal tigers has been decaying exponentially since 1972 due to poaching and habitat loss. The world-wide population of Bengal tigers t years since 1972 is approximately...
-
Simplify -3125x2 completely. Write answer in radical form. Answer = Entry Tip: To enter an answer like 50/2, type 50*root(3)(x^2). Preview your a submitting! Question Help: Message instructor...
-
Simplify 516x11 completely. Write answer in radical form. Assume Answer = Entry Tip: To enter an answer like 50x4x2, type 50x^4*root(3) answer before submitting! Question Help: Message instructor...
-
3. Let (S, o) be a semigroup. If for x, y S, xoy = y = yox, prove that (S,o) is an abelian group.
-
According to Thomas Friedman, world borders are fading because of __________. Select one: a. migration patterns b. Economic alliances c. advances in technology d. the increasing size of the largest...
-
Would you use the adjacency matrix structure or the adjacency list structure in each of the following cases? Justify your choice. a. The graph has 10,000 vertices and 20,000 edges, and it is...
-
Should partners of a business be held personally liable for the debts of the business, or should their business activities and debts be kept separate from their personal activities? John and Jeff...
-
As an investor, you are considering buying stock in a relatively new company. Medical Horizons, Inc., has been in existence for 10 years and is now about to go public. The first stock offering will...
-
Below is a list of accounts with corresponding balances. Using these accounts, along with the fact that the beginning balance in Retained Earnings is $16,000, compute the ending balance in Retained...
-
Examine resource rental pattern on following characteristics: a. Simplicity b. Generality c. Reusability d. Completeness e. Stability f. Visual and graphical model g. Testability
-
Why is it required to have two different patterns for account and entry?
-
Draw a class diagram for account with entry pattern.
Study smarter with the SolutionInn App