Rachel Wants to Use Microsoft Query to Retrieve Data from Her

question 12

True/False

Rachel wants to use Microsoft Query to retrieve data from her corporate databases and files so that she doesn't have to retype the data that she wants to analyze in Excel.To do so,she can click and/or enter the following information in the following series of clicks: Data tab > Get External Data group > From Other Sources > From Microsoft Query > Databases tab (To specify a data source for a database,text file,or Excel workbook)> <New Data Source> OK > Create New Data Source dialog box > Type a name to identify the data source > Click a driver for the type of database for use as data source > Connect (Provide the information needed to connect to the data source)> OK.

---

Definitions:

Debt Ratio

A financial ratio that measures the extent of a company's leverage, calculated by dividing total liabilities by total assets.

Total Debt

The sum of all financial obligations a company or individual owes to outside parties, which can include loans, bonds, mortgages, and other forms of debt.

Total Assets

The sum of all resources owned by an individual, company, or institution, valued in monetary terms.

Total Asset Turnover

An activity ratio that measures how efficiently the firm uses all of its assets to generate sales; a high ratio generally reflects good overall management.