EL1 C5 Flashcards
(45 cards)
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
