| A | B |
|---|
| Formatting | Refers to the process of changing the appearance of the data to draw attention to parts of the worksheet. |
| To apply formatting from dialog boxes: | On Home tab, in Cells group, click Format. click Format Cells or On Home tab, in Font, Alignment or Number group, click the Dialog box launcher |
| Font | A style of text |
| Borders | Help separate groups of data to improve readability |
| Format Painter | Once formatting is established on the worksheet, can duplicate formatting options on other parts of spreadsheet |
| To activate the spell check: | On Review tab, in Proofing group, click Spelling |
| Organize or sort data in worksheet | based on values in columns |
| To sort data: | On Data tab, in Sort & Filter group, click Sort A to Z or Sort Z to A or On Home tab, in Editing group, click Sort & Filter |
| To preview worksheet: | Click Office Button, point at Print, Print Preview |
| Why preview a worksheet? | To see how the worksheet looks and whether it fits on the page with the existing settings. |
| To set a page break: | On Page Layout tab, in Page Setup group, click Breaks |
| Orientation | Portrait (vertical) or Landscape (horizontal). |
| Scaling | Magnify or shrink proportionally, or automatic scale to “fit” specified pages. |
| Paper size | Specify size of paper to print. |
| Print quality | Determines density of print characters. |
| First page number | Specify starting page number. |
| Margin Tabs | Set amount of white space for each side of page |
| Header | printed at top of every page. |
| Footer | printed at bottom of every page |
