Question : What is absolute referencing?
Option 1: coordinates of a cell are not changed
Option 2: coordinates of a cell are changed
Option 3: coordinates of a cell are not at all affected
Option 4: coordinates of a cell are not affected
Correct Answer: coordinates of a cell are not changed
Solution : Absolute referencing is the coordinates of a cell that are not changed when a formula is copied from one cell to another. Hence, the correct option is 1.
Question : What are the main cell references in a spreadsheet?
Question : What is cell referencing in a spreadsheet?
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?
Question : What is the relative referencing?
Question : What are the coordinates of the centroid of a triangle whose vertices are A (2, 5), B (–4, 0), and C (5, 4)?
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile