Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Ch 2
Test Description: Review
Instructions: Answer all questions to get your test result.
1) pre-programmed shortcuts for calculating complex equations
A
functions
B
formulas
C
ctrl f
D
junctions
2) this function counts the number of cells that contain numbers
A
countif
B
counta
C
countblank
D
count
3) this function counts the number of cells that are not blank
A
counta
B
countif
C
count
D
countblank
4) when using formula autocomplete, you need to double click the blue function name that appears
A
true
B
chicken habanero sandwich
C
false
D
brisket sandwich
5) which of the following is not listed under autosum?
A
max
B
average
C
min
D
if
6) which of the following is not a way to insert a function?
A
fx button
B
formula autocomplete
C
insert tab
D
formulas tab
7) the fx button does what?
A
zooms to selection
B
inserts function
C
fixes your problem in Excel
D
sends a fax
8) there is more than one way to insert a function
A
false
B
chicken shwarma
C
true
D
beef kabobs
9) which of the following will insert the date and time?
A
GRAPH
B
NOW
C
DATE AND TIME
D
TODAY
10) when you name a range of cells, you can just type in the __________
A
home tab
B
formula bar
C
autosum button
D
name box
11) when naming a group of cells, you cannot use spaces between words
A
stuffed crust jalapeno and pepperoni pizza
B
texas potatoes
C
true
D
false
12) you can access information from sheet 1 and put it on sheet 2.
A
false
B
true
13) in the if function, what is the argument listed at the top?
A
value if true
B
logical test
C
value if false
14) when calculating loan payments, which argument represents the amount you are borrowing?
A
fv
B
rate
C
pmt
D
pv
15) in the pmt function, what do you need to do the rate to get it to be a monthly rate?
A
multiply by 12
B
divide by 12
C
keep it the same
16) in the pmt function, should nper be in months or years?
A
years
B
months
C
bi annual
17) which function includes table array, column index number, lookup value, and range lookup
A
vlookup
B
max
C
if
D
pmt
18) which of the following arguments in vlookup tells you which value you are looking for
A
column index number
B
lookup value
C
table array
D
range lookup
19) which of the following arguments in vlookup represents the group of cells that contain the info you are looking for?
A
table array
B
table array
C
lookup value
D
column index number
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?