Question

question 23
in excel, which of the following features resizes column width or row height to fit the width or height of the longest or tallest entry?
a autoformat
b autofit
c fill handle
d wrap text

Explanation:

• AutoFormat in Excel is used for applying predefined formatting styles to a range of cells, not for resizing columns or rows.
• AutoFit is the feature that adjusts the column width to fit the widest entry in the column and the row height to fit the tallest entry in the row.
• Fill Handle is used for copying data or formulas to adjacent cells.
• Wrap Text is used to display all the text in a cell by wrapping it to multiple lines, but it doesn't adjust the column width or row height to fit the content's width or height.

Answer:

B. AutoFit