Question : A range reference consists of 2 cell addresses separated by a _______.
Option 1: colon
Option 2: comma
Option 3: full stop
Option 4: All of the above
Correct Answer: colon
Solution : A range reference consists of 2 cell addresses separated by a colon. The cell reference B1:B4 includes the cells B1, B2, B3 and B4. Hence, the correct option is 1.
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
Question : An address consists of ______ .
Option 1: an offset
Option 2: a base register
Option 3: an index register
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 : What are the different types of data validation?
Option 1: Format
Option 2: Data Type
Option 3: Range
Question : Which of the following statements is correct about the President of India?
Option 1: Addresses the first session of Parliament after each General Election
Option 2: Addresses the first session of Parliament at the beginning of each year
Option 3: Addresses every session of Parliament
Option 4: Never addresses Parliament
Regular exam updates, QnA, Predictors, College Applications & E-books now on your Mobile