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
Option 4: None of these
Correct Answer: dollar
Solution : To make a cell address an absolute cell address place a dollar sign in front of the row and column identities. Hence, the correct option is 1.
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 are the main cell references in a spreadsheet?
Option 1: Absolute referencing
Option 2: Relative referencing
Option 3: Both 1 and 2
Question : A worksheet cell exists at the intersection of a ____________, and can contain up to _________ characters.
Option 1: Row and column, 32767
Option 2: Text and column, 33267
Option 3: Spread and cloumn, 32167
Option 4: None of the above
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 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
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile