image
.jpg
keyboard_arrow_up
School
Macomb Community College *
*We aren’t endorsed by this school
Course
101
Subject
Information Systems
Date
Apr 3, 2024
Type
jpg
Pages
1
Uploaded by AmbassadorComputerMink33
Excel 2022 Project Points Possible Instructions You want to format the results with Percent Style 2/ Apply Percent Style with one decimal place to the ranges H11:H59 and J11:J59 You are ready to enter some summary statistics at the top of the worksheet Insert in the Current Values section at the top of the worksheet summary functions that use the range 111:159. In cell 12, calculate the total of all the Current Values. In cell 13, calculate the average current value. In cell 14, calculate the lowest current value. In cell |5, calculate the 3 J highest current value. Click cell C11 and insert a VLOOKUP function that looks up the code in cell B11, compares it to the codes and types of art in the range B2:C6, and returns the type of art. Copy the function in cell C11 to the range C12:C59. Use relative and mixed (or absolute) references correctly Now that you used a lookup function to return the type of art, you are ready to hide the column containing the codes. § 14 15 Hide column B. Cell G8 is designed to enter the name of a piece of art, and you want cell I8 to display the corresponding value. After you enter the function, you will change the name of the art to make sure the function results update correctly. In cell 18, insert the XLOOKUP function to look up the art in cell G8, compare it to the lookup array in the range A11:A59, and return the corresponding current value in the range 111:159. In cell G8, type The Listener. You want to display a note for each piece of art based on whether the current value is higher or the same as the issue price. Click cell K11 and insert an IF function that determines if the Issue Price is equal to the Current Value. If the values are the same, display Same as Issue (using the cell reference K2); otherwise, display Increased in Value (using the cell reference K3). Copy the function from cell K11 to the range K12:K59. Rename Sheet2 as Purchase. Display the Purchase worksheet, insert a row above Monthly Payment. In cell A5, type Payments in 1 Year in cell A5. In cell BS, type 12. In cell B6 in the Purchase worksheet, insert the PMT function to calculate the monthly payment using cell references, not numbers, in the function, and make sure the function displays a positive result. Apply Accounting Number Format and the Output cell style to cell The Types of Art input section on the Christensen worksheet displays the total of the issue prices and the total current values of each type of art that Raymond owns. You will create a chart so that Raymond can compare the purchase price to the current value of each type of art. Display the Christensen worksheet, select the range C1:E6, and create a clustered column chart. Exp22_Excel_AppCapstone_lIntro - Collection 1.0 Created On: 03/10/2022 P v A eI I s
Discover more documents: Sign up today!
Unlock a world of knowledge! Explore tailored content for a richer learning experience. Here's what you'll get:
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help