Name:     ID: 
 
Email: 

Excel Chapter Three

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

 1. 

You can ensure correctness in your formulas by carefully checking them using _____.
a.
Range Finder
c.
the requirements document
b.
the Ribbon
d.
Backstage view
 

 2. 

When you first enter text, its angle is _____ degrees, and it reads from left to right in a cell.
a.
45
c.
0
b.
75
d.
125
 

 3. 

Which of the following cell contents is extended to Qtr3, Qtr4, and Qtr1 by dragging the fill handle?
a.
Quarter 1
c.
Qtr2
b.
Qtr1
d.
Quarter4
 

 4. 

Which of the following patterns extends the fill series to 575, 550, 525?
a.
650, 600
c.
560, 580
b.
625, 600
d.
500, 475
 

 5. 

Which of the following is an extension of the fill pattern Sunday, Tuesday?
a.
Wednesday, Thursday, Saturday
c.
Saturday, Sunday, Monday
b.
Thursday, Saturday, Monday
d.
Monday, Wednesday, Friday
 

 6. 

Which of the following is the path to the Increase or Decrease Indent button?
a.
(Home tab | Clipboard group)
c.
(Home tab | Alignment group)
b.
(Home tab | Editing group)
d.
(Home tab | Number group)
 

 7. 

The Increase Indent button indents the contents of a cell to the right by ____ spaces each time you click it.
a.
three
c.
two
b.
four
d.
five
 

 8. 

The Copy button copies the contents and format of the source area to the Office ____, a reserved place in the computer’s memory.
a.
Ribbon
c.
Folder
b.
Clipboard
d.
File
 

 9. 

Using the mouse to move or copy cells is called _____.
a.
drop and drag
c.
drag and copy
b.
drag and drop
d.
drag and paste
 

 10. 

Which of the following is the path to the Insert button?
a.
(Home tab | Editing group)
c.
(Home tab | Cells group)
b.
(Home tab | Number group)
d.
(Home tab | Inserting group)
 

 11. 

When assigned to a cell, the _____ function returns a number that corresponds to the actual current system date and time.
a.
SYSDATE
c.
DATETIME
b.
NOW
d.
CURRENT
 

 12. 

Which of the following formulas contains an absolute cell reference?
a.
=$B4
c.
=$B$4
b.
=B$4
d.
=B4
 

 13. 

The _____ function is useful when you want to assign a value to a cell based on a logical test.
a.
IF
c.
AND
b.
NOW
d.
OR
 

 14. 

Which comparison operator means “not equal to”?
a.
<=
c.
<
b.
>
d.
<>
 

 15. 

_____ refers to cells not wide enough to display the entire entry.
a.
#####
c.
$$$$$
b.
&&&&&
d.
+++++
 

 16. 

A(n) _____ chart provides a simple way to show trends and variations in a range of data within a single cell.
a.
Sparkie
c.
Special
b.
Sparkline
d.
Sparkle
 

 17. 

You should use a _____ chart to show the relationship or proportion of parts to a whole.
a.
Column
c.
Line
b.
Bar
d.
Pie
 

 18. 

A(n) _____ is a separate sheet in a workbook that contains only a chart.
a.
worksheet
c.
chart sheet
b.
dialog box
d.
range
 

 19. 

A Pie chart with one of more slices offset is called a(n) _____.
a.
maximized Pie chart
c.
imploded Pie chart
b.
exploded Pie chart
d.
moving Pie chart
 

 20. 

Which of the following is the path to the Zoom button?
a.
(View tab | Zoom group)
c.
(Insert tab | Zoom group)
b.
(Home tab | Zoom group)
d.
(Zoom tab | View group)
 



 
         Start Over