FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Which of the following might appear in the spreadsheet’s header or footer?
A
Title of company
B
=(A2:A10)
C
graph
D
None of the above
Explanation: 

Detailed explanation-1: -Generally, headers and footers contain basic information about the spreadsheet such as page number, current date, workbook name, file path, etc.

Detailed explanation-2: -Headers and footers will usually display information such as the page number, date, workbook/worksheet name and the author. Headers and footers only show on the printed Excel document or in the Print>Preview.

Detailed explanation-3: -You can add headers or footers at the top or bottom of a printed worksheet in Excel. For example, you might create a footer that has page numbers, the date, and the name of your file. You can create your own, or use many built-in headers and footers.

Detailed explanation-4: -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. The Header & Footer Tools Design tab appears, and by default, the cursor is in the center section of the header.

Detailed explanation-5: -Select a cell, click Insert > Pictures. 2. In Insert Picture dialog, select the logo picture you want to insert.

There is 1 question to complete.