USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
T
|
|
|
F
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Go to Layout > View > Page Layout. On the Header or Footer pop-up menu, choose Blank. Double-click Type here in the header or footer area. Select Picture from File, choose your picture, and select Insert to add the picture.
Detailed explanation-2: -On the Insert tab, in the Text group, click Header & Footer. Excel displays the worksheet in Page Layout view. To add or edit a header or footer, click the left, center, or right header or footer text box at the top or the bottom of the worksheet page (under Header, or above Footer). Type the new header or footer text.
Detailed explanation-3: -On the Insert tab, in the Illustrations group, click Pictures. Locate the picture that you want to insert, and then double-click it. Tip: To add multiple pictures, hold down CTRL while you click the pictures that you want to insert, and then click Insert.
Detailed explanation-4: -You can add headers to the top and footers to the bottom of a worksheet. When you print the worksheet, the headers and footers also print. For example, you might create a header with the file path and a footer with page numbers. Headers and footers display only in Page Layout view and on printed pages.
Detailed explanation-5: -Use headers and footers to add a title, date, or page numbers to every page in a document. Select Insert > Header or Footer. Select one of the built in designs. Type the text you want in the header or footer.