Excel Ch 4 Review: Question Preview (ID: 29629)

Below is a preview of the questions contained within the game titled EXCEL CH 4 REVIEW: Final Excel Review .To play games using this data set, follow the directions below. Good luck and have fun. Enjoy! [print these questions]

Play games to reveal the correct answers. Click here to play a game and get the answers.

Which function allows you to search for a value, find it in a table array, then return information about that value
b) PMT
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

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
c) IF

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
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 the data set above, visit ReviewGameZone.com and enter game ID number: 29629 in the upper right hand corner at ReviewGameZone.com or simply click on the link above this text.

Log In
| Sign Up / Register