Excel Ch 4 Review Question Preview (ID: 29629)
Final Excel Review.
TEACHERS: click here for quick copy question ID numbers.
Which function allows you to search for a value, find it in a table array, then return information about that value
a) VLOOKUP
b) PMT
c) SUMIF
d) NOW
Which of the following can be found under the Data tab, what if button?
a) Goal Seek
b) advanced filter
c) IF function
d) SOLVER
to arrange items in a table (or spreadsheet) according to alphabet (a to z), number (highest to lowest), or by key (multiple levels)
a) sort
b) filter
c) advanced filter
d) greater/less than rules
a tiny chart that can be used to show trend patterns
a) sparklines
b) growth chart
c) column chart
d) pivot chart
which of the following functions would be used to calculate a monthly loan payment?
a) PMT
b) GROWTH
c) IF
d) VLOOKUP
to hide nonmatching rows in a table or list of data according to the criteria you specify
a) filter
b) sort
c) forecast
d) conditional formatting
which tab allows you to put a hyperlink in your excel spreadsheet?
a) insert
b) page layout
c) formulas
d) view
A hyperlink can link to several objects. which of the following is not one of those objects?
a) options button under the file tab
b) web page
c) different document
d) different place in the same document
text or graphic that, when clicked, displays related information elsewhere in the worksheet or in another file
a) hyperlink
b) screentip
c) chart
d) embedded chart
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) growth trend
b) linear trend
c) PMT function
d) TREND function
Which of the following arguments in a PMT function represents the annual rate of interest to be paid on the loan?
a) Rate
b) PV
c) FV
d) Nper
which of the following arguments in PMT represents the amount you are borrowing?
a) PV
b) Nper
c) RATE
d) FV
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) advanced filter
d) goal seek
Play Games with the Questions above at ReviewGameZone.com
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 29629 in the upper right hand corner or click here.
To play games using the questions from above, visit ReviewGameZone.com and enter game ID number: 29629 in the upper right hand corner or click here.
TEACHERS / EDUCATORS
Log In | Sign Up / Register
Log In | Sign Up / Register