unit 4 Copy, Paste and Printing in Excel
One way to reuse the contents of cells is to use the copy and paste commands. Another is to use your mouse and drag the __________ of a cell.-c-d wrong-Function key (fn) Ctrl key Insert key alt key tab key
*Fill handle
Which of the following is frequently modified to improve the appearance of printed Excel worksheets?c-a wrong-Filters Macros Worksheet Protections Hyperlinks Frozen Panes Pivot Tables
*Margins*/Orientation/Headers
Which of the following options are available when you select the print command?c-d wrong-Page Layout, Print area Print using portrait page style Page Layout, Clear Print area Print current view
*Print active sheets/Print entire workbook/Print selection
When you copy or move a formula, Excel does not duplicate it exactly. It actually copies the cell references relative to the location of the formula, this is which of the following?a-a wrong-absolute cell referencing cell referencing nominal cell referencing cell contents cell location
*relative cell addressing
How do you select noncontiguous cells?c wrong-Click in a cell, then hold down ALT on the keyboard as you select the other cells. Click a cell, then hold down SHIFT on the keyboard and select the other cells. Click in a cell, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard.
Click in a cell, then hold down CTRL on the keyboard and then select the other cells.
How do you select continuous cells?b-b wrong-Click in a cell, then hold down TAB on the keyboard as you select the other cells. Click in a cell, then hold down TAB as you move from cell to cell using the Arrow keys on the keyboard. Click in a cell, then hold down ALT on the keyboard as you select the other cells. Click in a cell, hold down CTRL on the keyboard and then select the other cells.
Click in a cell, then hold down SHIFT as you move from cell to cell using the Arrow keys on the keyboard.
Text can be arranged on a page in __________ (vertical or long format) or __________ (horizontal or wide format).-a-a wrong-Landscape; Portrait Page Orientation; Printing Menu Page Layout Margins Tall; Wide
Portrait; Landscape
You may run into a situation where you do not want the cell references to change as they are copied or moved. In that case, it is possible to create a(n) __________ in a formula.-a-a wrong-relative cell address cell address cell location nominal cell address
absolute cell address
If you choose Cut instead of Copy, the contents of the cells will be __________ instead of copied.-b-b wrong-will be deleted will be moved to a former position will be placed on the clipboard indefinitely will be placed on the clipboard temporarily and then deleted when quit Excel
moved to the new location
