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

Expert Solution

Steps to follow:

1. Open excel sheet.

2.Enter all sample field data.(Name,Ring type,Price,Personalize).

3. For Inserting IF condition. Go to tab formulas --> Insert function f(x).

4. Choose IF function from the list.

5. Enter the condition for IF condition as given in the below image.

6. Total field will be updated for 1 row.

7. Scroll down from E5 to E9 to update all the total as given below.

8. Final output is as follows:

venereology answered 3 months ago

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

On the Movies worksheet, in cell B1,(Total Gross Sales) enter a function that will calculate the...

On the Movies worksheet, in cell B1,(Total Gross Sales) enter a function that will calculate the total gross sales for records visible in the table. Format as Accounting. In cell B2(Average Gross Sales), enter a function that will calculate the average gross sales for records visible in the table. Format as Accounting. In cell B3 (Total Movies) enter a function that will calculate the number of movies visible in the table, using the MovieID field. Total Gross Sales (filtered) Average...

In cell F5, enter a formula using the PMT function. Insert a negative sign (-) after...

In cell F5, enter a formula using the PMT function. Insert a negative sign (-) after the equal sign in the formula to display the result as a positive amount. Use defined names for the rate, nper, and pv arguments as follows: · rate argument: Divide the Rate by 12 to use the monthly interest rate. · nper argument: Multiply the Term by 12 to specify the number of months as the periods. · pv argument: Use the Loan_Amount as...

EXCEL: In cell I4 insert formula(s) that will calculate the sum of Sales where COGS is...

EXCEL: In cell I4 insert formula(s) that will calculate the sum of Sales where COGS is greater than or equal to its average. Date Product Region SalesRep Customer Sales COGS Sum of Sales: 4/19/2020 Product3 Region3 SalesRep2 Customer16 $ 14,046 $ 5,337 4/19/2020 Product7 Region4 SalesRep15 Customer72 $ 2,504 $ 1,703 4/19/2020 Product2 Region4 SalesRep18 Customer71 $ 1,505 $ 843 4/19/2020 Product6 Region4 SalesRep14 Customer88 $ 4,232 $ 2,793 4/19/2020 Product3 Region4 SalesRep3 Customer65 $ 5,947 $ 3,390 4/19/2020 Product1...

You want to calculate agent commissions based on their role. In cell K12, insert the IFS...

You want to calculate agent commissions based on their role. In cell K12, insert the IFS function to calculate the agent’s commission based on the agent code and the applicable rates in the range L2:L4. Use relative and mixed references correctly. Copy the function to the range K13:K39.

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

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.

(In cell B15, enter a formula that uses the IF function and tests whether the total...

(In cell B15, enter a formula that uses the IF function and tests whether the total sales for Q1 (cell B8) is greater than or equal to 1000000. If the condition is true, multiply the total sales for Q1 by 0.18 to calculate a commission of 18%. If the condition is false, multiply the total sales for Q1 by 0.10 to calculate a commission of 10%.)

Let’s say a cell has arrested in the cell cycle due to a chromosome being temporarily...

Let’s say a cell has arrested in the cell cycle due to a chromosome being temporarily unable to attach to the microtubules of the mitotic spindle. (a) At what stage of the cell cycle is the cell arrested? [ Select ] ["Prophase", "Metaphase", "Prometaphase", "Anaphase"] (b) For each of the factors listed below, decide if the factor would be present in such a...

Cell (A) stands for the total cost of 5 units. Its value should be ____.

Use the values in the table below to answer the following questions.QTCATCMC25-( A)-6-( B)--( C)-1920-( E)--( D)-Cell (A) stands for the total cost of 5 units. Its value should be ____.A.B.C.D.

Question