Test Bank Chapter 4 Query Calculations And Expressions

Exploring Microsoft Office 365, Access 2019 Comprehensive (Poatsy)

Chapter 4 Query Calculations and Expressions

1) In the formula, 3*[BaseSalary], the 3 is considered a(n) ________.

A) variable

B) field

C) argument

D) constant

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

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

A) 5/6

B) 1+

C) 6^2

D) (2-3)

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

3) In the PMT function, what is not true about the Num_periods argument?

A) It reflects a count of how many times payments will be made.

B) It can contain references to fields.

C) You must use constants for this argument.

D) It is required.

Diff: 2

Objective: A3.06 Use Built-In Functions

4) What symbols does Access use to indicate a field name?

A) []

B) ()

C) {}

D) ""

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

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

A) Calculated

B) Lookup

C) AutoNumber

D) Hyperlink

Diff: 1

Objective: A3.01 Create a Query with a Calculated Field

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

A) The various printing options available in Excel

B) Naming convention for cell ranges

C) How to do date calculations

D) Order of operations

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

7) Which of the following is not an arithmetic operator?

A) >

B) -

C) +

D) *

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

8) In the PMT function, what is not true about the Present_value argument?

A) It can contain references to fields.

B) It is optional.

C) It reflects the total amount of a loan.

D) It returns a negative value by default.

Diff: 2

Objective: A3.06 Use Built-In Functions

9) According to the order of operations, what is not calculated after exponentiation?

A) Parenthesis

B) Multiplication

C) Division

D) Addition

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

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

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.

Diff: 2

Objective: A3.06 Use Built-In Functions

11) What best describes the concept of syntax?

A) Predefined computation that performs a complex calculation

B) Specific inputs used to complete the calculation

C) Options that can be included in a function

D) Determines the layout and order of the function and its arguments

Diff: 2

Objective: A3.06 Use Built-In Functions

12) What symbol does Access use to express exponentiation?

A) ^

B) *

C) <>

D) ()

Diff: 1

Objective: A3.01 Create a Query with a Calculated Field

13) What sheet will allow you to change the formatting of a field in a query?

A) Formatting

B) Modify

C) Build

D) Property

Diff: 1

Objective: A3.02 Format Calculated Results

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

A) It is often filled in with zero.

B) It is often left blank.

C) It is required.

D) It is optional.

Diff: 1

Objective: A3.06 Use Built-In Functions

15) Which of the following is not a common mistake when creating calculated fields?

A) Forgetting the colon

B) Putting the same field in more than once

C) Incorrectly spelling the field names

D) Forgetting PEMDAS

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

16) When you are prompted to enter a value when you run a query which includes a calculated field, you probably ________.

A) entered too many arguments in the formula

B) used the wrong arithmetic operator in your formula

C) forgot to name the new, calculated field

D) typed a field name incorrectly

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

17) What error will you get if there is something wrong with the formula in a calculated field?

A) #NAME!

B) #FORMULA!

C) Invalid syntax

D) Invalid expression

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

18) Which of the following is not an advantage of using the Expression Builder?

A) It will guarantee that you do not type field names incorrectly.

B) Its size

C) Easy access to various objects

D) Placeholders

Diff: 2

Objective: A3.05 Create Expressions Using the Expression Builder

19) Which of the following can help you build more complex expressions in calculated fields?

A) Property sheet

B) Design view

C) Expression Builder

D) Expression Creator

Diff: 1

Objective: A3.05 Create Expressions Using the Expression Builder

20) What are predefined computations that perform complex calculations?

A) Formulas

B) Functions

C) Arguments

D) Expressions

Diff: 2

Objective: A3.06 Use Built-In Functions

21) Another name for an input in a function is a(n) ________.

A) Argument

B) Property

C) Value

D) Expression

Diff: 1

Objective: A3.06 Use Built-In Functions

22) What is not a necessary piece of data needed for the Pmt function?

A) Interest rate

B) Amount already paid on the loan

C) Amount of the loan

D) Number of periods required to pay off the loan

Diff: 2

Objective: A3.06 Use Built-In Functions

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

A) 15

B) 15*12

C) 180

D) 12*15

Diff: 1

Objective: A3.06 Use Built-In Functions

24) Which of the following is not an argument used in the Pmt function?

A) Total_due

B) Rate

C) Future_value

D) Type

Diff: 2

Objective: A3.06 Use Built-In Functions

25) What is not an example of a function?

A) =RATE

B) =PV

C) =PMT

D) =15*21

Diff: 1

Objective: A3.06 Use Built-In Functions

26) What punctuation do you use to separate the arguments in a function?

A) ;

B) ,

C) :

D) .

Diff: 2

Objective: A3.06 Use Built-In Functions

27) Access refers to ________ as aggregate functions.

A) Sums

B) Complex functions

C) Whole Column functions

D) Totals

Diff: 3

Objective: A3.07 Add Aggregate Functions to Datasheets

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

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.

Diff: 2

Objective: A3.07 Add Aggregate Functions to Datasheets

29) Which of the following is not a common aggregate function?

A) Count

B) Sum

C) Lowest

D) Avg

Diff: 2

Objective: A3.07 Add Aggregate Functions to Datasheets

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

A) Update query

B) Delete query

C) Statistical query

D) Totals query

Diff: 2

Objective: A3.08 Create Queries with Aggregate Functions

31) What allows you to summarize data by the values of a field?

A) Adding a summarizing field

B) Adding the proper calculated field

C) Adding grouping to a query

D) Adding an update field

Diff: 2

Objective: A3.08 Create Queries with Aggregate Functions

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

A) When

B) Group

C) Where

D) Condition

Diff: 3

Objective: A3.08 Create Queries with Aggregate Functions

33) Calculated fields must always contain at least one constant.

Diff: 3

Objective: A3.01 Create a Query with a Calculated Field

34) Calculating values will help to avoid inconsistencies.

Diff: 1

Objective: A3.01 Create a Query with a Calculated Field

35) In the PMT function, Future_value is considered an optional argument.

Diff: 2

Objective: A3.06 Use Built-In Functions

36) Access uses parenthesis () to identify a field name.

Diff: 1

Objective: A3.01 Create a Query with a Calculated Field

37) If the arguments in a formula are in the wrong order, you will get a syntax error.

Diff: 1

Objective: A3.06 Use Built-In Functions

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

Diff: 2

Objective: A3.04 Verify Calculated Results

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

Diff: 1

Objective: A3.04 Verify Calculated Results

40) Access will identify logical errors in calculated fields.

Diff: 3

Objective: A3.04 Verify Calculated Results

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

Diff: 2

Objective: A3.04 Verify Calculated Results

42) The Expression Builder tool helps you create complex expressions.

Diff: 3

Objective: A3.05 Create Expressions Using the Expression Builder

43) <<Rate>> is an example of an argument.

Diff: 3

Objective: A3.05 Create Expressions Using the Expression Builder

44) You can enter an expression in the Expression Builder by either typing the expression manually or by right-clicking the expression.

Diff: 2

Objective: A3.05 Create Expressions Using the Expression Builder

45) Some functions have optional arguments.

Diff: 2

Objective: A3.06 Use Built-In Functions

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

Diff: 2

Objective: A3.06 Use Built-In Functions

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

Diff: 2

Objective: A3.06 Use Built-In Functions

48) A function is a predefined computation that is used for simple calculations.

Diff: 2

Objective: A3.06 Use Built-In Functions

49) All aggregate functions can be used with any field type.

Diff: 3

Objective: A3.07 Add Aggregate Functions to Datasheets

50) 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.

Diff: 2

Objective: A3.07 Add Aggregate Functions to Datasheets

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

Diff: 2

Objective: A3.07 Add Aggregate Functions to Datasheets

52) A totals query allows you to see only the results of aggregate functions, not the detail.

Diff: 2

Objective: A3.08 Create Queries with Aggregate Functions

53) You can add aggregate functions to calculated fields.

Diff: 2

Objective: A3.08 Create Queries with Aggregate Functions

54) You can add multiple levels of grouping to a Totals query.

Diff: 2

Objective: A3.08 Create Queries with Aggregate Functions

55) If you are not using a totals query, then you must display the Totals row in a query if you want to use aggregate functions.

Diff: 1

Objective: A3.08 Create Queries with Aggregate Functions

56) You can add conditions to a Totals query.

Diff: 1

Objective: A3.08 Create Queries with Aggregate Functions

57) An expression is a formula used in a calculated field that contains only one element.

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

58) A calculated field displays the results of an expression in contrast to other data which is stored directly in a(n) ________.

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

59) A combination of elements that produce a value is known as a(n) ________.

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

60) A(n) ________ is a part of a formula that never changes its value.

Diff: 1

Objective: A3.01 Create a Query with a Calculated Field

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

Diff: 2

Objective: A3.02 Format Calculated Results

62) The ________ sheet allows you to format a field.

Diff: 2

Objective: A3.02 Format Calculated Results

63) If the formula, 3*[Bonus], the 3 is considered a(n) ________.

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

64) When creating a calculated field a(n) ________ is entered after the field name.

Diff: 1

Objective: A3.01 Create a Query with a Calculated Field

65) If you type the name of a calculated field incorrectly you will get an invalid ________ error.

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

66) Sometimes it is best to verify calculations by using a(n) ________ on a few records.

Diff: 3

Objective: A3.04 Verify Calculated Results

67) When creating expressions, the ________ is useful to beginning users.

Diff: 2

Objective: A3.05 Create Expressions Using the Expression Builder

68) Using the Expression Builder can help you avoid ________ errors in field names.

Diff: 2

Objective: A3.05 Create Expressions Using the Expression Builder

69) Functions generate results based on ________.

Diff: 3

Objective: A3.06 Use Built-In Functions

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

Diff: 2

Objective: A3.06 Use Built-In Functions

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

Diff: 3

Objective: A3.07 Add Aggregate Functions to Datasheets

72) Fields with a ________ data type can use any aggregate function.

Diff: 3

Objective: A3.07 Add Aggregate Functions to Datasheets

73) The ________ aggregate function returns the value with the highest value.

Diff: 1

Objective: A3.07 Add Aggregate Functions to Datasheets

74) If you wanted to find the youngest person in your table, you would use the ________ function in a calculated field.

Diff: 3

Objective: A3.07 Add Aggregate Functions to Datasheets

75) The ________ aggregate function totals the items in a column.

Diff: 1

Objective: A3.07 Add Aggregate Functions to Datasheets

76) If you wanted to find out how many people are going on a trip you would use the ________ function in a calculated field.

Diff: 1

Objective: A3.07 Add Aggregate Functions to Datasheets

77) The ________ aggregate function returns the value with the lowest value.

Diff: 1

Objective: A3.07 Add Aggregate Functions to Datasheets

78) A(n) ________ query has an additional row which is used to display aggregate data.

Diff: 2

Objective: A3.08 Create Queries with Aggregate Functions

79) When you add ________ to a query you can summarize data by fields.

Diff: 3

Objective: A3.08 Create Queries with Aggregate Functions

80) Match the following terms with their description:

I. Argument

II. Expression

III. Grouping

IV. Function

V. Constant

A. Combination of elements that produce a value

B. Value that does not change

C. Input used in a function

D. Predefined computation

E. Method of summarizing data

Diff: 2

Objective: Multiple Objectives

81) Match the following terms with their examples:

I. Formula

II. Function

III. Argument

IV. Expression

V. Constant

A. 58

B. =9*2

C. (rate, num_periods, present_value, future_value, type)

D. <<Rate>>

E. =Sum

Diff: 2

Objective: Multiple Objectives

82) Match the following terms with their description:

I. Total row

II. Totals query

III. Property Sheet

IV. Expression Builder

V. Aggregate function

A. Calculation performed on a column and returns one value

B. Way to display aggregate function results when a query is run

C. Tool to create complicated expressions

D. Where you can change the number of decimals

E. Displays aggregate function results as the last row in a table or query

Diff: 1

Objective: Multiple Objectives

83) Match the order of operation with its priority:

I. Multiplication

II. Parenthesis

III. Exponentiation

IV. Addition

V. Division

A. Second

B. First

C. Fourth

D. Fifth

E. Third

Diff: 2

Objective: A3.01 Create a Query with a Calculated Field

84) Match the following mathematical terms with how they are displayed in Access:

I. Parenthesis

II. Exponentiation

III. Division

IV. Multiplication

V. Subtraction

A. /

B. -

C. ^

D. *

E. ()

Diff: 1

Objective: A3.01 Create a Query with a Calculated Field

85) Match the following formatting options with their examples:

I. Long Date

II. Medium Date

III. Short Date

IV. Long Time

V. Medium Time

A. 12/26/1959

B. 26-Dec-59

C. Saturday, December 26, 1959

D. 3:03

E. 3:03:03 PM

Diff: 2

Objective: A3.02 Format Calculated Results

86) Match the areas of the Expression Builder dialog box with the content they display:

I. Top

II. Bottom Left

III. Bottom Center

IV. Bottom Right

V. Expression Builder dialog box

A. Expression Elements

B. Expression Values

C. What appears when you open the Expression Builder

D. Expression Categories

E. Expression box

Diff: 2

Objective: A3.05 Create Expressions Using the Expression Builder

87) Match the following aggregate functions with what they compute:

I. Avg

II. Sum

III. Count

IV. Min

V. Max

A. Counts the number of values in a column

B. Average of a column

C. Returns the lowest value

D. Returns the highest value

E. Totals the items in a column

Diff: 1

Objective: A3.07 Add Aggregate Functions to Datasheets