Which of the following is not located in the page setup dialog box

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. 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. For other sheet types, such as chart sheets, or charts, you can insert headers and footers only by using the Page Setup dialog box. Add or change headers or footers in Page Layout view • Click the worksheet where you want to add or change headers or footers. • 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. Notes: • To start a new line in a header or footer text box, press Enter. • To include a single ampersand (&) in the text of a header or footer, use two ampersands. For example, to include "Subcontractors & Services" in a header, type Subcontractors && Services. • To close headers or footers, click anywhere in the worksheet. To close headers or footers without keeping the changes that you made, press Esc. Tip: You can select multiple wo...

Just as characters and paragraphs can be formatted, document pages can also be formatted in various ways in Word. Among others, formatting pages includes setting/changing paper size, page orientation, margin, page numbers, header and footer elements, etc. It is often worth the effort spending quality time setting up or formatting document pages appropriately, because this is the only way to get a document with consistent look, carrying evidences of a professional touch. It is good practice, and often easier, to define the page settings before you begin a document. If you already know before you start a new document the particular way you want the document to look, then start by setting up the document by specifying the paper size, orientation of pages, margins, gutter, header and footer, page numbers, columns, etc. These options all affect the appearance of a page. However, if you do not know yet how the overall document should look like, you can still stick to the default page setup and change it afterward. Dividing a document into sections will enable you define varying settings or page layouts within or between pages in the document. Paper SizeThere are several sizes or dimensions of paper available today on which a document can be printed. Depending on the capabilities of your printer, you can print a document on common paper sizes such as A4, Letter, Legal, Tabloid, etc, or you can type dimensions for custom paper sizes. The paper size you choose will also help Word i...

C) Values and formulas but not labels D) Formulas only ANSWER: A You can use the horizontal and vertical scroll bars to A) Split a worksheet into two panes B) View different rows and columns edit the contents of a cell C) Edit the contents of a cell D) view different worksheets ANSWER: B You cannot link excel worksheet data to a word document