which of the following must you do before using the data table command? course hero

When a database includes many tables and queries it is automatically imported?

When a database includes many tables and queries, the Select Table box opens so that you can choose the table or query you want to import. If a database has a single table or query, it is automatically imported into Excel. Which of the following is a specific item name in a structured reference that Excel automatically places in a table?

Which row must use column names from the worksheet data?

The first row must use column names from the worksheet data but need not use all of them. Which of the following is not true of a criteria range? Criteria must be typed into the second row. The first row must use column names.

Which is an identifier for data that originated inside the workbook?

A connection is an identifier for data that originated inside the workbook. Which of the following statements is not true? A connection is an identifier for data that originated outside the workbook.

What is connection in Excel?

A connection (info) A connection is an identifier for data that originated outside the workbook. If you import data from a text file or a database, you can refresh the data by importing it again. If you import data as a web query, you can replace the data in your worksheet with current data on the web site.

Do you need to insert headings after importing?

Data that you import from the web usually needs to be formatted in Excel to match your other worksheet data. Depending on how data is formatted on the web page, you may not need to insert column headings after importing. Data that you import from a web page establishes a connection to the site that you can refresh whenever necessary.