Exam (elaborations)
CGS 2518 FINAL Exam Questions and Answers
- Course
- Institution
CGS 2518 FINAL Exam Questions and Answers
[Show more]
Content preview
CGS 2518 FINAL Exam Questions andAnswers
To map an XML document directly into an Excel table, click the _____ ____ _____
button in the Get External Data group on the Data tab, and then click from XML Data
Import - Answers -From Other Sources
The _____ function calculates the payment in each period required to pay off a loan or
reach an investment goal. - Answers -PMT
In delimited text, a _____ or ____ separates columns - Answers -comma, tab
Excel can Import data from: - Answers -a. databases and files b. data with Microsoft
query c. data from the World Wide Web
To map an XML document directly into an Excel table, click in the _____ _____ _____
group on the Data tab, and then click from XML Data Import - Answers -Get External
Data
To manually refresh a data range: In the ____ group on the ____ tab, click the Refresh
All button - Answers -Connections, data
An ________ _________ provides the schedule of payments used to pay off a loan -
Answers -amortization schedule
A ____ ____ is a data source where Excel will NOT prompt you to confirm that the
connection is secure - Answers -trusted source
Cell Style is located in the _____ group of the _____ tab - Answers -styles, home
The _____ functions calculates the amount of a loan payment used to pay off the
interest - Answers -IPMT
The _____ _____ marks the end of the data value - Answers -closing tag
A ______ ______ ____ is a positive value that represents money coming to the investor
- Answers -positive cash flow
Negative cash flows appear in a _____ font within parentheses - Answers -red
, A _____ stores information about a specific characteristic of a person,place or thing. -
Answers -Field
In an ______ schedule, use absolute reference to refer to the original loan conditions
and use relative references to refer to information about specific payment periods. -
Answers -Amortization
_____ _____ retrieves data from multiple database tables and stores the data values in
an Excel workbook. The query is created in the wizard by displaying four dialog boxes in
sequence - Answers -Microsoft Query
A table of red values enclosed in parentheses can be difficult to read. ______ schedules
often format all entries as positive values, and then label the columns to indicate the
values represent negative cash flows - Answers -Amortization
A ______ is usually a space, comma, or tab that separates one column of data from
another - Answers -delimiter
A _____ is a set of guidelines that specify what values to retrieve from a database and
in what order the values should be retrieved. - Answers -Query
The From Text button is located in the ____ tab in the Get External _____ group -
Answers -Data
you can insert the PMT function and view its arguments and meanings with the
_______ _______ and Function Arguments dialog boxes by clicking the ________
_________ button on the formula bar - Answers -Insert Function
The _____ tab contains commands for retrieving and refreshing data from external
sources. - Answers -Data
A _______ displays a collection of characteristics of a particular person, place, or thing -
Answers -Record
A text file can also be stored in a ____-____ ______ where each column starts at the
same location in the text file - Answers -fixed-width format
A ______ _____ ____ is a negative value that represents cash going away from the
investor - Answers -negative cash flow
The _____ function calculates the payment in each period required to pay off a loan or
reach an investment goal. - Answers -PMT
The _____ _____ dialog box lists all of the connections in the workbook. - Answers -
Workbook Connections
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller millyphilip. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $10.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
62890 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now