Deck 4: Query Calculations and Expressions

Question 1

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

Answer 1

C

Question 2

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

Answer 2

A

Question 3

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

A)variable
B)field
C)argument
D)constant

Answer 3

D

Question 4

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)

Question 5

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.

Question 6

What symbols does Access use to indicate a field name?

A)[]
B)()
C){}
D)""

Question 7

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

Question 8

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

Question 9

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

A)Formatting
B)Modify
C)Build
D)Property

Question 10

Which of the following is not an arithmetic operator?

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

Question 11

What symbol does Access use to express exponentiation?

A)^
B)*
C)<>
D)()

Question 12

What are predefined computations that perform complex calculations?

A)Formulas
B)Functions
C)Arguments
D)Expressions

Question 13

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

Question 14

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

Question 15

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.

Question 16

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

A)Parenthesis
B)Multiplication
C)Division
D)Addition

Question 17

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

Question 18

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

Question 19

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.

Question 20

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.

Question 21

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

Question 22

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

Question 23

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

Question 24

Access uses parenthesis ()to identify a field name.

Question 25

Access will identify logical errors in calculated fields.

Question 26

Which of the following is not a common aggregate function?

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

Question 27

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

A)Total_due
B)Rate
C)Future_value
D)Type

Question 28

Calculating values will help to avoid inconsistencies.

Question 29

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

Question 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

Question 31

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

Question 32

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

A)Argument
B)Property
C)Value
D)Expression

Question 33

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

Question 34

What is not an example of a function?

A)=RATE
B)=PV
C)=PMT
D)=15*21

Question 35

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

Question 36

Calculated fields must always contain at least one constant.

Question 37

Access refers to ________ as aggregate functions.

A)Sums
B)Complex functions
C)Whole Column functions
D)Totals

Question 38

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

A);
B),
C):
D))

Question 39

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.

Question 40

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

Question 41

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

Question 42

Some functions have optional arguments.

Question 43

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

Question 44

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

Question 45

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

Question 46

<> is an example of an argument.

Question 47

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

Question 48

You can add aggregate functions to calculated fields.

Question 49

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.

Question 50

You can add conditions to a Totals query.

Question 51

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

Question 52

All aggregate functions can be used with any field type.

Question 53

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

Question 54

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

Question 55

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

Question 56

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

Question 57

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

Question 58

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

Question 59

The Expression Builder tool helps you create complex expressions.

Question 60

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.

Question 61

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

Question 62

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

Question 63

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

Question 64

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

Question 65

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

Question 66

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

Question 67

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

Question 68

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

Question 69

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

Question 70

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

Question 71

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

Question 72

The ________ sheet allows you to format a field.

Question 73

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

Question 74

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

Question 75

The ________ aggregate function totals the items in a column.

Question 76

Functions generate results based on ________.

Question 77

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

Question 78

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

Question 79

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