FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
When Excel automatically sets the width of a column based on the widest entry in the column, it is called ____
A
custom fit
B
choice fit
C
best fit
D
don’t fit
Explanation: 

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: -Resize columns On the Home tab, select Format > Column Width (or Column Height). Type the column width and select OK.

Detailed explanation-3: -You can also prompt Access to automatically adjust the width of a field or column so that it can hold the widest entry. To do this, simply double-click the right edge of the column. Double-click the right border of the column.

Detailed explanation-4: -Excel begins with a default width of 8 characters and translates this into a given number of pixels, depending on the Normal style font. It then rounds this number up to the nearest multiple of 8 pixels, so that scrolling across columns and rows is faster.

There is 1 question to complete.
Previous
Next