USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Excel’s AutoFit feature is designed to automatically resize cells in a worksheet to accommodate different sized data without having to manually change the column width and row height.
Detailed explanation-2: -Select the cell or range for which you want to adjust the row height. On the Home tab, in the Cells group, click Format. Under Cell Size, do one of the following: To automatically adjust the row height, click AutoFit Row Height.
Detailed explanation-3: -Sometimes, Autofit refuses to work when there are merged cells in your Excel. This is a known issue if you’re using really old versions of Excel (2003 or prior versions). Microsoft has even acknowledged this issue here. If this happens to you, the only workaround is to manually set the row height or column width.
Detailed explanation-4: -If you set a row height or column width to 0 (zero), what happens to the row and column? It sets to the default width or height.
Detailed explanation-5: -In Excel, the default row height is 15 (20 pixels), and the column width is 8.43 (64 pixels).