Question

A1: E2 refers to:

• A. Rows on Excel sheet
• B. Cells between starting point A1 to ending point E2
• C. Column on Excel sheet
• D. Alphabetic arrangement between A to E

Hint:

A1:E2 is a range that covers all the cells from A1 to E2, which is 5 columns and 2 rows.

Answer 1

The Correct Option is B

Step 1: Understanding the Concept:
In Excel a colon between two cell addresses makes a range.
The range covers all the cells in the block between the two addresses.

Step 2: Working Out the Answer:
A1:E2 starts at cell A1 and ends at cell E2.
It covers columns A to E, which is 5 columns, and rows 1 to 2, which is 2 rows.
Total cells are 5 x 2 = 10 cells.
So A1:E2 refers to the cells between starting point A1 and ending point E2, option (B).

Step 3: Why the Other Options Are Wrong:
Option (A): Rows on Excel sheet is wrong because the range covers cells in both rows and columns, not only rows.
Option (C): Column on Excel sheet is wrong, since the range spreads over 5 columns and 2 rows.
Option (D): Alphabetic arrangement between A and E is wrong. The letters are only column names, and the numbers 1 and 2 give the rows.

Final Answer:
A1:E2 refers to the cells from A1 to E2. This is option (B).