Question 1

Exponents are evaluated first according to the order of operations.

Accepted Answer

A) True 
 B)False

Question 2

It is NOT possible to add a condition to a Totals query.

Accepted Answer

A) True 
 B)False

Question 3

Which of the following is the correct mathematical sequence for the order of operations?

Accepted Answer

A)  Multiplication, Division, Exponentiation, Addition, Subtraction 
B)  Exponentiation, Multiplication, Division, Addition, Subtraction 
C)  Multiplication, Exponentiation, Division, Addition, Subtraction 
D)  Addition, Subtraction, Multiplication, Exponentiation, Division

Question 4

A ________ query has an additional row displaying aggregate data.

Accepted Answer

A)  digest 
B)  totals 
C)  summary 
D)  synopsis

Question 5

Match between columns
                        Premises: Operators
Identifiers
Functions
Variables
Constants

Accepted Answer

The Answer of Produce results based on inputs and Values is...

Question 6

* is the symbol for ________.

Accepted Answer

The answer of * is the symbol for ________....

Question 7

You must have a query open in Design view to launch the Expression Builder.

Accepted Answer

A) True 
 B)False

Question 8

The SUM aggregate function can work with Date/Time data.

Accepted Answer

A) True 
 B)False

Question 9

A Total row displays the results of aggregate functions as the last row in the Datasheet view.

Accepted Answer

A) True 
 B)False

Question 10

According to the order of operations,multiplication and addition are evaluated before Division and subtraction.

Accepted Answer

A) True 
 B)False

Question 11

An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.

Accepted Answer

A)  rate 
B)  num_periods 
C)  present_value 
D)  future_value

Question 12

A query with a Total row is the same as a totals query.

Accepted Answer

A) True 
 B)False

Question 13

Calculated fields can only be displayed on a form.

Accepted Answer

A) True 
 B)False

Question 14

To change a field's caption or the number of decimal places,you would use its ________.

Accepted Answer

The answer of To change a field's caption or the...

Question 15

A(n)________ is the data used by a function to produce a result.

Accepted Answer

A)  control 
B)  parameter 
C)  constraint 
D)  argument

Question 16

The order of operations determines the sequence by which operations are calculated.

Accepted Answer

A) True 
 B)False

Question 17

When using the Pmt function,principal is another term for the ________ of a loan.

Accepted Answer

A)  rate 
B)  duration 
C)  future value 
D)  present value

Question 18

Function arguments are separated by ________.

Accepted Answer

The answer of Function arguments are separated by ________....

Question 19

A(n)________ is used to change settings such as formatting and captions.

Accepted Answer

A)  dialog box 
B)  parameter list 
C)  property sheet 
D)  argument menu

Question 20

The AVG function can only be used with the Number data type.

Accepted Answer

A) True 
 B)False

Exam 15: Customize, analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions

Exponents are evaluated first according to the order of operations.

It is NOT possible to add a condition to a Totals query.

Which of the following is the correct mathematical sequence for the order of operations?

A ________ query has an additional row displaying aggregate data.

Match each element of an expression with is definition:

* is the symbol for ________.

You must have a query open in Design view to launch the Expression Builder.

The SUM aggregate function can work with Date/Time data.

A Total row displays the results of aggregate functions as the last row in the Datasheet view.

According to the order of operations,multiplication and addition are evaluated before Division and subtraction.

An expression or integer value specifying total number of payments in a loan is the ________ argument in the PMT function.

A query with a Total row is the same as a totals query.

Calculated fields can only be displayed on a form.

To change a field's caption or the number of decimal places,you would use its ________.

A(n) ________ is the data used by a function to produce a result.

The order of operations determines the sequence by which operations are calculated.

When using the Pmt function,principal is another term for the ________ of a loan.

Function arguments are separated by ________.

A(n) ________ is used to change settings such as formatting and captions.

The AVG function can only be used with the Number data type.