Question 1

When designing an expression for a calculated field,the name of the calculated field is followed by a(n):

Accepted Answer

A)  colon. 
B)  exclamation point. 
C)  semicolon. 
D)  period.

Question 2

A constant is a value that remains the same in an expression.

Accepted Answer

A) True 
 B)False

Question 3

A(n)________ is a variable or constant that is needed to produce output for a function in a calculated field.

Accepted Answer

A)  formula 
B)  argument 
C)  expression 
D)  function

Question 4

The ________ aggregate functions return the item with the lowest value.

Accepted Answer

The answer of The ________ aggregate functions return the item...

Question 5

The Property Sheet enables you to change settings such as number format,number of decimal places,and other settings.

Accepted Answer

A) True 
 B)False

Question 6

According to the order of operations,addition and subtraction are evaluated before multiplication and division if the addition and subtraction equations are contained within parentheses

Accepted Answer

A) True 
 B)False

Question 7

A Total row in a table can include functions such as Sum,Avg,and Count.

Accepted Answer

A) True 
 B)False

Question 8

^ is the symbol for ________.

Accepted Answer

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

Question 9

When viewing the results of a query,a series of ________ symbols indicates that a column is too narrow to display the complete results.

Accepted Answer

A)  & 
B)  # 
C)  ! 
D)  @

Question 10

Match between columns
                        Premises: *
/
+
-
^

Accepted Answer

The Answer of Division and Exponentiation and Addition and Multiplication is...

Question 11

When designing a calculated field,complex formulas can be created with the:

Accepted Answer

A)  Table Wizard. 
B)  Form Wizard. 
C)  Expression Builder. 
D)  Report Builder.

Question 12

PEMDAS is a mnemonic device used to remember the ________.

Accepted Answer

The answer of PEMDAS is a mnemonic device used to...

Question 13

In terms of creating a calculated field in a query,define the term expression and give two examples of expression elements.

Accepted Answer

The answer of In terms of creating a calculated field...

Question 14

Match between columns
                        Premises: Syntax
Property sheet
Aggregate function
Totals Query
Expression Builder

Accepted Answer

The Answer of Contains an additional row that displays aggregate is...

Question 15

When designing an expression for a calculated field,field names are surrounded by:

Accepted Answer

A)  parentheses. 
B)  brackets. 
C)  braces. 
D)  double-quotation marks.

Question 16

Which aggregate function would be used to find the highest value in a column?

Accepted Answer

A)  MAXIMUM 
B)  MOST 
C)  HIGHEST 
D)  COUNT

Question 17

A(n)________ is a formula used to calculate new fields from the values in existing fields.

Accepted Answer

A)  argument 
B)  expression 
C)  parameter 
D)  macro

Question 18

Explain what the order of operations is and why parentheses might be needed when evaluating an expression.Give a specific example of where parentheses would be need.

Accepted Answer

The answer of Explain what the order of operations is...

Question 19

Formats available on the Property Sheet vary based on the data type.

Accepted Answer

A) True 
 B)False

Question 20

The Calculated fields in Datasheet view can be edited in the same way other fields from a table are edited.

Accepted Answer

A) True 
 B)False

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

When designing an expression for a calculated field,the name of the calculated field is followed by a(n) :

A constant is a value that remains the same in an expression.

A(n) ________ is a variable or constant that is needed to produce output for a function in a calculated field.

The ________ aggregate functions return the item with the lowest value.

The Property Sheet enables you to change settings such as number format,number of decimal places,and other settings.

According to the order of operations,addition and subtraction are evaluated before multiplication and division if the addition and subtraction equations are contained within parentheses

A Total row in a table can include functions such as Sum,Avg,and Count.

^ is the symbol for ________.

When viewing the results of a query,a series of ________ symbols indicates that a column is too narrow to display the complete results.

Match each mathematical symbols to the operation that is performed:

When designing a calculated field,complex formulas can be created with the:

PEMDAS is a mnemonic device used to remember the ________.

In terms of creating a calculated field in a query,define the term expression and give two examples of expression elements.

Match the following terms to their meanings:

When designing an expression for a calculated field,field names are surrounded by:

Which aggregate function would be used to find the highest value in a column?

A(n) ________ is a formula used to calculate new fields from the values in existing fields.

Explain what the order of operations is and why parentheses might be needed when evaluating an expression.Give a specific example of where parentheses would be need.

Formats available on the Property Sheet vary based on the data type.

The Calculated fields in Datasheet view can be edited in the same way other fields from a table are edited.