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.

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 7 months ago

insert an If function in cell 5 to calculate the total due, if the student has...

insert an If function in cell 5 to calculate the total due, if the student has chosen to personalize the ring there is an additional charge of 5% located in cell B12 that must be applied: if not the student only pays the base price. Use appropriate relative and absolute cell references in excel

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...

1.) In cell H9 create a VLOOKUP to indicate the description Expensive for pups priced $2,000...

1.) In cell H9 create a VLOOKUP to indicate the description Expensive for pups priced $2,000 or more, Moderate for pups priced $1,000 or more but below $2,000, Good Dealfor pups priced $500 or more but less than $1,000 and Cheapfor all pups priced less than $500. Begin the lookup table in cell E1. Copy the VLOOKUP in cell H9 to cells H10:H202. 2.) In cell I9 create a Nested IF to duplicate the results of #1 above. Copy the nested If in...

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.

Take any TWO different data ranges and use VLOOKUP to come up with a useful way...

Take any TWO different data ranges and use VLOOKUP to come up with a useful way to pull the information together. For example, if you have a price list and an order list (in separate locations), you may want to use VLOOKUP to determine how much an order costs (quantity x price). Use VLOOKUP to pull all of the information onto one excel sheet. Complete each of the following: 1-Show two separate accounting related data points 2-Effectively use VLOOKUP to...

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...

When would you use the HLOOKUP function instead of a VLOOKUP? What does the Subtotal dialog...

When would you use the HLOOKUP function instead of a VLOOKUP? What does the Subtotal dialog box do in addition to inserting subtotals? Why do you have to select a range first to use the Quick Analysis tool?

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...