FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

MODIFYING PAGE SETUP PROPERTIES IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
True or False? If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width.
A
True
B
False
C
Either A or B
D
None of the above
Explanation: 

Detailed explanation-1: -To access an Excel template, you can click the File tab and then click New. If you have too many columns on a page, the only option to see them all on a printed page is to decrease the column width.

Detailed explanation-2: -On the Home tab, in the Cells group, click Format. Under Cell Size, click AutoFit Column Width. Note: To quickly autofit all columns on the worksheet, click the Select All button, and then double-click any boundary between two column headings.

Detailed explanation-3: -Select one or more columns that you wish to resize. To select all columns, press Ctrl + A or click the Select All button. On the Home tab, in the Cells group, click Format > Column Width. In the Column width box, type the desired number, and click OK.

Detailed explanation-4: -Without adjusting the column widths, guarantee that all columns will print on one page. On Page Layout tab, in the scale to fit group, click the width arrow. click 1 page. On the Home tab, in the Clipboard group, click the Format Painter button, Click cell E1.

Detailed explanation-5: -9. What is the column width in a worksheet? Explanation: The column width in a worksheet is 255 characters.

There is 1 question to complete.