Question

1 Approved Answer

Posted on Aug 02, 2024

Give me the formulas and the steps that I use for each of the steps begin{tabular}{|c|c|c|} hline Step & Instruetions & Possilble hline 1

Give me the formulas and the steps that I use for each of the steps image text in transcribed

\begin{tabular}{|c|c|c|} \hline Step & Instruetions & Possilble \\ \hline 1 & & 0 \\ \hline 2 & & 3 \\ \hline 3 & & 4 \\ \hline 4 & & 4 \\ \hline 5 & \begin{tabular}{l} You found an error in the worksheet. Since formulas heve been created to perform \\ calculations in the worksheet, changes to data will automatlecly be reflected troughout the \\ worksheet. \\ In cell E14, change the price of Soothing Bath Salts to 9.99 \end{tabular} & 2 \\ \hline 6 & & 2 \\ \hline 7 & & 2 \\ \hline \end{tabular} fx Quote for Customized Glit Baskets \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 6 & Wedding Party Name & \begin{tabular}{l} Number of \\ Days Spent \end{tabular} & Whole Days Spent & \begin{tabular}{l} Returned \\ Merchandise \end{tabular} & \begin{tabular}{c} Value of Returned \\ Merchandise \end{tabular} & \begin{tabular}{c} Amount Spent at \\ Spa \end{tabular} & Spa Member \\ \hline 7 & Arroyo & 1.52 & & -37.34 & & 1,215.63 & 1 \\ \hline 8 & Proctor & 2.54 & & 41.12 & & 720.60 & 1 \\ \hline 9 & Minor & 4.32 & & -12.7 & & 455.78 & 1 \\ \hline 10 & Pearce & 4.52 & & 13.97 & & 1,309.51 & Null \\ \hline 11 & Shea & 2.50 & & 18.53 & & 1,345.57 & 1 \\ \hline 12. & Galvan & 4,00 & & 11.09 & & 1,046.69 & 1 \\ \hline 13 & Crowe & 2.31 & & 36.64 & & 1,125.53 & 1 \\ \hline 14 & Meeks & 2.45 & & 47.7 & & 1,068.90 & 1 \\ \hline 15 & Kendrick & 3.65 & & 10.24 & & 604.95 & Null \\ \hline 16 & Mayfield & 4.45 & & 7.88 & & 299.60 & Null \\ \hline 17 & Kendall & 3.11 & & 21.78 & 1 & 353.74 & Null \\ \hline 18 & Archer & 3.15 & & 37.51 & & 923.56 & 1 \\ \hline 19 & Holler & 4.19 & & 34.36 & & 1,285.26 & Null \\ \hline 20 & Boucher & 4.10 & & 5.79 & & 1,157.07 & 1 \\ \hline 21 & Childs & 1.63 & & .2 .47 & & 206.77 & 1 \\ \hline 22 & Rankin & 4.50 & & -12.66 & & 781.30 & Null \\ \hline 23 & Lotano & 2.55 & & 49.74 & & 1,070.70 & Null \\ \hline 24 & Odell & 4.42 & & -18.66 & & 867.45 & Null \\ \hline 25 & Bland & 2.72 & & -17.86 & & 267.16 & 1 \\ \hline 26 & Rouse & 1.65 & & 24.98 & & 1,330.38 & 1 \\ \hline 27 & Hass & 4.40 & & 23.12 & & 899.77 & Null \\ \hline 28 & Swain & 1.16 & & -7.23 & & 1,479.14 & Null \\ \hline 29 & Oconnell & 2.64 & & 1.11 & & 953.20 & 1 \\ \hline 30 & Dougherty & 3.50 & & -0.46 & & 556.17 & Null \\ \hline 31 & Andersen & 3.58 & & -19.03 & & 644.50 & Null \\ \hline 32 & Wang. & 1.91 & & 3.15 & & 606.30 & 1 \\ \hline 33 & Cowan & 1.28 & & 40.74 & & 955.27 & Null \\ \hline 34 & Elder & 200 & & -16.6 & & 760.12 & 1 \\ \hline 35 & Shirler & 2.59 & & 31.05 & & 870,85 & 1 \\ \hline 36 & 5 Hartiey & 3.60 & & 25.91 & & 1,146.79 & 1 \\ \hline3837 & felix & 4.57 & & 30.66 & & 807.42 & Null \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & A & B & C & D & E \\ \hline 1 & Today's Date & & & & \\ \hline 2 & \multicolumn{4}{|c|}{ Spa Service Requests } & \\ \hline 3 & & & & & \\ \hline 4 & Guest Name & Proper Guest Names & Date Of Birth & Age & \\ \hline 5 & DLIVIA GARCIA & & 2/20/88 & & \\ \hline 6 & MIARAMOS & & 11/11/72 & & \\ \hline 7 & SABELLAHUDSON & & 10/19/75 & & \\ \hline 8 & RONDAGRIFFITH & & 1/2/69 & & \\ \hline 9 & TEVENLUCAS & & 2/26/70 & & \\ \hline 10 & LIZABETH ANDERSON & & 4/14/77 & & \\ \hline 11 & ESSICAMONTGOMERY & & 10/6/69 & & \\ \hline 12 & LLAWEST & & 5/26/78 & & \\ \hline 13 & OSEPH WALLACE & & 6/19/86 & & \\ \hline 14 & OSHUAPIERCE & & 5/12/69 & & \\ \hline 15 & RYAN JENNINGS & & 6/5/71 & & \\ \hline 16 & UDY BROWN & & 11/8/67 & & \\ \hline 17 & IANNAH ROWE & & 5/8/74 & & \\ \hline 18 & ILLIAN MCDONALD & & 6/9/76 & & \\ \hline 19 & UN BARKER & & 8/22/74 & & \\ \hline 20 & ERALDO RIVERA & & 3/9/85 & & \\ \hline 21 & ANEMONTGOMERY & & 5/12/86 & & \\ \hline 22 & JUSAN BURGESS & & 6/14/64 & & \\ \hline2423 & & & & & \\ \hline \end{tabular} \begin{tabular}{|c|c|c|} \hline Step & Instruetions & Possilble \\ \hline 1 & & 0 \\ \hline 2 & & 3 \\ \hline 3 & & 4 \\ \hline 4 & & 4 \\ \hline 5 & \begin{tabular}{l} You found an error in the worksheet. Since formulas heve been created to perform \\ calculations in the worksheet, changes to data will automatlecly be reflected troughout the \\ worksheet. \\ In cell E14, change the price of Soothing Bath Salts to 9.99 \end{tabular} & 2 \\ \hline 6 & & 2 \\ \hline 7 & & 2 \\ \hline \end{tabular} fx Quote for Customized Glit Baskets \begin{tabular}{|c|c|c|c|c|c|c|c|} \hline 6 & Wedding Party Name & \begin{tabular}{l} Number of \\ Days Spent \end{tabular} & Whole Days Spent & \begin{tabular}{l} Returned \\ Merchandise \end{tabular} & \begin{tabular}{c} Value of Returned \\ Merchandise \end{tabular} & \begin{tabular}{c} Amount Spent at \\ Spa \end{tabular} & Spa Member \\ \hline 7 & Arroyo & 1.52 & & -37.34 & & 1,215.63 & 1 \\ \hline 8 & Proctor & 2.54 & & 41.12 & & 720.60 & 1 \\ \hline 9 & Minor & 4.32 & & -12.7 & & 455.78 & 1 \\ \hline 10 & Pearce & 4.52 & & 13.97 & & 1,309.51 & Null \\ \hline 11 & Shea & 2.50 & & 18.53 & & 1,345.57 & 1 \\ \hline 12. & Galvan & 4,00 & & 11.09 & & 1,046.69 & 1 \\ \hline 13 & Crowe & 2.31 & & 36.64 & & 1,125.53 & 1 \\ \hline 14 & Meeks & 2.45 & & 47.7 & & 1,068.90 & 1 \\ \hline 15 & Kendrick & 3.65 & & 10.24 & & 604.95 & Null \\ \hline 16 & Mayfield & 4.45 & & 7.88 & & 299.60 & Null \\ \hline 17 & Kendall & 3.11 & & 21.78 & 1 & 353.74 & Null \\ \hline 18 & Archer & 3.15 & & 37.51 & & 923.56 & 1 \\ \hline 19 & Holler & 4.19 & & 34.36 & & 1,285.26 & Null \\ \hline 20 & Boucher & 4.10 & & 5.79 & & 1,157.07 & 1 \\ \hline 21 & Childs & 1.63 & & .2 .47 & & 206.77 & 1 \\ \hline 22 & Rankin & 4.50 & & -12.66 & & 781.30 & Null \\ \hline 23 & Lotano & 2.55 & & 49.74 & & 1,070.70 & Null \\ \hline 24 & Odell & 4.42 & & -18.66 & & 867.45 & Null \\ \hline 25 & Bland & 2.72 & & -17.86 & & 267.16 & 1 \\ \hline 26 & Rouse & 1.65 & & 24.98 & & 1,330.38 & 1 \\ \hline 27 & Hass & 4.40 & & 23.12 & & 899.77 & Null \\ \hline 28 & Swain & 1.16 & & -7.23 & & 1,479.14 & Null \\ \hline 29 & Oconnell & 2.64 & & 1.11 & & 953.20 & 1 \\ \hline 30 & Dougherty & 3.50 & & -0.46 & & 556.17 & Null \\ \hline 31 & Andersen & 3.58 & & -19.03 & & 644.50 & Null \\ \hline 32 & Wang. & 1.91 & & 3.15 & & 606.30 & 1 \\ \hline 33 & Cowan & 1.28 & & 40.74 & & 955.27 & Null \\ \hline 34 & Elder & 200 & & -16.6 & & 760.12 & 1 \\ \hline 35 & Shirler & 2.59 & & 31.05 & & 870,85 & 1 \\ \hline 36 & 5 Hartiey & 3.60 & & 25.91 & & 1,146.79 & 1 \\ \hline3837 & felix & 4.57 & & 30.66 & & 807.42 & Null \\ \hline \end{tabular} \begin{tabular}{|c|c|c|c|c|c|} \hline & A & B & C & D & E \\ \hline 1 & Today's Date & & & & \\ \hline 2 & \multicolumn{4}{|c|}{ Spa Service Requests } & \\ \hline 3 & & & & & \\ \hline 4 & Guest Name & Proper Guest Names & Date Of Birth & Age & \\ \hline 5 & DLIVIA GARCIA & & 2/20/88 & & \\ \hline 6 & MIARAMOS & & 11/11/72 & & \\ \hline 7 & SABELLAHUDSON & & 10/19/75 & & \\ \hline 8 & RONDAGRIFFITH & & 1/2/69 & & \\ \hline 9 & TEVENLUCAS & & 2/26/70 & & \\ \hline 10 & LIZABETH ANDERSON & & 4/14/77 & & \\ \hline 11 & ESSICAMONTGOMERY & & 10/6/69 & & \\ \hline 12 & LLAWEST & & 5/26/78 & & \\ \hline 13 & OSEPH WALLACE & & 6/19/86 & & \\ \hline 14 & OSHUAPIERCE & & 5/12/69 & & \\ \hline 15 & RYAN JENNINGS & & 6/5/71 & & \\ \hline 16 & UDY BROWN & & 11/8/67 & & \\ \hline 17 & IANNAH ROWE & & 5/8/74 & & \\ \hline 18 & ILLIAN MCDONALD & & 6/9/76 & & \\ \hline 19 & UN BARKER & & 8/22/74 & & \\ \hline 20 & ERALDO RIVERA & & 3/9/85 & & \\ \hline 21 & ANEMONTGOMERY & & 5/12/86 & & \\ \hline 22 & JUSAN BURGESS & & 6/14/64 & & \\ \hline2423 & & & & & \\ \hline \end{tabular}