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
ctrl f
B
formulas
C
functions
D
junctions
2) this function counts the number of cells that contain numbers
A
countblank
B
countif
C
counta
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
brisket sandwich
B
false
C
true
D
chicken habanero sandwich
5) which of the following is not listed under autosum?
A
average
B
min
C
max
D
if
6) which of the following is not a way to insert a function?
A
insert tab
B
formulas tab
C
fx button
D
formula autocomplete
7) the fx button does what?
A
zooms to selection
B
fixes your problem in Excel
C
sends a fax
D
inserts function
8) there is more than one way to insert a function
A
beef kabobs
B
chicken shwarma
C
false
D
true
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
autosum button
B
home tab
C
formula bar
D
name box
11) when naming a group of cells, you cannot use spaces between words
A
texas potatoes
B
stuffed crust jalapeno and pepperoni pizza
C
true
D
false
12) you can access information from sheet 1 and put it on sheet 2.
A
true
B
false
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
pv
B
pmt
C
fv
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
years
B
months
C
bi annual
17) which function includes table array, column index number, lookup value, and range lookup
A
max
B
pmt
C
vlookup
D
if
18) which of the following arguments in vlookup tells you which value you are looking for
A
range lookup
B
column index number
C
table array
D
lookup value
19) which of the following arguments in vlookup represents the group of cells that contain the info you are looking for?
A
lookup value
B
table array
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?