Name:     ID: 
 
Email: 

Excel 3 Test

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

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

 

 2. 
To copy only the formats or only the formulas, click the Copy Options button and select
the appropriate option. ____________________

 

 3. 
When you copy and paste a formula with mixed reference to a new location, the absolute portion of the cell reference remains fixed and the relative portion shifts. ____________________

 

 4. 
The following mixed reference in the formula, $A5, has a fixed column reference and a relative row reference. ____________________

 

 5. 
Use relative references when you want to repeat the same formula with different cells. ____________________

 

 6. 
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. ____________________

 

 7. 
When the data includes a few extremely large or extremely small values, it might be best to use the median value from the sample. ____________________

 

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

 

 9. 
You use an absolute reference when you don’t want a cell reference to change. ____________________

 

 10. 
The mode is most often used with data that has only a few possible values, such as the number of bedrooms in a house. ____________________

 

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

 

 12. 
For more complex patterns, you can use the Fill Series dialog box. ____________________

 

 13. 
The most common comparison operator is the greater than sign. ____________________

 

 14. 
AutoFill, which copies content and formats from a cell or range into an adjacent cell or range. ____________________

 

 15. 
The Logical button is part of the Comparison Library group. ____________________

 

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
 

 16. 

 Contains absolute and relative references
 

 17. 

 A comparison operator
 

 18. 

 A statistical function
 

 19. 

 To calculate payments for any type of loan
 

 20. 

 A function inside another function
 

 21. 

 The amount of money loaned
 

 22. 

 AutoFill pattern
 

 23. 

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

 24. 

 Used to cycle through reference types
 

 25. 

 Optional argument in the PMT function
 

 26. 

 Those that are fixed
 

 27. 

 A date function
 

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

 28. 
In “SUM(number1 [, number2, number3, ...])”, number 1, number 2, and number 3 may be numbers or ____.
a.
symbols
c.
operators
b.
letters
d.
cell references
 

 29. 
=MAX(A1:A100)/100 is an example of a(n) ____ function.
a.
logical
c.
nested
b.
absolute
d.
complex
 

 30. 
Most Recently Used is a(n) ____.
a.
command on the Office Button menu
b.
category in the Function Arguments dialog box
c.
category in the Insert Function dialog box
d.
group on the Formula tab on the Ribbon
 

 31. 
The ____ category of Excel functions returns (true-false) values
a.
Math & Trig
c.
Statistical
b.
Logical
d.
Information
 

 32. 
In the formula =IF(A1=B1, C1, C2), the result will be C2 if ____.
a.
A1+B1 is equal to C1
c.
A does not equal B
b.
A is equal to B
d.
none of the above
 

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

 34. 
Item 2 in the figure above is called the ____ button.
a.
Format Painter
c.
Fill Options
b.
AutoFill Options
d.
AutoFill Pattern
 

 35. 
The months shown in the figure above are an example of a(n) ____ made by dragging Item number 1.
a.
sequence
c.
series
b.
pattern
d.
both b and c are correct
 

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

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

 38. 
The numbers, text, or cell references used by the function to return a value are called ____.
a.
arguments
c.
data
b.
expressions
d.
values
 
 
nar002-1.jpg
 

 39. 
In the figure above, fv and type are ____.
a.
comparison operators
c.
required arguments
b.
optional arguments
d.
financial functions
 

 40. 
In the figure above, nper stands for the ____.
a.
total number of payment periods required to pay off the interest
b.
number of interest payments per year
c.
number of payments per year
d.
total number of payment periods required to pay off the loan
 

 41. 
Functions can be ____.
a.
incorporated as part of larger formulas
c.
placed inside another function
b.
nested
d.
all of the above
 

 42. 
The Insert Function button is in the ____ group.
a.
Home
c.
Calculation
b.
Function Library
d.
Sort & Filter
 

 43. 
Which function counts how many cells in a range contain numbers, where value1, value2, and so forth are text, numbers, or cell references?
a.
SUM
c.
COUNTA
b.
AUTOSUM
d.
COUNT
 
 
nar003-1.jpg
 

 44. 
Which item in the figure above is the optional argument? ____
a.
1
c.
3
b.
2
d.
4
 

 45. 
Which item in the figure above is the description of the function? ____
a.
1
c.
3
b.
2
d.
5
 

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

 47. 
Which item in the figure above is the required argument? ____
a.
1
c.
3
b.
2
d.
4
 

 48. 
Where will item 5 also be displayed? ____
a.
in the description of the argument
c.
in the formula bar
b.
in the worksheet
d.
in the Insert Function dialog box
 

 49. 
60%-Accent6 is an example of a cell ____.
a.
size
c.
height
b.
border color
d.
style
 

 50. 
The ____ category of Excel functions retrieves data from multidimensional databases involving online analytical processing.
a.
Text
c.
Logical
b.
OLAP
d.
CUBE
 

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

 52. 
As you drag the fill handle, you will see ____.
a.
the AutoFill Options button flashing
c.
accents
b.
ScreenTips
d.
the AutoFill wizard
 

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

 54. 
Which type of ____ references should you use when you want different formulas to refer to the same cell.
a.
absolute
c.
relative
b.
fixed
d.
mixed
 

 55. 
>= is a(n) ____ operator.
a.
comparison
c.
mathematical
b.
absolute
d.
statistical
 

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

 57. 
The Insert Function dialog box has a(n) ____ option.
a.
formatting
c.
expand/collapse
b.
find and replace
d.
search
 

 58. 
The ____ category of Excel functions retrieves and analyzes data.
a.
Logical
c.
Information
b.
Text
d.
Database
 

 59. 
Lookup & Reference is ____.
a.
Excel 2007’s online Help system
b.
a reference panel found on the Office Button
c.
a group on the Ribbon used to access Excel 2007’s Help system
d.
an Excel function category
 

 60. 
Another name for the middle value is the ____ value.
a.
center
c.
median
b.
relative
d.
mode
 

 61. 
The advantage of ____ references is that you can create a “general” formula that
you can use again and again in your worksheet.
a.
relative
c.
formula
b.
absolute
d.
cell
 

 62. 
With ____ interest, the borrower always pays more money to the lender the following year.
a.
simple
c.
compound
b.
maximum
d.
principal
 

 63. 
Using AutoFill, what would be the extended series of the initial entry Jan? ___
a.
Kan, Lan, Man, Nan
c.
uary
b.
Jan1, Jan2, Jan3,
d.
Feb, Mar, Apr
 

Essay
 

 64. 
What is the relationship between the Function Arguments dialog box and the Insert Function dialog box?
 

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

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



 
         Start Over