Name:     ID: 
 
Email: 

Excel Chapter One

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

 1. 

The first step in creating an effective worksheet is to make sure you _____.
a.
apply font formatting
c.
insert a chart
b.
understand what is required
d.
enter the data
 

 2. 

To enter data in a cell, you must first select or activate the _____.
a.
row
c.
column
b.
worksheet
d.
cell
 

 3. 

To cancel an entire entry before entering it into the cell, press the _____ key.
a.
ALT
c.
CTRL
b.
ESC
d.
TAB
 

 4. 

Clicking the _____ box completes an entry.
a.
Cancel
c.
Enter
b.
Formula
d.
Tab
 

 5. 

The _____ is a blinking vertical line that indicates where the next typed character will appear.
a.
scroll box
c.
insertion point
b.
sheet tab
d.
split bar
 

 6. 

The _____ feature works behind the scenes, fixing common typing or spelling mistakes when you complete a text entry.
a.
AutoComplete
c.
AutoFormat
b.
AutoCorrect
d.
AutoTyping
 

 7. 

Pressing the _____ key to complete an entry activates the adjacent cell to the right.
a.
RIGHT ARROW
c.
UP ARROW
b.
LEFT ARROW
d.
DOWN ARROW
 

 8. 

By default, text is _____ in a cell.
a.
left-aligned
c.
justified
b.
centered
d.
right-aligned
 

 9. 

In Excel, a number can contain the characters _____.
a.
0 1 2 3 4 5 6 7 8 9
c.
. $ % E e
b.
+ - ( ) , /
d.
all of the above
 

 10. 

To enter a number such as 6,000,000,000,000,000 you can type 6,000,000,000,000,000 or
you can type _____.
a.
6,000T
c.
6Q
b.
6K000
d.
6E15
 

 11. 

A _____ is a series of two or more adjacent cells in a column or row or a rectangular group of cells.
a.
range
c.
nearby cell
b.
bunch
d.
neighbor
 

 12. 

You can enter the correct range in a function by typing the beginning and ending cell references separated by a ____.
a.
semi-colon (;)
c.
period (.)
b.
colon (:)
d.
none of the above
 

 13. 

The _____ is the small black square located in the lower-right corner of the heavy border around the active cell.
a.
selection handle
c.
fill handle
b.
sizing handle
d.
copy handle
 

 14. 

You _____ a worksheet to emphasize certain entries and make the worksheet easier to read and understand.
a.
save
c.
format
b.
print
d.
clear
 

 15. 

You can apply the Bold font style by pressing the _____ keyboard shortcut keys.
a.
ALT+B
c.
SHIFT+B
b.
CTRL+B
d.
TAB+B
 

 16. 

Combining two or more selected cells into one cell is called _____ cells.
a.
merging
c.
combining
b.
mixing
d.
spanning
 

 17. 

Which of the following is the Ribbon path to the Cell Styles button?
a.
(Home tab | Styles group)
c.
(Home tab | Format group)
b.
(Styles tab | Home group)
d.
(Format tab | Styles group)
 

 18. 

A(n) _____ chart is drawn on the same worksheet as the data.
a.
embedded
c.
embodied
b.
emboldened
d.
empowered
 

 19. 

The _____ area on the status bar displays common calculations, such as SUM or AVERAGE, for selected numbers in the worksheet.
a.
AutoFormat
c.
AutoFunction
b.
AutoComplete
d.
AutoCalculate
 

 20. 

The _____ button is located on the Quick Access Toolbar.
a.
Undo
c.
Bold
b.
Cell Style
d.
Increase Decimal
 



 
         Start Over