USING MICROSOFT EXCEL
MODIFYING PAGE SETUP PROPERTIES IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
True
|
|
False
|
|
Either A or B
|
|
None of the above
|
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.