Web queries can be used to insert data from ________ into an Excel worksheet

A) XML files
B) other workbooks
C) web pages
D) Solver files

Answer: C

Computer Science & Information Technology

You might also like to view...

In a Microsoft Access database, something like the Gettysburg Address would be stored in a(n) ________ field

A) long text B) object C) short text D) text

Computer Science & Information Technology

Suppose that an application has four dimension tables, each of which contains 100 rows.

a. Determine the maximum number of rows in the fact table. b. Suppose that a one-dimension table has an attribute that can take on 10 values. Determine the size in bytes of a bit index on that attribute. c. Determine the maximum number of tuples in a join index for a join between one of the dimension tables and the fact table. d. Suppose that we use the CUBE operator on this fact table to perform aggregations on all four dimensions. Determine the number of rows in the resulting table. e. Suppose that we use the ROLLUP operator on this fact table. Determine the number of rows in the resulting table.

Computer Science & Information Technology