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 : What are the coordinates of the centroid of a triangle whose vertices are A (2, 5), B (–4, 0), and C (5, 4)?

Option 1: (–1, 3)

Option 2: (1, 3)

Option 3: (1, –3)

Option 4: (–1, –3)