FUNDAMENTALS OF COMPUTER

Detailed explanation-1: -A header is a line of text that appears at the top of each page of a printed worksheet. You can change the orientation of a worksheet, which is the position of the content, so that it prints either vertically or horizontally on a page. A page break is a divider that breaks a worksheet into separate pages for printing.

Detailed explanation-2: -Click Page Layout > Margins > Custom Margins. In the Page Setup dialog box, under Center on page, select Horizontally and Vertically. This will center the sheet on the page when you print.

Detailed explanation-3: -The TRANSPOSE function must be entered as an array formula in a range that has the same number of rows and columns, respectively, as the source range has columns and rows. Use TRANSPOSE to shift the vertical and horizontal orientation of an array or range on a worksheet.

Detailed explanation-4: -There are two kinds of page orientation options in MS Excel; Portrait and Landscape. Portrait orients the page vertically while Landscape orients the page horizontally. Worksheets with a lot of columns benefit from landscape mode, whereas worksheets with a lot of rows benefit from portrait mode.

Detailed explanation-5: -On the Page Layout tab, in the Page Setup group, click Orientation, and then click Landscape.