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
Correct Answer: Both 1 and 2
Solution : Cell referencing is the cell coordinates in the formula. Two commonly used cell references are: absolute and relative. Hence, the correct option is 3.
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
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
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 : What is a cell in a spreadsheet?
Option 1: the intersection of a row and column
Option 2: inside of a row
Option 3: inside of a column
Question : What is the other name of each spreadsheet file?
Option 1: Workbook
Option 2: Cell
Option 3: Worksheet
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile