EL1 C5 Flashcards
Specify how cells are pasted in a worksheet with options at which of the following?
the Paste Options button drop-down list
Display a shortcut menu with options for managing worksheets by…
right-clicking a worksheet tab
Instead of using the sheet tab shortcut menu, you can copy a worksheet by doing which of the following?
pressing and holding down the Ctrl key while dragging the worksheet tab from one location to another
One method of moving to a range of cells is by using options at the _____ dialog box.
Go To
After selecting cells to be moved and clicking the Cut button, how do you move them to their new location?
Click the cell where the first selected cell should be inserted and then click the Paste button
The moving dashed line border that surrounds cells after you have selected them and clicked the Copy button is called a…
marquee
A group of selected cells is referred to as a…
range
You can move to a different worksheet in a workbook by…
clicking the desired worksheet tab
The Define Name button is in the Defined Names group on the _____ tab.
Formulas
When pasting cells that contain a value and a formula, you can use options at the Paste Option button drop-down list to insert all the following except…
the formula as a value
Use the _____ and _____ buttons in the upper right corner of the active workbook to change the size of the active workbook in the screen.
Maximize; Minimize
Where are the tab scroll buttons that allow you to navigate the worksheet tabs?
left of the sheet tabs
To see which workbooks are open, hover the mouse pointer over the _____ to display thumbnails of the workbooks.
Excel button on the taskbar
By clicking the Hide button in the Window group on the View tab, you can…
hide the active workbook
Which of the following is not a formatting option when pasting Excel data in a Word document?
embed text
Excel allows linking data between which of the following?
worksheets in the same or different workbooks
Arrange the display of _____ at the Arrange Windows dialog box.
multiple workbooks that are open at the same time
Excel’s split window feature is useful for displaying…
(?)
To link data between worksheets, begin by doing which of the following?
making active the cell(s) containing the data to be linked
The _____ button provides a variety of options for pasting data in a worksheet, another workbook, or a document created in another program.
Paste Options
Use _____ to collect and paste multiple items.
the Clipboard task pane
In a workbook with multiple worksheets, which worksheet will Excel print by default?
the worksheet that is currently displayed
How can you see a list of what workbooks are currently open?
by clicking the View tab and then clicking the Switch Windows button in the Window group
Which of the following is not one of the options at the Arrange Windows dialog box?
Diagonal
When a worksheet window is split, each section is referred to as a…
pane
Use keyboard command Ctrl + _____ to copy selected data.
C
A range of cells cannot be…
given a name containing a space
You can copy and paste data between Excel and…
Word
Which of the following is not one of the options for moving data from one section of a worksheet to another?
the Format Cells button in the Cells group on the Home tab
When data in Excel is linked, the worksheet that contains the original data is referred to as the _____ worksheet.
source
Which of the following tasks cannot be performed at the sheet tab shortcut menu?
format a worksheet
Select nonadjacent worksheet tabs by clicking the first sheet tab, pressing and holding down the _____ key, and then clicking other tabs to be selected.
CTRL
You can name a range by selecting the cells and then typing a name into…
the Name box
Split lines display in a worksheet as….
thick light grey lines
When you move a worksheet by dragging it, what icon appears next to the mouse pointer?
a page icon
What happens when you select cells in a worksheet and then click the Copy button?
a moving dashed line border appears around the cells
A new Excel workbook contains _____ worksheet(s) by default, but additional worksheets can be added.
one
What should you do first to copy cells?
Select the cells to be copied
Use the Delete button in the _____ group on the _____ tab to delete a worksheet.
Cells; Home
How do you display the Clipboard task pane?
Click the Clipboard group task pane launcher in the Clipboard group on the Home tab
You can open nonadjacent workbooks at one time at the Open dialog box by clicking the name of the first workbook, pressing and holding down the _____ key, and then clicking the names of the other workbooks.
CTRL
You can print multiple worksheets in a workbook with options…
at the Print backstage area
A worksheet window can be split in which of the following ways?
horizontally and vertically
What happens when you freeze the window panes?
Only one active cell is displayed when you cross a pane boundary
The combining of data from files created by two or more programs (e.g., Excel and Word) into one file is referred to as…
integration