Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Excel Ch 4 Review
Test Description: Final excel review
Instructions: Answer all questions to get your test result.
1) when your grades have been way up and way down, which of the following would you use to forecast what they will be in the future?
A
PMT function
B
TREND function
C
growth trend
D
linear trend
2) text or graphic that, when clicked, displays related information elsewhere in the worksheet or in another file
A
chart
B
screentip
C
hyperlink
D
embedded chart
3) A hyperlink can link to several objects. which of the following is not one of those objects?
A
web page
B
different document
C
different place in the same document
D
options button under the file tab
4) which tab allows you to put a hyperlink in your excel spreadsheet?
A
insert
B
view
C
page layout
D
formulas
5) to hide nonmatching rows in a table or list of data according to the criteria you specify
A
filter
B
forecast
C
conditional formatting
D
sort
6) to arrange items in a table (or spreadsheet) according to alphabet (a to z), number (highest to lowest), or by key (multiple levels)
A
greater/less than rules
B
advanced filter
C
filter
D
sort
7) a tiny chart that can be used to show trend patterns
A
column chart
B
sparklines
C
growth chart
D
pivot chart
8) which of the following functions would be used to calculate a monthly loan payment?
A
PMT
B
VLOOKUP
C
IF
D
GROWTH
9) Which function allows you to search for a value, find it in a table array, then return information about that value
A
PMT
B
SUMIF
C
VLOOKUP
D
NOW
10) Which of the following can be found under the Data tab, what if button?
A
Goal Seek
B
IF function
C
advanced filter
D
SOLVER
11) Which of the following arguments in a PMT function represents the annual rate of interest to be paid on the loan?
A
Nper
B
PV
C
FV
D
Rate
12) which of the following arguments in PMT represents the amount you are borrowing?
A
RATE
B
PV
C
Nper
D
FV
13) if you wanted to find out how additional years of schooling can affect your income, you might want to make a _____________ that lists several years that will replace the column/row input value
A
advanced filter
B
solver
C
data table
D
goal seek
*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?