DATABASE FUNDAMENTALS
ADJUSTING COLUMN WIDTH ROW HEIGHT IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Worksheet data can be scaled to fit on one page when printed, regardless of the size of the fonts, widths of the columns, and height of the rows.
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Explanation:
Detailed explanation-1: -Click the Page Layout tab on the ribbon. In the Scale to Fit group, in the Width box, select 1 page, and in the Height box, select Automatic. Columns will now appear on one page, but the rows may extend to more than one page.
Detailed explanation-2: -On the Layout tab, under Print, select the Fit To check box. In the page(s) wide and page(s) tall boxes, enter the number of pages on which you want to print the sheet. On the File menu, click Print. Note: Excel ignores manual page breaks when you use the Fit To option.
Detailed explanation-3: -In Excel, there are 1, 048, 576 rows and 16, 384 columns in one sheet. But, when you hit the print command the entire sheet is printed by default.
There is 1 question to complete.