Question : What is a range reference in spreadsheet?
Option 1: cells between and including the reference
Option 2: cells between and including the column
Option 3: cells between and including the row
Option 4: All of the above
Correct Answer: cells between and including the reference
Solution : A range reference refers to all the cells between and including the reference. 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
Option 4: None of these
Question : What is the procedure for selecting cells?
Option 1: Select a row -> Select a column -> Select all cells in a worksheet -> To select a contiguous group of cells
Option 2: Select a row -> Select a column -> To select a contiguous group of cells -> Select all cells in a worksheet
Option 3: Select a column -> Select a row -> Select all cells in a worksheet -> To select a contiguous group of cells
Option 4: Select a row -> Select a column -> To select a contiguous group of cells -> Select all cells in a worksheet
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
Question : A range reference consists of 2 cell addresses separated by a _______.
Option 1: colon
Option 2: comma
Option 3: full stop
Question : What is the procedure to insert a row in a worksheet?
Option 1: Click on the Row number -> Choose the Row option -> Click anywhere in the spreadsheet to remove the selection
Option 2: Click on the Row option -> Choose the Row number -> Click anywhere in the spreadsheet to remove the selection
Option 3: Click anywhere in the spreadsheet to remove the selection -> Click on the Row number -> Choose the Rows option
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile