Use the data given below to answer the following question Below is the spreadsheet for demand prediction of a company that sells chocolates. A B C 1 Demand Prediction Models 2 3 Linear Model 4 A 10,000 5 B 10 6 7 Price Demand 8 $50 9,500 9 $55 9,450 10 $45 9,550 11 Using a $ sign before a column label . Question 25 options: 1) keeps the reference to both the row and column fixed 2) keeps the reference to the row fixed, but allows the column reference to change 3) keeps the reference to column fixed, but allows the row reference to change 4) allows both the row and column references to changeWhat keyboard symbol would be used in a cell to indicate an absolute reference