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
Correct Answer: cell coordinates in the formula
Solution : Cell referencing is the cell coordinates in the formula in a spreadsheet. Hence, the correct option is 1.
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 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 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 : To make a cell address an absolute cell address place a ________ sign in front of the row and column identities.
Option 1: dollar
Option 2: pound
Option 3: hash
Question : In any spreadsheet, the address of the first cell is
Option 1: 0A
Option 2: 1A
Option 3: A0
Option 4: A1
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile