Name:     ID: 
 
Email: 

EXCEL 3

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

 1. 
The Rand( ) function falls under the Statistical category.
 

 2. 
A mixed reference “locks” one part of the cell reference while the other part can change.
 

 3. 
If a formula contains several functions, Excel starts with the outermost function and then moves inward.
 

 4. 
Using the AutoFill feature is more efficient than copying and pasting.
 

Modified True/False
Indicate whether the statement is true or false.  If false, change the identified word or phrase to make the statement true.
 

 5. 
The OR function is a logical function that returns one value if the statement is true and returns a different value if the statement is false. ____________________

 

 6. 
$B$8 is an relative reference to cell B8. ____________________

 

 7. 
Excel allows you to cycle through the different reference types using the F2 key. ____________________

 

 8. 
A mixed formula contains both relative and absolute references. ____________________

 

Matching
 
 
Identify the letter of the choice that best matches the phrase or definition.
a.
NOW
g.
F4
b.
PMT function
h.
Absolute references
c.
Principal
i.
nested
d.
Simple interest
j.
mixed
e.
fv
k.
Mon, Tues, Wed, Thurs, Fri
f.
<
l.
Median
 

 9. 

 Optional argument in the PMT function
 

 10. 

 Used to cycle through reference types
 

 11. 

 AutoFill pattern
 

 12. 

 A function inside another function
 

 13. 

 To calculate payments for any type of loan
 

 14. 

 Equal to a percentage of principal for each period that the money has been lent
 

 15. 

 A comparison operator
 

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

 16. 
Which of the following is not a function? ____
a.
AVERAGE
c.
CUBE
b.
SUM
d.
MEDIAN
 

 17. 
The FV function stands for ____.
a.
function value
c.
financial value
b.
future value
d.
formulated value
 

 18. 
The fill handle copies ____.
a.
formats
c.
formats and formulas
b.
formulas only
d.
formats and cell references
 

 19. 
If an optional argument is not included, Excel assumes a(n) ____ value for it.
a.
default
c.
static
b.
generic
d.
absolute
 

 20. 
Which of the following is a Statistical function?
a.
INT
c.
ROUND
b.
RAND
d.
AVERAGE
 
 
nar002-1.jpg
 

 21. 
Item 1 in the figure above is called the  ____.
a.
AutoFill tool
c.
Selection handle
b.
Fill handle
d.
AutoFit tool
 

 22. 
When you click Item number 2 in the figure above, ____appears.
a.
a list of functions
c.
the Mini toolbar
b.
a list of options
d.
the Format Painter
 

 23. 
When you copy a formula that contains an absolute reference to a new location, the reference
____.
a.
is updated automatically
c.
becomes bold
b.
does not change
d.
has a dotted outline in its cell
 
 
nar003-1.jpg
 

 24. 
In the figure above, pv stands for the ____.
a.
payments verified
c.
present value of the loan
b.
principal value of the loan
d.
primary interest rate of the loan
 

 25. 
When you nest functions, you should have ____.
a.
the equal sign
b.
the same number of left and right parentheses
c.
at least two functions
d.
the correct number of brackets
 

 26. 
In the Fill Series dialog box, you can choose ____.
a.
how a series grows
c.
the stopping value
b.
how fast a series should grow
d.
all of the above
 
 
nar001-1.jpg
 

 27. 
Item 1 in the figure above is a result of  ____.
a.
entering a function in a cell
b.
entering MI in a cell
c.
right-clicking a cell to choose from a list of functions
d.
both a and b are correct
 
 
nar004-1.jpg
 

 28. 
What is the name of the button that item 4 is pointing to in the figure above? ____
a.
Collapse Dialog Box
c.
List Values
b.
Expand Dialog Box
d.
Define Function
 

 29. 
Which function is used to change  3,162.50 to  3,163? ____
a.
RAND
c.
DROP
b.
ROUND
d.
ROUNDUP
 

 30. 
Which function category retrieves data from multidimensional databases involving online analytical processing or OLAP? ____
a.
Database
c.
Text
b.
Cube
d.
Financial
 

 31. 
Which of the following is a Math & Trig function? ____
a.
INT
c.
ROUND
b.
RAND
d.
AVERAGE
 

 32. 
The ____ is most often used with data that has only a few possible values.
a.
mode
c.
middle
b.
median
d.
sum
 

 33. 
The most common approach to summarize data is to ____ it.
a.
record
c.
count
b.
average
d.
organize
 

Completion
Complete each statement.
 

 34. 
____________________is an Excel function category that returns information about the format, location, or contents of worksheet cells.
 

 

 35. 
Not all functions have arguments, and some functions have ____________________ arguments, which are not required for the function to return a value, but can be included to provide more control over the returned value.
 

 

 36. 
To insert a function, click the ____________________ tab on the Ribbon.
 

 

 37. 
For more complex patterns, you can use the ____________________ dialog box instead of the AutoFill feature.
 

 

 38. 
____________________ copies content and formats from a cell or range into an adjacent cell or range.
 

 

 39. 
The small black square in the lower-right corner of a selected cell or range is called the ____________________.
 

 

 40. 
A ____________________ is a named operation that returns a value.
 

 

Essay
 

 41. 
Explain what a logical function is and give an example of when you would use one in Excel 2007.
 

 42. 
Why is it that the TODAY and NOW date functions do not have any arguments?
 



 
         Start Over