Question : What are the main cell references in a spreadsheet?

Option 1: Absolute referencing

Option 2: Relative referencing

Option 3: Both 1 and 2

Option 4: None of these

Question : What is cell referencing in a spreadsheet?

Option 1: cell coordinates in the formula

Option 2: row coordinates in the address bar

Option 3: cell coordinate in the sheet

Option 4: All of the above

Question : Point A divides segment BC in the ratio 4 : 1. Coordinates of B are (6, 1) and coordinates of C are ($\frac{7}{2}$, $6$). What are the coordinates of point A?

Option 1: (4, 3)

Option 2: (4, 5)

Option 3: (2, 5)

Option 4: (3, 5)

Question : What is the relative referencing?

Option 1: records the position of the cell

Option 2: does not records the position of the cell

Option 3: format the position of the cell

Option 4: None of these

Question : The coordinate of the centroid of a $\triangle$ABC is (2, 2). What are the coordinates of vertex C, if the coordinates of A and B are (7, –1) and (1, 2), respectively?

Option 1: (–2, 5)

Option 2: (2, 5)

Option 3: (–2, –5)

Option 4: (2, –5)