In Excel,to merge cells A1,B1,C1,D1,and E1,_____ is the correct reference for the merged cell.
A)A1!E1!
B)A1
C)E1
D)A1-E1

Name: In Excel,to merge cells A1,B1,C1,D1,and E1,_____ is the correct reference for the merged cell. A)A1!E1! B)A1 C)E1 D)A1-E1
Brand: Quizplus
Rating: 4.9 (45 reviews)

Question

Quizplus · Accepted Answer

When cells are merged, the reference for the merged cells defaults to the upper-left cell of the original selection. In this case, cells A1, B1, C1, D1, and E1 were merged, so the merged cell's reference will be A1. Therefore, the correct answer is B.

In Excel,to Merge Cells A1,B1,C1,D1,and E1,_____ Is the Correct Reference