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

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.

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.

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

A production function is given by q = L1/5K1/5 and a total cost function is given...

A production function is given by q = L1/5K1/5 and a total cost function is given by TC = q2/5. Under what conditions could these belong to the same firm?

Question