Name: 
 

Computer Literacy Module 2 Lesson 16


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

 1. 
A workbook is different from a spreadsheet.
 

 2. 
A spreadsheet is a grid of rows and columns containing only numbers.
 

 3. 
When data is too wide to fit in a cell, the part that does not fit will be deleted.
 

 4. 
To remove cell data, you can simply press the Delete key.
 

 5. 
The AutoCheck feature automatically corrects common typing mistakes as you enter text.
 

 6. 
You can use multiple fonts in one document.
 

 7. 
By default, Excel aligns text at the right of the cell and numbers at the left of the cell.
 

 8. 
All cells in a range touch each other and form a rectangle.
 

 9. 
Dates are automatically formatted in the default style dd-mm-yy.
 

 10. 
When you insert or delete a column or a row in Excel, it affects the entire worksheet.
 

 11. 
If you undo an action and then change your mind, you cannot reverse the undo action.
 

 12. 
If you undo an action from the Undo list, Excel will also undo all actions listed above it on the list.
 

 13. 
You can delete more than one row or column at a time.
 

 14. 
When you delete the contents of a cell using the Delete or Backspace keys, the formats for the cell remain in the cell.
 

 15. 
Text in an Excel spreadsheet automatically wraps within the cell.
 

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

 16. 
In the Excel worksheet, the mouse pointer displays as a(n) ____.
a.
pointer finger
c.
thick plus sign
b.
arrow
d.
crosshair
 

 17. 
Columns are identified by ____.
a.
numbers
c.
column names
b.
field names
d.
letters
 

 18. 
The intersection of a single row and a single column is called a ____.
a.
cell
c.
field
b.
cell reference
d.
frame
 

 19. 
In Excel, a heavy black border designates the ____.
a.
main cell
c.
default cell
b.
active cell
d.
cell reference
 

 20. 
The ____ feature corrects common mistakes as you enter data.
a.
AutoCorrect
c.
AutoComplete
b.
AutoFill
d.
AutoCheck
 

 21. 
The ____ tab in the Format Cells dialog box offers options for outlining a cell or range of cells.
a.
Patterns
c.
Border
b.
Gridline
d.
Alignment
 

 22. 
The ____ feature compares the first few characters you key in a cell with existing entries in the same column. If the characters match an existing entry, Excel proposes the existing entry.
a.
AutoCorrect
c.
AutoComplete
b.
AutoFill
d.
AutoCheck
 

 23. 
When the data is too wide for the cell, Excel ____.
a.
displays a series of number signs (####)
b.
allows the data to run outside of the column
c.
cuts off the data displayed
d.
all of the above
 

 24. 
To change the column width, you can ____.
a.
open the Format menu, choose Column, and then choose AutoFit Selection
b.
drag the right edge of the column heading
c.
open the Format menu, choose Column, and then choose Width
d.
all of the above
 

 25. 
When you add a new column, the data shifts to the ____.
a.
left
c.
top
b.
right
d.
bottom
 

 26. 
____ is a quick way to copy identical values to a series of adjacent cells.
a.
Filling
c.
AutoInsert
b.
AutoCell
d.
Insert
 

 27. 
To move the insertion point to the last cell with data in a row, you would ____.
a.
press Ctrl + right arrow
c.
triple-click
b.
press F5
d.
either a or b
 

 28. 
If you choose not to enter data you have keyed, you can ____.
a.
click the Cancel button in the Formula Bar
b.
press the Esc key
c.
click the No Data button on the Standard toolbar
d.
either a or b
 

 29. 
The default unit of measurement for row height in Excel is ____.
a.
centimeters
c.
pixels
b.
inches
d.
points
 

 30. 
To select an entire row, you would ____.
a.
click the Select Row button on the Standard toolbar
b.
double-click in any cell in the row
c.
click the row number at the left of the screen
d.
press Ctrl + right arrow
 

Completion
Complete each sentence or statement.
 

 31. 
In Excel, the small square in the bottom-right corner of the selected cell is called the ____________________.
 

 

 32. 
To remove both the contents and the formats, you must ____________________ the cell.
 

 

 33. 
The ____________________ identifies the column letter and row number.
 

 

 34. 
The selected cell where you can enter data is called the ____________________ cell.
 

 

 35. 
____________________ in a worksheet are identified by numbers.
 

 

 36. 
When you enter data in a cell in a worksheet, it also appears in the ____________________ Bar.
 

 

 37. 
A(n) ____________________ may contain several worksheets.
 

 

 38. 
To accept an entry proposed by Excel’s AutoComplete feature, you press the ____________________ key.
 

 

 39. 
To allow Excel to find the best column width for the data in the column, choose the _________________________ option from the Column submenu on the Format menu.
 

 

 40. 
When you copy data in a worksheet, you temporarily store it on the ____________________ before you paste it in another location.
 

 

 41. 
To quickly fill data down in a column, click in the destination cell and press the shortcut key combination ____________________.
 

 

 42. 
To change the color of the type font in a cell, click the ____________________ button on the Formatting toolbar.
 

 

 43. 
You access the ____________________ tab in the Format Cells dialog box to add a shading pattern to selected cells.
 

 

 44. 
To display numbers with a currency format, you select the ____________________ tab in the Format Cells dialog box.
 

 

 45. 
A selected group of cells is called a(n) ____________________.
 

 

 46. 
You can use the ___________________ to copy the format of a worksheet cell without copying the contents.
 

 

 47. 
The default view of an Excel worksheet is a magnification of ____________________ percent.
 

 

 48. 
There is a limit of ____________________ actions you can undo and redo.
 

 

 49. 
When you open Excel, a new worksheet appears named ____________________.
 

 

 50. 
A(n) ____________________ is used to gather, organize, and summarize text and numeric data.
 

 



 
Check Your Work     Reset Help