USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Autofill
|
|
|
Autofit
|
|
|
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. AutoFit Column Width-changes the column width to hold the largest value in the column.
Detailed explanation-2: -To AutoFit a single column, hover the cursor to the right of the column header. When the double-pointed black arrow appears, double-click the header’s border to AutoFit the column. The column width will expand, fitting according to the longest text string in a cell contained in the column.
Detailed explanation-3: -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.