Question: 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
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(Sheet1!\$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+B28B26,2) = INDEX(PDB, {1,2})
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
