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
linear trend
B
TREND function
C
growth trend
D
PMT function
2) text or graphic that, when clicked, displays related information elsewhere in the worksheet or in another file
A
chart
B
screentip
C
embedded chart
D
hyperlink
3) A hyperlink can link to several objects. which of the following is not one of those objects?
A
different document
B
different place in the same document
C
web page
D
options button under the file tab
4) which tab allows you to put a hyperlink in your excel spreadsheet?
A
insert
B
page layout
C
view
D
formulas
5) to hide nonmatching rows in a table or list of data according to the criteria you specify
A
forecast
B
conditional formatting
C
sort
D
filter
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
sort
D
filter
7) a tiny chart that can be used to show trend patterns
A
growth chart
B
pivot chart
C
sparklines
D
column chart
8) which of the following functions would be used to calculate a monthly loan payment?
A
PMT
B
IF
C
VLOOKUP
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
NOW
B
PMT
C
SUMIF
D
VLOOKUP
10) Which of the following can be found under the Data tab, what if button?
A
IF function
B
advanced filter
C
Goal Seek
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
Rate
B
FV
C
PV
D
Nper
12) which of the following arguments in PMT represents the amount you are borrowing?
A
FV
B
RATE
C
PV
D
Nper
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
data table
B
solver
C
goal seek
D
advanced filter
*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?