NEW
Font size
WorksheetsExcel Lesson 3 Review
Total questions: 20
Worksheet time: 10mins
You are tired of typing repetitive data (over and over) again. What can you do?
Fill or Copy
Insert
You want to be sure that all words are spelled correctly in the worksheet. What can you do?
Word Finder
Document Checker
Spell Checker
What do you press while using the Drag and Drop Method?
CTRL key
Shift key
Just hold down the mouse
To move the contents in a cell.
Copy
Fill
Cut
You forgot to type a row of data in the middle of the worksheet.
Insert Sheet Column
Insert Sheet Row
Insert Cell
A portion of the worksheet would be more useful in another area of the worksheet.
Cut & Paste
Copy & Paste
What type of border do you get when you copy or cut data?
Solid border
Green border
Flashing border
The Fill commands are available only if you are copying data to cells adjacent to the original cell.
True
False
Deleting a row or column erases the data in that row or column.
True
False
The black cross in the lower-right corner of the active cell or range that you drag over the cells you want to fill.
Fill Handle
Fill Select
Fill Copy
You no longer need a certain column in the worksheet.
Delete sheet row
Delete sheet column
Insert sheet column
To keep selected rows and / or columns of the worksheet visible on the screen as the rest of the worksheet scrolls.
Split Panes
Freeze Panes
Divide Panes
The Office Clipboard can hold 34 items.
True
False
Which method is used for copying selections short distances?
Cut, Copy, Paste
Fill
Drag and Drop
When using the Drag & Drop Method, your mouse arrow changes to what?
Two headed arrow
Cross
Four headed arrow
Which group on the ribbon can you locate the Insert button?
Clipboard
Font
Cells
Numbers
Which Tab can you locate the Freeze Panes button?
Home
Insert
View
Data
When you freeze panes, you select the row below the one you want to freeze?
True
False
Which Tab can you locate the Spell Check feature?
Home
Insert
Review
View
The Fill Handle copies both the content AND the formatting to an adjacent cell or range.
True
False
