Excel Ch5
Restore Down
After expanding the active workbook using the Maximize button, you can return the workbook to its original size by clicking the _ button.
freeze
As you move through the panes of a split worksheet window, you may see two active cells. To display only one active cell, _ the window panes.
Hidden
At the Arrange Windows dialog box, which of the following is not one of the options for arranging workbooks?
moving dashed line
Selecting cells and then clicking the Copy button in the Clipboard group on the Home tab causes the cells to display with a _ border
on top of the original workbook
Suppose that you have one workbook open and then open a second. where will the second workbook be placed?
Paste option
The _ button provides a variety of options for pasting data in a worksheet, another workbook, or a document created in another program.
Ctrl
To apply the same formatting to nonadjacent worksheets, select the worksheets by pressing and holding down the _ key while clickin gthe desired worksheet tabs.
Clipboard task pane launcher
To display the Clipboard task pane, click the
Format; Hide sheet
To hide a worksheet, point to Hide & Unhide at the _ button drop-down list and then click the _ option at the shortcut menu.
to the right of the last sheet tab
To insert a new worksheet into a workbook, click the New sheet button located
to the left of the Formula bar
To name a range, select the cells and then click the Name box, which is located
Print backstage area
To print specific worksheets in a workbook, select the tabs of the worksheets to be printed, display the _, and then click the Print button
Cascade
Use the _ option at the Arrange Windows dialog box to display one open workbook on top and the Title bars of the other workbooks behind it.
X
Use the keyboard shortcut Ctrl+_ to cut selected data.
Crt+C
Use the keyboard shortcut to copy selected data.
Ctrl+V
Use this keyboard shortcut to paste selected data
to print the currently displayed worksheet
What is the Excel default print setting?
range
What is the term Excel uses to refer to a selected group of cells?
The change is made automatically to the other cells in the link
When data is linked between two worksheets, what happens when the data is changed in one of the linked cells?
value; formula
When pasting cells that contain a(n) _ and a(n) _, specific what is to be pasted using button options from the paste button or the paste option button drop-down list.
source; dependent
When you link data between two worksheets: the worksheet containing the original data is referred to as the _ worksheet and the worksheet containing the link is referred to as the - worksheet.
linking to email
When you pasted Excel data into a Word document, which of the following is not one of the available formatting options?
into four panes
When you split a worksheet with the Split button how is the worksheet divided?
page
When you use the mouse to move a worksheet, a _ icon displays next to the mouse pointer as the worksheet is dragged to its new location.
50
For a text item copied to the clipboard, the firsst _ characters will appear in the Clipboard task pane.
Window: view
Hide the active workbook by clicking the Hide button in the _ group on the _ tab.
Right-click the worksheet tab
How do you access the tab color option to change the color of a worksheet tab?
Right-click the worksheet tab
How do you display the shortcut menu with options for deleting, moving or copying, and renaming a worksheet?
Use options at the Paste Options drop-down list
How do you paste a cell to a new location and retainonly its value, not also its formula?
Data from tow or more programs can be combined into one file
Microsoft Office is a suite that allows integration. What does this mean?
one; sheett
By default, a workbook contains _ worksheet(s) named _
100%
By default, an Excel worksheet displays at this zoom percentage.
Reduce the active workbook and display it as a layer behind the Excel button on the taskbar.
Clicking the Minimize button inthe ipper right corner of the active workbook will do which of the following?
picture
In addition to pasting data, you can also link data and paste as a object or a _ object.
sheet tab
One of the ways to make a hidden worksheet visible is to right-click a _ and then click Unhide at the shortcut menu.
