Question 1

In the PMT function,what is not true about the type argument?

Accepted Answer

A) It is often filled in with zero. 
B) It is often left blank. 
C) It is required. 
D) It is optional. 
A) It is often filled in with zero. 
B) It is often left blank. 
C) It is required. 
D) It is optional.

Question 2

In the PMT function,what is not true about the rate argument?

Accepted Answer

A) It assumes an annual interest rate. 
B) It can contain references to fields. 
C) It is optional. 
D) It reflects the interest charged on a loan. 
A) It assumes an annual interest rate. 
B) It can contain references to fields. 
C) It is optional. 
D) It reflects the interest charged on a loan.

Question 3

The rate argument in the Pmt function always uses the annual rate.

Accepted Answer

A) True 
 B)False

Question 4

The ________ sheet allows you to format a field.

Accepted Answer

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

Question 5

Which of the following is not a common aggregate function?

Accepted Answer

A) Count 
B) Sum 
C) Lowest 
D) Avg 
A) Count 
B) Sum 
C) Lowest 
D) Avg

Question 6

The Property Sheet in a query is very similar to the ________ properties in a table.

Accepted Answer

The answer of The Property Sheet in a query is...

Question 7

Access will calculate exactly what you tell it to calculate,even if you make logical errors in the calculation.

Accepted Answer

A) True 
 B)False

Question 8

What type of query will allow you to see statistics by category?

Accepted Answer

A) Update query 
B) Delete query 
C) Statistical query 
D) Totals query 
A) Update query 
B) Delete query 
C) Statistical query 
D) Totals query

Question 9

The ________ aggregate function totals the items in a column.

Accepted Answer

The answer of The ________ aggregate function totals the items...

Question 10

The Expression Builder tool helps you create complex expressions.

Accepted Answer

A) True 
 B)False

Question 11

Unless you add a minus sign,the Pmt function by default returns a(n)________ value.

Accepted Answer

The answer of Unless you add a minus sign,the Pmt...

Question 12

Two good ways to test the results of a calculated field is to use a calculator or Excel.

Accepted Answer

A) True 
 B)False

Question 13

Which of the following is not an arithmetic operator?

Accepted Answer

A) > 
B) - 
C) + 
D) * 
A) > 
B) - 
C) + 
D) *

Question 14

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 
A) 15 
B) 15*12 
C) 180 
D) 12*15

Question 15

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 
A) The various printing options available in Excel 
B) Naming convention for cell ranges 
C) How to do date calculations 
D) Order of operations

Question 16

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

Accepted Answer

A) True 
 B)False

Question 17

All aggregate functions can be used with any field type.

Accepted Answer

A) True 
 B)False

Question 18

Access will always give you step-by-step instructions to help you fix errors in formulas.

Accepted Answer

A) True 
 B)False

Question 19

If you want to see the results of several aggregate functions for one field,you would add the field in the Totals query several times.

Accepted Answer

A) True 
 B)False

Question 20

Where does the Total row of an aggregate function display its results?

Accepted Answer

A) Last row in Datasheet view 
B) First row in Datasheet view 
C) Only row in Datasheet view 
D) It does not display in Datasheet view. 
A) Last row in Datasheet view 
B) First row in Datasheet view 
C) Only row in Datasheet view 
D) It does not display in Datasheet view.

In the PMT function,what is not true about the type argument?

In the PMT function,what is not true about the rate argument?

The rate argument in the Pmt function always uses the annual rate.

The ________ sheet allows you to format a field.

Which of the following is not a common aggregate function?

The Property Sheet in a query is very similar to the ________ properties in a table.

Access will calculate exactly what you tell it to calculate,even if you make logical errors in the calculation.

What type of query will allow you to see statistics by category?

The ________ aggregate function totals the items in a column.

The Expression Builder tool helps you create complex expressions.

Unless you add a minus sign,the Pmt function by default returns a(n)________ value.

Two good ways to test the results of a calculated field is to use a calculator or Excel.

Which of the following is not an arithmetic operator?

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

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

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

All aggregate functions can be used with any field type.

Access will always give you step-by-step instructions to help you fix errors in formulas.

If you want to see the results of several aggregate functions for one field,you would add the field in the Totals query several times.

Where does the Total row of an aggregate function display its results?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters

Exam 4: Query Calculations and Expressions

In the PMT function,what is not true about the type argument?

In the PMT function,what is not true about the rate argument?

The rate argument in the Pmt function always uses the annual rate.

The ________ sheet allows you to format a field.

Which of the following is not a common aggregate function?

The Property Sheet in a query is very similar to the ________ properties in a table.

Access will calculate exactly what you tell it to calculate,even if you make logical errors in the calculation.

What type of query will allow you to see statistics by category?

The ________ aggregate function totals the items in a column.

The Expression Builder tool helps you create complex expressions.

Unless you add a minus sign,the Pmt function by default returns a(n)________ value.

Two good ways to test the results of a calculated field is to use a calculator or Excel.

Which of the following is not an arithmetic operator?

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

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

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

All aggregate functions can be used with any field type.

Access will always give you step-by-step instructions to help you fix errors in formulas.

If you want to see the results of several aggregate functions for one field,you would add the field in the Totals query several times.

Where does the Total row of an aggregate function display its results?

Office 365 Common Features

Introduction to Access

Tables and Queries in Relational Databases

Basic Forms and Reports

Data Validation and Data Analysis

Action and Specialized Queries

Advanced Forms and Reports

Get Connected

Fine-Tuning the Database

Enhanced Database Techniques

Filters