Question

In: Computer Science

Click cell C9 and insert a VLOOKUP function that looks up the code in cell B9,...

Click cell C9 and insert a VLOOKUP function that looks up the code in cell B9, 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 C9 to the range C9:C54. Hide column B that contains the codes.

Click cell K9 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 K9 to the range K10:K54.

Solutions

Expert Solution

Solution

Step 1

Go to cell C9

Step 2

Enter the following formula

=VLOOKUP(B9,$B$2:$C$6,2,FALSE)

Step 3

Enter

Step 4

Now copy the formula C9:C54

Step 5

Hide the column B

Right click on B

and select "Hide"

---

Next question

Step 1

Go to cell K9

enter the following formula

=IF(F9=I9,$K$2,$K$3)

enter

now copy the formula to K10:K54

all the best

venereology answered 1 month ago

Next > < Previous

Related Solutions

2 Insert a function in cell B2 to display the current date from your system. 3...

2 Insert a function in cell B2 to display the current date from your system. 3 With cell B2 selected, set the width of column B to AutoFit. 4 Insert a VLOOKUP function in cell C5 to display the ring cost for the first student. The cost of the ring type should be an exact match. Use appropriate relative and absolute cell references. 5 Copy the formula from cell C5 to the range C6:C11. 6 Apply Accounting number format to...

Briefly describe the function of cell membranes. Describe the different components that make up a cell...

Briefly describe the function of cell membranes. Describe the different components that make up a cell nucleus. What is the general function of the nucleus?

We can build a heap by repeatedly calling the insert function to insert the elements into...

We can build a heap by repeatedly calling the insert function to insert the elements into the heap. Here is pseudocode: buildHeap(A) h = new empty heap for each element e in A h.insert(e) What is the Big-O runtime of this version of buildHeap? Justify your answer.

Given the StudentIDDriver.java file, fill in the ‘gaps’ in the code (designated by insert code here...

Given the StudentIDDriver.java file, fill in the ‘gaps’ in the code (designated by insert code here that “exercises” (tests) the StudentID class by calling its methods. There are six occurrences of ‘insert code here comments’. Above these are comments that help you understand what your code should accomplish. Don’t forget to comment your StudentIDDriver.java file (including a prologue section at the top of the file). Create a project in Eclipse for your StudentIdDriver. Add another class for it StudentId Sample...

AVL tree; Insert and Range Minimum operation in Java code.

Variance Analysis Insert a formula into each cell marked with a "?". For the variances indicate...

Variance Analysis Insert a formula into each cell marked with a "?". For the variances indicate whether they are favorable or unfavorable Bradley Company produces a garden statue which requires the following variable manufacturing costs: Std Qty Std Price/Rate Direct material (mix) 6 lbs 0.06 per lb Direct labor 1 hours $16 per hour Variable O/H (based on direct labor hours) 1 hours $8.30 per hour Standard Cost per Unit: Standard Cost Direct Material ? Direct Labor ? Variable O/H...

Start with the provided code for the class linkedListType. Be sure to implement search, insert, and...

Start with the provided code for the class linkedListType. Be sure to implement search, insert, and delete in support of an unordered list (that code is also provided). Now, add a new function called insertLast that adds a new item to the END of the list, instead of to the beginning of the list. Note: the link pointer of the last element of the list is NULL. Test your new function in main. Submit a .zip of your entire project....

The link to the data is below, just click the link & open up the files...

The link to the data is below, just click the link & open up the files please. Listed under MOISTURE http://www.mediafire.com/download/thnnoaaqqefdwcf/excel_files.zip An important quality characteristic used by the manufacturer of Boston and Vermont asphalt shingles is the amount of moisture the shingles contain when they are packaged. Customers may feel that they have purchased a product lacking in quality if they find moisture and wet shingles inside the packaging. In some cases, excessive moisture can cause the granules attached to...

Your task is to take the below code, and insert comments (using the “%” symbol) next...

Your task is to take the below code, and insert comments (using the “%” symbol) next to each line of code to make sure that you know what every line does. clc clear close all NMax = 100; partialSum = 0; exactAnswer = pi^2; for k=1:NMax partialSum = partialSum + 6/k^2; percentDiff(k) = abs(partialSum - exactAnswer)/exactAnswer*100; end NVector = [1:NMax]; plot(NVector,percentDiff); xlabel('{{Noob}}'); ylabel('% Difference');

Your task is to take the above code, and insert comments (using the “%” symbol) next...

Your task is to take the above code, and insert comments (using the “%” symbol) next to each line of code to make sure that you know what every line does. close all; clear all; clc; thetaAB = 0; angleIncrement = 0.1; numOfLoops = 360/angleIncrement; thetaABVector = [angleIncrement:angleIncrement:360]; rAB = 5; rBC = 8; for i=1:numOfLoops bothResults = SliderCrankPosn(rAB,rBC,thetaAB); rAC(i) = bothResults(1); thetaBC(i) = bothResults(2); thetaAB = thetaAB+angleIncrement; end subplot(2,1,1) plot(thetaABVector,thetaBC,'Linewidth',3); xlabel('\theta_{AB} [degrees]'); ylabel('\theta_{BC} [degrees]'); xlim([0 360]); ylim([300 400]); grid...

Subjects