Question 1

PEMDAS is a mnemonic device used to remember the ________.

Accepted Answer

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

Question 2

The future_value argument of the Pmt Function is the amount that is being borrowed.

Accepted Answer

The future_value argument of the Pmt function is not the amount being borrowed, it is the future value of the loan or investment at the end of the payment period. The present_value argument is the amount being borrowed.

Question 3

Match the following terms to their meanings:
I. Aggregate function
II. Expression Builder
III. Property sheet
IV. Totals Query
V. Syntax
A. Performs calculations on a column of data and returns a single value
B. Tool used to create complicated expressions
C. Contains an additional row that displays aggregate data
D. Specifies structure and components for a calculation
E. Contains formatting information

Accepted Answer

The answer of Match the following terms to their meanings:
I....

Question 4

Sum, Count, and Avg are all examples of aggregate functions.

Accepted Answer

Sum, Count, and Avg are common examples of aggregate functions used in SQL to perform calculations on groups of rows in a table.

Question 5

The MAXIMUM aggregate function can work with Short Text data.

Accepted Answer

The answer of The MAXIMUM aggregate function can work with...

Question 6

The present_value argument of the Pmt Function is the amount owed after the final payment has been made.

Accepted Answer

The present_value argument of the Pmt function is the current value of a loan or investment, not the amount owed after the final payment has been made.

Question 7

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

Accepted Answer

The answer of A query with a Total row is...

Question 8

Match each mathematical symbols to the operation that is performed:
I. +
II. *
III. /
IV. ^
V. -
A. Exponentiation
B. Multiplication
C. Subtraction
D. Addition
E. Division

Accepted Answer

The answer of Match each mathematical symbols to the operation...

Question 9

Match each element of an expression with is definition:
I. Identifiers
II. Operators
III. Functions
IV. Constants
V. Variables
A. Produce results based on inputs
B. Values that do not change
C. Arithmetic instructions such as * , / , + , or -
D. Elements with a changing value
E. The names of fields, controls, or properties

Accepted Answer

The answer of Match each element of an expression with...

Question 10

Match each aggregate function with the value it returns:
I. Avg
II. Count
III. Maximum
IV. Minimum
V. Sum
A. Returns the data item with the highest value
B. Returns the data item with the lowest value
C. Returns the mean value of a group of numbers
D. Returns the total value of a column of numbers
E. Returns the number of fields containing data

Accepted Answer

The answer of Match each aggregate function with the value...

Question 11

Match the following terms to their meanings:
I. Grouping
II. Order of operations
III. Argument
IV. Total Row
V. Expression
A. Data needed to produce the output for a function
B. Consist of different elements to produce the desired output
C. Summarizes data by the values of a field
D. Determines the sequence in which calculations are performed
E. Displays results of aggregate functions in last row in a Datasheet

Accepted Answer

The answer of Match the following terms to their meanings:
I....

Question 12

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

Accepted Answer

This statement is true. A Total row can be added in Datasheet view to display the results of aggregate functions such as SUM or COUNT as the last row.

Question 13

Aggregate functions perform calculations on an entire row of data and return a single value.

Accepted Answer

Aggregate functions perform calculations on a set or group of values and return a single value. They do not operate on an entire row of data but rather on specific columns or expressions that involve multiple rows.

Question 14

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

Accepted Answer

The answer of It is NOT possible to add a...

Question 15

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

Accepted Answer

The answer of The SUM aggregate function can work with...

Question 16

A summary query is used to display only aggregate data when the query is run.

Accepted Answer

The answer of A summary query is used to display...

Question 17

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

Accepted Answer

This statement is true. The Total row in a table can include functions such as Sum, Avg, and Count, among others, to provide calculations of summary information for a particular column or set of columns.

Question 18

^ is the symbol for ________.

Accepted Answer

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

Question 19

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

Accepted Answer

The answer of The AVG function can only be used...

Question 20

* is the symbol for ________.

Accepted Answer

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

Quiz 3: Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions