SOFAPP: MICROSOFT INTERMEDIATE QUIZ (FOR A001)

If you want your printout to include the gridlines,

Choose Page Layout » Sheet Options group » Gridlines » Check Print

• SHEET OPTIONS

• HEADER AND FOOTER

• FREEZE PANES

• PAGE BREAK

2. It is one of the Print options in Sheet Options Dialogue. Select this check box to have your color printer print the chart in black and white.

• DRAFT QUALITY

• ROWS & COLUMN HEADING

• GRIDLINES

• BLACK & WHITE

 

Select this check box to have rows and column heading to print.

• DRAFT QUALITY

• ROWS & COLUMN HEADING

• GRIDLINES

• BLACK & WHITE

In Page Order Sheet Options Dialogue, it prints right pages first and then comes to print the down pages.

• Over, then Down

•    Print Area

• Down, then Over

• Page Order

A ________ is the information that appears at the top of each printed page and a _________ is the information that appears at the bottom of each printed page.

(a)  

If checked, the font size in the header and footer will be sized. Accordingly, if the document is scaled when printed. This option is enabled, by default.

• DIFFERENT FIRST PAGE

• DIFFERENT ODD & EVEN PAGES

• ALIGN WITH PAGE MARGINS

• SCALE WITH DOCUMENT

Check this to specify a different header or footer for odd and even pages.

• ALIGN WITH PAGE MARGINS   

• SCALE WITH DOCUMENT

• DIFFERENT FIRST PAGE

• DIFFERENT ODD & EVEN PAGES

If you don’t want a row to print on a page by itself or you don't want a table header row to be the last line on a page. MS Excel gives you precise control over this through this feature.

• FREEZE PANES

• CONDITIONAL FORMATTING

• PAGE BREAK

• SHEET OPTIONS

For example, if you want row 14 to be the first row of a new page, select cell A14. Then choose Page Layout » Page Setup Group » Breaks » Insert Page Break.

• a.      REMOVE A PAGE BREAK YOU’VE ADDED

• INSERT VERTICAL PAGE BREAK

• INSERT HORIZONTAL PAGE BREAK

• REMOVE ALL MANUAL PAGE BREAKS

In this case, make sure to place the pointer in row 1. Choose Page Layout » Page Setup » Breaks » Insert Page Break to create the page break

• REMOVE A PAGE BREAK YOU’VE ADDED

• INSERT VERTICAL PAGE BREAK

• INSERT HORIZONTAL PAGE BREAK

• REMOVE ALL MANUAL PAGE BREAKS