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
junctions
B
formulas
C
ctrl f
D
functions
2) this function counts the number of cells that contain numbers
A
count
B
countblank
C
countif
D
counta
3) this function counts the number of cells that are not blank
A
count
B
counta
C
countblank
D
countif
4) when using formula autocomplete, you need to double click the blue function name that appears
A
false
B
true
C
chicken habanero sandwich
D
brisket sandwich
5) which of the following is not listed under autosum?
A
if
B
min
C
max
D
average
6) which of the following is not a way to insert a function?
A
formula autocomplete
B
insert tab
C
fx button
D
formulas tab
7) the fx button does what?
A
inserts function
B
fixes your problem in Excel
C
zooms to selection
D
sends a fax
8) there is more than one way to insert a function
A
chicken shwarma
B
true
C
beef kabobs
D
false
9) which of the following will insert the date and time?
A
NOW
B
DATE AND TIME
C
TODAY
D
GRAPH
10) when you name a range of cells, you can just type in the __________
A
name box
B
autosum button
C
home tab
D
formula bar
11) when naming a group of cells, you cannot use spaces between words
A
false
B
texas potatoes
C
stuffed crust jalapeno and pepperoni pizza
D
true
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 false
B
logical test
C
value if true
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
keep it the same
B
multiply by 12
C
divide by 12
16) in the pmt function, should nper be in months or years?
A
bi annual
B
years
C
months
17) which function includes table array, column index number, lookup value, and range lookup
A
max
B
if
C
pmt
D
vlookup
18) which of the following arguments in vlookup tells you which value you are looking for
A
table array
B
range lookup
C
lookup value
D
column index number
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
lookup value
C
column index number
D
table array
*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?