USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Normal View
|
|
|
Page layout view
|
|
|
Page break preview
|
|
|
Header/footer
|
Detailed explanation-1: -Headers and footers are displayed only in Page Layout view, Print Preview, and on printed pages. You can also use the Page Setup dialog box if you want to insert headers or footers for more than one worksheet at a time.
Detailed explanation-2: -Headers and footers display only in Page Layout view and on printed pages. Select the worksheet you want to add a header or footer to. Click the Insert tab, and click Header & Footer. This displays the worksheet in Page Layout view.
Detailed explanation-3: -By default, the margins are 0.75 inches at the top and bottom, and 0.70 inches to the left and right. Click the Page Layout tab. Click the Margins button. Select the margin size you want to use from the list.
Detailed explanation-4: -The headers and footers in Excel help meet the standard representation format of the documents or worksheets. They add a sense of organization to the soft documents. Excel offers various options to be put up as header/footer text, such as “Date, ” “Time, ” “Sheet Name, ” “File Name, ” “Page Number, ” “Custom Text, ” etc.