DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
Margins
|
|
Header/Footer
|
|
Page
|
|
Sheet
|
Detailed explanation-1: -If your worksheet has a lot of columns, you can use the Scale to Fit options to reduce the size of the worksheet to better fit the printed page. Follow these steps: 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.
Detailed explanation-2: -The Page Setup dialog allows end-users to specify the page orientation, paper size, margins, printout options, and it allows them to add headers and footers to a worksheet.
Detailed explanation-3: -Excel displays the Page Setup dialog box. On the Header/Footer tab, click Custom Header or Custom Footer. Click in the Left, Center, or Right section box, and then click any of the buttons to add the header or footer information that you want in that section.
Detailed explanation-4: -On the Page Layout tab, select Page Setup. On the Page tab, select the Adjust to check box, and select the percentage to reduce or enlarge the sheet. Note: Printed data never exceeds 100%.