[Forest Guard, 2022]
4. In a computer spreadsheet, cell range A3 through G3 should be keyed in as ________
A3-G3
A3:G3
A3?.G3
A3 to G3
Correct Answer :
A3:G3
In a computer spreadsheet, cell range A3 through G3 should be keyed in as A3:G3. The colon (:) is used to indicate a range of cells between two cells. So, A3:G3 refers to all cells from A3 through to G3, inclusive.
Option (a) A3-G3 is not a valid syntax for representing a cell range in a spreadsheet.
Option (c) A3?.G3 is also an invalid syntax as it contains a question mark character.
Option (d) A3 to G3 is not a valid syntax for representing a cell range in a spreadsheet.