MID TERM

Question 1

Query Wizard

Answer 1

we can only do simple data retrieval, filtering and sorting

Question 2

MS Query

Answer 2

Pulling data from multiple tables,
Calculating a field on-the-fly,
Complex data filtering,
Grouping data records,
Renaming column names

Question 3

DSN

Answer 3

Data Source Names- connect to external data sources *A text file that defines how to connect to an external data source. *It is listed in the Choose Data Source dialog box.

Question 4

Adding fields

Answer 4

MS Query - *

Query Wizard- +

Question 5

SQL

Answer 5

Structured Query Language

Question 6

Logical operators

Answer 6

• Not
• And (>= 90 and <=100)
• Or

Question 7

Going back to MS Query from PivotTable

Answer 7

Data> Properties> Edit Query

Question 8

+

Answer 8

1) Plus sign as numeric addition when both sides of the plus sign are numeric fields
(UnitsOnOrder+UnitsInStock)
2) Plus sign as concatenation when both sides of it are strings
(Customers.ContactName + ‘, ‘ + Customers.ContactTitle)

Question 9

Filters can be applied before or after the data is loaded into Excel.

Answer 9

Before- DSN, Query Wizard, MS Query

After- Manual filters, Label filters, Value filters

Question 10

Manual filters

Answer 10

applied by manually checking or unchecking items in the selected field’s drop-down list

Question 11

Label filters

Answer 11

applied by selecting an operator and criteria for items in Row Labels or Column Labels area.

Question 12

Value filters

Answer 12

applied by selecting an operator and criteria for Row Labels or Column Labels grant totals

Question 13

calculated field

Answer 13

a new field (not an item) created for the field selection window.
-Choose PivotTable Tools > Formulas > Calculated Field> ever formula> Add> ok>