Question 7 2 pts Which one of the following is a true statement about the mixed cell reference with column fixing is copied across? 0 It will point to a different cell in the same column but in a different row. O It will point to the same cell. O It will point to a different cell in the same row but in a different column It will point to a different cell in a different row and a different column. Question 8 2 pts My data has multiple rows and multiple columns. I want to refer to the value in the first column to compute the values in all other columns to its right. Which one of the following references should I use under the circumstance? Relative cell reference. O Mixed cell referencing with row fixing. Mixed cell referencing with column fixing. O Absolute cell reference