Question

In MS Excel, a ________ is identified by the cell in the upper-left corner and the cell in the lower-right corner, separated by a colon. 

1. worksheet 
2. value
3. cell reference
4. range 

Answer 1

Correct Answer - Option 4 : range 

The correct answer is range.

• In Microsoft Excel, a range is a collection of cells.
• A range can be 2 or more cells and those cells don't necessarily have to be adjacent to each other.

​  

• Worksheet and workbook specifications and limits:
  • Total number of rows and columns on a worksheet - 1,048,576 rows by 16,384 columns
  • Column width - 255 characters
  • Page breaks - 1,026 horizontal and vertical
  • Row height - 409 points