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

Question : An address consists of ______ .

Option 1: an offset

Option 2: a base register

Option 3: an index register

Option 4: All 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 are the different types of data validation?

Option 1: Format

Option 2: Data Type

Option 3: Range

Option 4: All of the above

Question : Name the types of reference operators while working with worksheet ranges.

Option 1: range

Option 2: union

Option 3: Both 1 and 2

Option 4: None of these