DATABASE FUNDAMENTALS
HOW TO MODIFY THE WORKSHEET TAB IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Page setup dialog box/print preview and fit sheet
|
|
|
lower the font size or decrease the column size
|
|
|
lower the range of the worksheet or remove empty cells
|
|
|
None of the above
|
Detailed explanation-1: -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-2: -Press CTRL and then click each worksheet tab in the workbook that you want to affect. On the File menu, click Page Setup. In Excel 2007, click the dialog box launcher in the Page Setup group in the Page Layout tab. Make the changes that you want in the Page Setup dialog box, and then click OK.
Detailed explanation-3: -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-4: -The Page Setup dialog box consists of four tabs: Page, Margins, Header/Footer, and Sheet. Each tab lets you customize elements of your Excel worksheet.