Please answer questions 1 and 2 below:

Sweat Junkie is Chicago's newest Hot Yoga studio located in Evanston, Illinois. Sweat Junkie offers a variety of classes for all fitness levels and abilities, from hot yoga (flexibility \& meditation) to hot pila tes (strength \& conditioning), and Hot Barre Intensity. The studio charges different prices depending on whether an attendee is a youth, a college student, or an adult (regular) attendee, as shown in the table below. \begin{tabular}{|c|c|c|c|c|} \hlineA & B & C & D & E \\ \hline 1 & \multicolumn{4}{|c|}{ Sweat Junkie } \\ \hline 2 & \multicolumn{4}{|c|}{ Hot Yoga Pilates Barre Studio } \\ \hline \multicolumn{5}{|l|}{3} \\ \hline 4 & Attendee Type & Fee & Requirements & \\ \hline 5 & Regular & $22 & \multicolumn{2}{|c|}{ Valid on any single class we offer } \\ \hline 6 & Student & $15 & \multicolumn{2}{|c|}{ Must show vaild University ID } \\ \hline 7 & Youth & $10 & \multicolumn{2}{|c|}{ Must be between 10 and 17 years old } \\ \hline 8 & & & & \\ \hline 9 & Date & Customer Name & Attendee Type & Amount Charged \\ \hline 10 & 9/1/2022 & Benjamin Curry & Regular & $22.00 \\ \hline 11 & 9/2/2022 & Blake Cohen & Regular & $22.00 \\ \hline 12 & 9/2/2022 & Eugene Potter & Youth & $10.00 \\ \hline 13 & 9/4/2022 & Melba Huff & Regular & $22.00 \\ \hline 14 & 9/4/2022 & Melanie Lambert & Student & $15.00 \\ \hline 15 & 9/4/2022 & Justin Pierce & Regular & $22.00 \\ \hline 16 & 9/5/2022 & Irene Cruz & Regular & $22.00 \\ \hline 17 & 9/6/2022 & Marshall Willis & Regular & $22.00 \\ \hline 18 & 9/6/2022 & Lawrence Turner & Regular & $22.00 \\ \hline 19 & 9/6/2022 & Alvin Burns & Student & $15.00 \\ \hline \end{tabular} 1. What formula would you add to cell E10 to calculate the amount charged for each individual? - The formula in E10 will be used to auto-fill the rest of the column. - Make sure to use cell references, and not enter specific number in your formula. =IF($D10=$B5,$C5,IF(D10=$B6,$C6,$C7))=IF(D10=$B$5,C5,IF(D10=$B$6,C6,C7))=IF(D10=B5,C5,IF(D10=B6,C6,C7))=IF(D10=$B$5,$C$5,IF(D10=$B$6,$C$6,$C$7))=IF($D$10=$B$5,$C$5,IF($D$10=$B$6,$C$6,$C$7)) 2. What formula would you add to cell E10 to calculate the amount charged for each individual? - The formula in E10 will be used to auto-fill the rest of the column. - Make sure to use cell references, and not enter specific number in your formula. =VLOOKUP(D10,$B$5:$C$7,2,FALSE) =HLOOKUP(D10,$B$5:$C$7,2, TRUE) =VLOOKUP(D10,$B$5:$C$7,2,TRUE) =VLOOKUP(D10,B5:C7,2,FALSE) =HLOOKUP(D10,$B$5:$C$7,2, FALSE )