DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Wrapping the text
|
|
|
Merging the text
|
|
|
Highlighting the text
|
|
|
None of the above
|
Detailed explanation-1: -AutoFit is a feature in Excel that allows you to quickly adjust the row height or column width to fit the text completely (so that there is no spilling over to other cells). Autofit Row Height: This feature automatically adjusts the row height to fit the text in the cell. You can autofit multiple rows at once.
Detailed explanation-2: -Select the row or rows that you want to change. On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Row Height. Tip: To quickly autofit all rows on the worksheet, click the Select All button, and then double-click the boundary below one of the row headings.
Detailed explanation-3: -Press Ctrl + 1 to open the Format Cells dialog (or right-click the selected cells and then click Format Cells…), switch to the Alignment tab, select the Wrap Text checkbox, and click OK.