Question

Explain various options available to change the alignment of the text in the cells.

Hint:

Name the three option groups, Text layout, Autofit and Internal margin, and then give the Home tab Alignment dialog steps for cells.

Answer 1

Step 1: Understand what is asked:
The question asks for the options that change how text sits inside a cell or shape in a spreadsheet. Alignment means the position, direction and spacing of the text. The official answer groups these options under three headings and then gives the commands for cells. Since the question carries 6 marks, we cover all of it.

Step 2: Option 1, Text layout:
Text layout has two settings.
Vertical alignment sets the up-down position of the text in a shape. We pick top, middle or bottom from the list.
Text direction sets the orientation of the text. We pick horizontal or a rotated direction from the list.

Step 3: Option 2, Autofit:
Autofit has the setting Resize shape to fit text. When we click it, the shape grows in height so that the whole text fits inside it. The text then never spills out of the box.

Step 4: Option 3, Internal margin:
The internal margin is the gap between the text and the border of the element. We can widen or narrow this gap with four boxes.
Left sets the distance from the left border. Right sets it from the right border.
Top sets the distance from the top border. Bottom sets it from the bottom border.
Columns sets how many columns of text the element holds and the space between them.

Step 5: Commands to align text in cells:
Select the range of cells.
Click the Home tab and open the Alignment group dialog box.
Choose the Alignment tab and set the horizontal and vertical alignment we need.
Other settings let us show text at an angle, keep it inside the cell, or spread it across the cell.
Click OK to apply.

Step 6: Marks split:
Each of the three options carries 1 mark, which is 3 marks. The command steps carry the other 3 marks. Together this makes 6 marks.

Final Answer:
Text alignment is changed through three options, Text layout (vertical alignment and text direction), Autofit (resize shape to fit text) and Internal margin (left, right, top, bottom, columns), and through the Home tab Alignment dialog for cells.