Name:     ID: 
 
Email: 

Microsoft Excel Lesson 3

True/False
Indicate whether the statement is true or false.
 

 1. 

Pasting replaces any content already in the cell.
 

 2. 

You can use shortcut keys to quickly cut, copy, and paste cells.
 

 3. 

The Transfer command pastes a row of cells into a column, or a column of cells into a row.
 

 4. 

The drag-and-drop method is the slowest way to copy or move data short distances in a worksheet.
 

 5. 

If you select more than one row or column, the same number of rows or columns you selected is inserted in the worksheet.
 

 6. 

You can right-click a cell or selected range, and then click Insert on the shortcut menu to open the Insert dialog box.
 

 7. 

To freeze panes, on the View tab of the Ribbon, in the Window group, click the Freeze Panes button, and then click Freeze Panes.
 

 8. 

You can split the worksheet window into horizontal or vertical panes, but not both.
 

 9. 

Design view is helpful when you prepare a worksheet for printing.
 

 10. 

By default, Excel is set to print pages in landscape orientation.
 

Multiple Choice
Identify the choice that best completes the statement or answers the question.
 

 11. 

The Office Clipboard is a temporary storage area for up to ____ selections you copy or cut.
a.
10
c.
24
b.
12
d.
30
 

 12. 

After you copy and paste, the ____ button appears next to the cell or range with the pasted item.
a.
Paste Parameters
c.
Paste Options
b.
Paste Format
d.
Paste Selection
 

 13. 

Click the Ctrl+C keys to ____ selected cells.
a.
copy
c.
paste
b.
cut
d.
move
 

 14. 

Click the Ctrl+V keys to ____ the selected cells.
a.
copy
c.
paste
b.
cut
d.
move
 

 15. 

To access the Clipboard task pane, click the Clipboard Dialog Box Launcher on the ____ tab of the Ribbon. The Clipboard task pane appears in a separate pane along the left side of the worksheet.
a.
Format
c.
Data
b.
Home
d.
Edit
 

 16. 

To use the drag-and-drop method, select the cell or range you want to move or copy. Then, position the pointer on the top border of the selected cells. The pointer changes from a white cross to a  ____  arrow. To move the selected cells, drag them to a new location.
a.
one-headed
c.
three-headed
b.
two-headed
d.
four-headed
 

 17. 

On the Home tab of the Ribbon, the ____ group includes buttons for inserting and deleting rows, columns, and cells.
a.
Format
c.
Workbook
b.
Worksheet
d.
Cells
 

 18. 

To insert a row, click the ____ to select the row where you want the new row to appear. Then, click the Insert button in the Cells group on the Home tab.
a.
row heading
c.
column letter
b.
row letter
d.
column number
 

 19. 

To check the spelling in a worksheet, click the Review tab on the Ribbon, and then, in the ____ group, click the Spelling button.
a.
Editing
c.
Checking
b.
Proofing
d.
Searching
 

 20. 

Worksheets printed in ____ orientation are wider than they are long.
a.
portrait
c.
wide
b.
landscape
d.
normal
 

 21. 

Excel inserts ____whenever it runs out of room on a page.
a.
a blank row
c.
an automatic hyperlink
b.
an automatic page break
d.
a paragraph marker
 

 22. 

The simplest way to adjust page breaks in a worksheet is in ____.
a.
Page Break Preview
c.
Design View
b.
Layout View
d.
Controls View
 
 
FIGURE EX 3-1

nar001-1.jpg
 

 23. 

The area marked with the number 3 in Figure EX 3-1 above, shows ____scrolled out of view.
a.
rows 3 through 16
c.
columns A through D
b.
rows 4 through 15
d.
columns B through D
 
 
Case EX 3-1
Vanessa is learning how to split a worksheet window.
 

 24. 

What should Vanessa do to start the process of splitting a window horizontally?
a.
Select a row
c.
Select a cell
b.
Select a column
d.
Select a worksheet
 
 
Case EX 3-2
Ben is preparing his worksheet to print and is making adjustments to the margin and print area.
 

 25. 

Ben had set a print area earlier and now he wants to print the entire worksheet.  To clear the print area, Ben would choose the Page Layout tab in the Page Setup group, click the ____ button, and then click Clear Print Area.
a.
Print Range
c.
Print Entire Page
b.
Print Margins
d.
Print Area
 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
Paste
b.
Margins
c.
Cut
d.
Scale
e.
Copy
 

 26. 

Enables you to resize a worksheet to print on a specific number of pages.
 

 27. 

Blank spaces around the top, bottom, and sides of a page.
 

 28. 

Duplicates the cell’s contents without affecting the original cell.
 

 29. 

The selected cell contents are placed as an item on the Clipboard and are removed from their original location.
 

 30. 

Places the last item from the Clipboard into the cell or range selected in the worksheet.
 



 
         Start Over