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