Exp22_Excel_AppCapstone_Intro_Collection | Excel_AppCapstone_Intro_Collection

Exp22_Excel_AppCapstone_Intro_Collection | Excel_AppCapstone_Intro_Collection | Pearson MyLabSolution Contact Us: WhatsApp no. : +923187453609 direct link:https://wa.me/message/DGS6KUELRBTVM1 Email : [email protected] #Exp22_Excel_AppCapstone_Intro_Collection #excel #Exp22_Excel_AppCapstone_Intro_Collection #Exp22_Excel_AppCapstone_Intro_Collection #Exp22_Excel_AppCapstone_Intro_Collection #Exp22_Excel_AppCapstone_Intro_Collection #Exp22_Excel_AppCapstone_Intro_Collection #Exp22_Excel_AppCapstone_Intro #Exp22_Excel_AppCapstone_Intro #Exp22_Excel_AppCapstone_Intro #Exp22_Excel_AppCapstone_Intro #Exp22_Excel_AppCapstone_Intro #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone Project Description: You are the financial manager for Judi’s Art Gallery. One of your clients, Raymond Chancellor, has a large collection of limited edition signed art by James C. Christensen (1942-2017). Over the years, you have helped Raymond maintain a list of his collection, including the title of the art, medium, issue date, issue price, the price he paid, and current market values. Most of the art is sold out from the publisher, which increases the value of the art. Other art is still readily available or is available in limited quantities. You want to update the list so that he can properly insure his collection. Steps to Perform: Step Instructions Points Possible 1 Start Excel. Download and open the file named Exp22_Excel_AppCapstone_Intro_Collection.xlsx. Grader has automatically added your last name to the beginning of the filename. 0 2 Your first task is to move the title to the top of the worksheet. On the Christensen worksheet, move the title Raymond's Art Collection from cell A7 to cell A1. 2 3 To balance the space, you will merge the cell containing the title with empty cells and change the vertical alignment. #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone Select the range A1:A5, merge the cells, and apply Middle Align vertical alignment. 2 4 You want to format some input cells in column K to be similar to other input cells. Change the width of column K to 17.00, select the range K1:K3, and apply Thick Outside Borders. 1 5 Click cell C11, and freeze panes so that rows 1 through 10 and columns A and B are frozen. 1 6 Select the range E11:E59 and apply the Mar-12 date format. Note, Mac users, depending on the version of Office you are using, the date format may be Mar-15 2 7 Your next task is to replace a word with a more accurate word. #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone Find all occurrences of Retired and replace them with Sold Out. 2 8 A range contains misspelled words that need to be detected and corrected. Select the range C1:G5, check the spelling, and correct spelling errors. 2 9 In cell A6, insert the TODAY function. 1 10 Click cell H11 on the Christensen worksheet, and insert a formula that calculates the percentage Raymond paid of the issue price by dividing the amount Paid by the Issue Price. Copy the formula from cell H11 to the range H12:H59. 3 11 Click cell J11, and insert a formula that calculates the percentage change in value by subtracting the Issue Price from the Current Value and then dividing that result by the Issue Price. Copy the formula from cell J11 to the range J12:J59. 3 #exp22_excel #exp22_excel #exp22_excel #exp22_excel #exp22_excel #exp22_excel #Excel_AppCapstone_Intro_Collection #Excel_AppCapstone_Intro_Collection #Excel_AppCapstone_Intro_Collection #Excel_AppCapstone_Intro_Collection #Excel_AppCapstone_Intro_Collection #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone #Exp22_Excel_AppCapstone