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
The point at which one column ends and another begins - Answers -column breaks
Specifies which data should be retrieved from different sections of a webpage -
Answers -web query
Provides the location of the webpage - Answers -URL
Shows the structure of an XML document in a schematic diagram - Answers -XML data
map
Structures data and text files that can be read by a wide variety of programs, including
EXCEL - Answers -extensible markup language
Marks the beginning of the data value - Answers -opening tag
the end of the data value - Answers -closing tag
A symbol - usually a space, A comma or a tab - that separates one column of data from
another - Answers -delimiter
Set of guidelines that specify values to retrieve from a database and in what order the
value should be retrieved - Answers -query
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
Text files can be stored as___in which a special character has a space, or tab marks
the beginning of each column - Answers -delimited text
Displays the high, low, and closing value of a stock - Answers -stock chart
Stores information about a specific characteristic of a person, place, or thing. This field
stores information about the ticker symbol - Answers -Field
A field that is present in both tables, different tables are combined using this - Answers -
comment field
, A collection of data values organized in a way so that they can be easily retrieved and
manipulated by the end-user - Answers -database
This is where databases are stored. It is a collection of data values arranged in rows or
records and columns or fields - Answers -tables
Retrieve data from multiple database tables and stores the data values in an Excel
workbook. Curated in the wizard by displaying for dialog boxes in sequence - Answers -
Microsoft query
Contains only text and numbers without any formulas, graphics, special fonts or
formatted text - Answers -text file
Depend on the value in the active cell for their results;identified by tracer arrows -
Answers -dependent cells
Supply data values to the Active cell - Answers -precedent cells
Error value; means that the cell contains an incorrect function name in the formula -
Answers -#NAME?
Calculates the internal rate of return for investment - Answers -IRR function
Calculates the PV of a series of future cash flows - Answers -NPV function
The return rate for a series of future cash flow - Answers -IRR
Calculates the payment. Required to pay off the loan or reach investment goal -
Answers -PMT Function
Function calculate the number of payments required to pay off a loan or reach an
investment goal - Answers -NPER
Calculates the per period. Interest rate required to pay off a loan investment goal -
Answers -RATE function
Provides the schedule of payments used to pay off a loan - Answers -amortization
schedule
Calculate the amount of the loan payment applied to the principal - Answers -PPMT
The length of time before an investment recovers its initial cost, which occurs when the
values change from negative to positive - Answers -payback period.
And interest rate that compares the value of current dollars to future dollars from a
series of cash flows - Answers -rate of return or discount rate
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