Hello. Please assist me with an MS Excel question. I am new to excel spreadsheets and I am finding it difficult to use the required formulas. Please see attachments. I have provided the question and two screenshots of the excel workbook. The instructions provided in the question are very specific. Please note that marks are allocated for using the correct formulas and not for the correct answer. Answers should be rounded to two decimal places. Print screen and a completed workbook is required. Please assist me. If possible please provide or share the completed workbook.

Everlasting (Pty) Ltd. is a dermatological practise in Northcliff, Randburg. The company 1. Open the "Expect Return" and "Risk" tabs on the Excel Answer Book you have employs specialised, well-trained dermatologists and the majority of its client-base is been provided with on ColCampus. middle to high income earners. Currently, Everlasting (Pty) Ltd. is considering introducing a new product range to be sold 2. Perform research on the following Excel formulas: from their practice. - Addition, Subtraction, Division and Multiplication Two product ranges are being considered: SkinEveryday and Collamin. - Square root and exponents - SUM-formula While SkinEveryday is an affordable skincare range, Collamin is more expensive but - Referencing between cells and between different Excel tabs offers more benefits to the user as it has more proteins and minerals. - Absolute referencing In order to perform an evaluation of which product range to choose, Everlasting (Pty) Ltd. - Covariance formula has conducted research on the probability of each product range's success and the returns which they will receive in each of the various outcomes. 3. By ONLY using the above formulas (amount typing is also not allowed), complete the Excel answer book ("Expected Return" and "Risk" tabs) by calculating the cells highlighted in yellow. SkinEveryday: Evidence required Please submit the following as part of your completed assignment: - PDF version of all your completed sheets showing the amounts. - PDF version of all your completed sheets showing the formulas you used. To get the formula view of each of your sheets, go to Formulas > Show Formulas. Your Collamin: sheet will change so that all the cells where you entered formulas now display the actual formula that you entered. Take a screen print of the screen with all the formulas for assessment. SAICA competencies: Assume Everlasting (Pty) Ltd has R1 200000 funds available to invest in the new product ranges and decided to invest R739 000 into SkinEveryday and the remainder in Collamin. \begin{tabular}{|l|l|} \hline C1.4 & Uncertainty, volatility or inaccuracy, and consideration of qualitative factors in decision-making \\ \hline a) & Perform sensitivity and scenario analyses on key variables affecting the financial outcome of the decision, and interpret the result of the calculation \\ \hline b) & Incorporate the possibility of various outcomes into the decision-making process, including the use of probabilities and expected values \\ \hline \end{tabular} Everlasting (Pty) Ltd. is a dermatological practise in Northcliff, Randburg. The company 1. Open the "Expect Return" and "Risk" tabs on the Excel Answer Book you have employs specialised, well-trained dermatologists and the majority of its client-base is been provided with on ColCampus. middle to high income earners. Currently, Everlasting (Pty) Ltd. is considering introducing a new product range to be sold 2. Perform research on the following Excel formulas: from their practice. - Addition, Subtraction, Division and Multiplication Two product ranges are being considered: SkinEveryday and Collamin. - Square root and exponents - SUM-formula While SkinEveryday is an affordable skincare range, Collamin is more expensive but - Referencing between cells and between different Excel tabs offers more benefits to the user as it has more proteins and minerals. - Absolute referencing In order to perform an evaluation of which product range to choose, Everlasting (Pty) Ltd. - Covariance formula has conducted research on the probability of each product range's success and the returns which they will receive in each of the various outcomes. 3. By ONLY using the above formulas (amount typing is also not allowed), complete the Excel answer book ("Expected Return" and "Risk" tabs) by calculating the cells highlighted in yellow. SkinEveryday: Evidence required Please submit the following as part of your completed assignment: - PDF version of all your completed sheets showing the amounts. - PDF version of all your completed sheets showing the formulas you used. To get the formula view of each of your sheets, go to Formulas > Show Formulas. Your Collamin: sheet will change so that all the cells where you entered formulas now display the actual formula that you entered. Take a screen print of the screen with all the formulas for assessment. SAICA competencies: Assume Everlasting (Pty) Ltd has R1 200000 funds available to invest in the new product ranges and decided to invest R739 000 into SkinEveryday and the remainder in Collamin. \begin{tabular}{|l|l|} \hline C1.4 & Uncertainty, volatility or inaccuracy, and consideration of qualitative factors in decision-making \\ \hline a) & Perform sensitivity and scenario analyses on key variables affecting the financial outcome of the decision, and interpret the result of the calculation \\ \hline b) & Incorporate the possibility of various outcomes into the decision-making process, including the use of probabilities and expected values \\ \hline \end{tabular}