$\backslash$table$[[$Problems $1$ and,$2,,,,,],[5,7,2,1,4,7,2],[8,7,3,6,6,4,0],[7,9,6,7,9,0,7],[5,6,8,3,6,5,9],[7,9,7,9,7,4,],[7,4,9,2,1,4,8],[5,2,1,5,1,8,8],[6,9,1,3,9,3,9],[,,,,5,8,6],[,,,,,,],[,,,,,,]]$

Refer to the Excel file. See link in Description. What will the following formula return?

$=$ COUNT$($INDEX$($Data$,2,2)$:INDEX$($Data$,7,4))$

$70$

$24$

$18$

$28$

Question $2(1$ point$)$

Which of the following formulas will return a dynamic reference to the entire database in the Retirement Problem. Assume that the number of columns will remain fixed at $2,$ but that the number of rows can change based on the choice of the three inputs? Note: A number of ranges are named. This is a multi$-$select question. Choose all correct answers.

$=$OFFSET$($Sheet$1!$$A$$30,,,$Retirement$\_$Age$+$Years$\_$in$\_$Retirement$-$Current$\_$Age,$2)$

$=$OFFSET$($$A$$29,1,1,$Retirement$\_$Age$+$Years$\_$in$\_$Retirement$-1)$

$=$$$A$$$30$:INDEx$(PDB,B27+B28-B26,2)$

PDB$,,\{1,2\}$