Join 60,000+ competitive exam aspirants
Which menu option allows you to change the height and width of cells in MS-Excel?
Format
Review
Insert
Page Layout
Format
In MS Excel, the Format menu (located under the Home tab) contains the Cell Size group, which allows users to manually specify Row Height and Column Width. This feature is essential for data presentation and ensuring that text within cells is fully visible.
In MS Excel, the Format menu (located under the Home tab) contains the Cell Size group, which allows users to manually specify Row Height and Column Width. This feature is essential for data presentation and ensuring that text within cells is fully visible.
The development of spreadsheet software traces back to VisiCalc (1979), the first spreadsheet program for personal computers, which set the standard for grid-based data management used in modern software like Excel.
The Format option is located within the Cells group under the Home tab in the Excel Ribbon interface.
Row height can be adjusted from 0 to 409 points, while Column width can be adjusted from 0 to 255 characters.
AutoFit is a sub-feature within the Format menu that automatically adjusts cell dimensions based on the contents.
Review tab is primarily used for spell checking, protecting sheets, and adding comments/notes.
Insert tab is used to add objects like tables, charts, pivot tables, images, and functions to the worksheet.
Page Layout tab controls the global appearance of the sheet, including margins, orientation, and print scaling, rather than individual cell dimensions.
Keyboard shortcut for opening the Format menu is Alt + H, then O.
A is correct тАФ The Format menu under the Home tab provides the specific tools required to adjust the physical dimensions of rows and columns in an Excel worksheet.
In computer literacy exams, always distinguish between 'Page Layout' (which manages printing properties) and 'Format' (which manages cell/data properties). This distinction is a common trap in MCQ sets.