You are creating a worksheet in Excel 2010. You have entered data as shown in the image below:
You have merged A1 and B1 cells. You want to align text in the merged cell to appear as shown in
the image below:
Which of the following steps will you take to accomplish the task?
Each correct answer represents a part of the solution. Choose two.
A.
Select the merged cell and middle align vertically.
B.
Select the merged cell and use the Merge Across option.
C.
Select the merged cell and center align horizontally.
D.
Select the merged cell and increase indent by half inch.
Explanation:
According to the question, you need to align text in the merged cell at the center of the cell. In order
to accomplish the task, you will have to select the merged cell and center-align it horizontally and
then middle-align it vertically.