BIS CH 4 + 5
Clipboard
The Cut, Copy, and Paste buttons are located in this group on the HOME tab.
PAGE LAYOUT
The Margins button is located on this tab.
VIEW
The Split button is located on this tab.
Quick Access
The Undo and Redo buttons are located on this toolbar.
Paste Options
This button displays in the lower right corner of pasted cells.
0.7
This is the default left and right margin measurement.
0.75
This is the default top and bottom margin measurement.
HEADER & FOOTER TOOLS DESIGN
This tab contains options for formatting and customizing a header and/or footer.
Print Entire Workbook
To print all of the worksheets in a workbook, display the Print backstage area, click the first gallery in the Settings category, and then click this option at the drop-down list.
Shift
To select adjacent worksheet tabs, click the first tab, hold down this key, and then click the last tab.
Ctrl
To select nonadjacent worksheet tabs, click the first tab, hold down this key, and then click any other tabs you want selected.
Scale to Fit
Use options in this group on the PAGE LAYOUT tab to adjust the printed output by a percentage to fit the number of pages specified.
Format
Use these buttons at the expanded Find and Replace dialog box to search for specific cell formatting and replace it with other formatting.
Sort & Filter
Use this button in the Editing group on the HOME tab to sort data in a worksheet.
Print Area
Use this button in the Page Setup group on the PAGE LAYOUT tab to select and print specific areas in a worksheet.
filter
Use this feature to temporarily isolate specific data in a worksheet.
Clipboard
Use this task pane to copy and paste multiple items.
source
When linking data between worksheets, the worksheet containing the original data is called this.
one
By default, a workbook contains this number of worksheets.
portrait
By default, a worksheet prints in this orientation on a page.
Page Layout
Click the Header & Footer button in the Text group on the INSERT tab and the worksheet displays in this view.
Sheet
Click the Print Titles button in the Page Setup group on the PAGE LAYOUT tab and the Page Setup dialog box displays with this tab selected.
Options
Click this button in the Find and Replace dialog box to expand the dialog box.
New Sheet
Click this button to insert a new worksheet in a workbook.
Maximize
Click this button to make the active workbook expand to fill the screen.
Minimize
Click this button to reduce the active workbook to a layer behind the Excel button on the Taskbar.
Tab Color
Click this option at the worksheet tab shortcut menu to apply a color to a worksheet tab.
REVIEW
Click this tab to display the Spelling button.
Arrange All
Display the Arrange Windows dialog box by clicking this button in the Window group on the VIEW tab.
