Question 1

In the formula, =1+(2-3)+5/6-6^2, what will Access evaluate first?

Accepted Answer

A)  5/6 
B)  1+ 
C)  6^2 
D)  (2-3)

Question 2

What is a type of field that displays the result of an expression rather than the data stored in a field?

Accepted Answer

A)  Calculated 
B)  Lookup 
C)  AutoNumber 
D)  Hyperlink

Question 3

When you want to add a condition to a Totals query, which option do you select from the Totals row list?

Accepted Answer

A)  When 
B)  Group 
C)  Where 
D)  Condition

Question 4

For a 15-year loan paid monthly, which of the following would not be correct for the num_periods argument in the Pmt function?

Accepted Answer

A)  15 
B)  15*12 
C)  180 
D)  12*15

Question 5

A(n) ________ function performs a calculation on an entire column of data and returns a single value.

Accepted Answer

The answer of A(n) ________ function performs a calculation on...

Question 6

The Total row, when using aggregate functions, displays both the total and the individual records.

Accepted Answer

A) True 
 B)False

Question 7

It is permissible to use the percent (%) sign when entering the interest rate in the Pmt function.

Accepted Answer

A) True 
 B)False

Question 8

The ________ sheet allows you to format a field.

Accepted Answer

The answer of The ________ sheet allows you to format...

Question 9

What can the phrase "Please Excuse My Dear Aunt Sally" help you remember?

Accepted Answer

A)  The various printing options available in Excel 
B)  Naming convention for cell ranges 
C)  How to do date calculations 
D)  Order of operations

Exam 3: Using Queries to Make Decisions

In the formula, =1+(2-3) +5/6-6^2, what will Access evaluate first?