Name:     ID: 
 
Email: 

Microsoft Excel Lesson 1

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

 1. 

The easiest way to change the active cell in a worksheet is to click Cell on the Ribbon and type in the cell’s location.
 

 2. 

Microsoft Office Excel 2010 is the presentation program in Microsoft Office 2010.
 

 3. 

The Excel program window has the same basic parts as all Office programs: the title bar, the Quick Access Toolbar, the Ribbon, Backstage view, and the status bar.
 

 4. 

The Save As command saves an existing workbook on a disk, using its current name and save location.
 

 5. 

If a cell is not wide enough to display all the cell’s contents, extra text extends into the next cells if there is room.
 

 6. 

The contents of the active cell always appear in the Formula Bar.
 

 7. 

The Formula Bar appears to the right of the Name Box and displays a formula when the cell of a worksheet contains a calculated value.
 

 8. 

Saving a workbook means loading an existing workbook file from a disk into the program window.
 

 9. 

To clear the active cell, you can use the Ribbon, the keyboard, or the mouse.
 

 10. 

The cell in the worksheet in which you can type data is called the open cell.
 

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

 11. 

To replace cell contents, you can select the cell, type the new data, and then enter the data by  ____.
a.
pressing the Tab key
b.
clicking the Enter button on the Formula bar
c.
pressing the Enter key
d.
all of the above
 

 12. 

To edit the data directly in a cell, make the cell active and then press the ____ key or double-click the cell.
a.
F1
c.
F3
b.
F2
d.
F4
 

 13. 

The default magnification for a workbook is ____, which you can see on the Zoom level button.
a.
0%
c.
90%
b.
80%
d.
100%
 
 

FIGURE EX 1-1

nar001-1.jpg
 

 14. 

Referring to Figure EX 1-1 above, if you wanted to find an entry for an employee’s name which may be misspelled, and you cannot remember if you capitalized the first and last name, you would choose the following search option: ____.
a.
Match entire cell contents
c.
both a. and b.
b.
Match case
d.
neither a. nor b.
 

 15. 

Referring to Figure EX 1-1 above, if you entered an incorrect value in one of the cells and wanted to find it, you would choose “cell contents” as your place to search in the ____ option box.
a.
Replace with
c.
Within
b.
Look in
d.
Search
 
 
Case EX 1-1
Nicole has not used Excel before and is getting used to the different pointer shapes that Excel shows, depending on the action you are taking.
 

 16. 

Nicole notices that the point changes shape to become a ____ when it is in the worksheet.
a.
black arrow
c.
white arrow
b.
thick black plus sign
d.
thick white plus sign
 
 
Case EX 1-2
Donovan is starting to use the keyboard to navigate around an Excel spreadsheet.
 

 17. 

To move to cell A1, Donovan presses the ____ .
a.
Page Up key
c.
Ctrl+End keys
b.
Page Down key
d.
Ctrl+Home keys
 

 18. 

To move down one window, Donovan presses the ____.
a.
Page Down key
c.
Page Up key
b.
Ctrl+End keys
d.
Ctrl+Home keys
 

 19. 

The ____, or cell reference area located below the Ribbon, displays the cell reference of the active cell.
a.
Name Box
c.
Name Pane
b.
Formula Bar
d.
Name Space
 

 20. 

You can use wildcard characters in the Find what box to search for data that matches a particular pattern. Use ____ for two or more characters.
a.
! (an exclamation point)
c.
? (a question mark)
b.
* (an asterisk)
d.
# (a pound sign)
 

 21. 

The name of each worksheet appears in the ____ at the bottom of the worksheet window.
a.
sheet dialog box
c.
sheet box
b.
sheet tab
d.
sheet task bar
 

 22. 

To use the Replace command, in the ____ group on the Home tab of the Ribbon, click the Find & Select button, and then click Replace.
a.
Proofing
c.
Editing
b.
Formulas
d.
Data
 

 23. 

You can change the active worksheet in a workbook to next worksheet by pressing the ____+Page Down keys.
a.
Tab
c.
Fn
b.
Ctrl
d.
Alt
 

 24. 

Numbers that extend beyond a cell’s width appear as ____ in the cell.
a.
####
c.
&&&&
b.
????
d.
++++
 

 25. 

If you want to see more cells in the work area, click the Zoom Out button or drag the Zoom slider to the ____ to decrease the zoom percentage.
a.
left
c.
either a. or b.
b.
right
d.
neither a. nor b.
 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
Workbook
b.
Active worksheet
c.
Cell reference
d.
Worksheet
e.
Spreadsheet
 

 26. 

A grid of rows and columns in which you enter text, numbers, and the results of calculations. 
 

 27. 

The worksheet that is displayed in the work area.
 

 28. 

The file used to store worksheets.
 

 29. 

Identifies the cell, and is formed by combining the cell’s column letter and row number.
 

 30. 

A computerized spreadsheet.
 



 
         Start Over