OMIS Quiz Answers

Information printed at the end of each group of records and that is used to display summary information for the group is called a:

Group Footer

What do you press to open the "Zoom Dialog" box in Access when in Query design view?

Shift + F2

The PV is:

The present value, or amount, of the loan.

If a course percentage is in cell S4, a table with percentages in the first column and letter grades in the second column is in the range V13:W17, and we want to display the first student's letter grade for the course in cell T4, what's wrong with this VLOOKUP statement for cell T4 if I want to copy it for all students? =VLOOKUP(S4,V13:W17,2)

There are no absolute references for V13:W17

Which of the following =IF statements is in the correct format?

=IF(16>15000,"Yes","No")

I just purchased a new car for $150,000 at a very nice 1.9% annual interest rate. I want to pay the car off in 3 years. Which of the following formulas would give me my monthly care payment?

=PMT(0.019/12,36-150000)

Which of the following is not an appropriate use of the SUM function?

=SUM(D15-C15)

If a company has a set of rules, which can be listed but can't be calculated by a formula, like a commission structure for dollars sold or something, and they need to apply these rules to many cells (like a large number of employees), then the best way to get this to work in Excel is

=VLOOOKUP function

If cell D15 contains the formula =$C$5*D15, what is D15 in the formula?

A circular reference

Given the function =VLOOKUP(C6,D12:F18,3), the entries in range D12:D18 are in __________ order

Ascending

A ________ is tested in an IF function to determine if it is true or false

Condition

To use text in an IF function it must be enclosed in

""

To use a date in an expression or criteria, don't forget to bracket the date with...

##

Which of the following is an example of an absolute cell reference

$C$4

Given that cells A1, A2, and A3 contain values 2, 3, and 9, respectively, and B6, C6, and D6 contain values 10,20, and 30 respectively, what value will be returned by the function =IF(B6>A3,C6*A1,D6*A2)?

40

A formula containing the entry =$B3 is copied to a cell two columns to the right and one row down. How will the entry appear in its new location?

=B4

If state law requires that a restaurant's wait staff be at least 21 to serve alcohol and you have a database that stores each employee's birth date in the Employee table, which of the following is the proper syntax to identify the employee's year of birth?

BirthYear:DatePart("yyyy",[Employee]![BirthDate])

Which of the following references would indicate that the Row (ONLY) would not change during the copy process?

C$4

Which of the following statements is true in reference to calculated fields:

Calculated fields can be used as input for other calculated fields

If I modify a field in a table that is related to a field in another table, what must I have enabled so that it changes the field in BOTH tables?

Cascade Update Related Fields

To get a totals row in the results view of a query....

Click on the Home tab, while in Datasheet View, and choose "Totals"

_______ uses special models and queries to extract valuable data and patterns from data that may not have been known. It is primarily computer driven (done by the computer).

Data Mining

Which function enables you to insert today's date (only, without time) into an expression?

Date()

In your Query you want to create a calculated field, DaysOnMarket, that calculates the number of days prior to 12/1/2011 that the house has been on the market ("DateListed" is when the house first went on the market, and all houses went on prior to 12/1/2011), which of the following is the correct representation of that formula?

DaysOnMarket: #12/1/2011#-[DateListed]

When designing a calculated field, complex formulas can be created with the ___________.

Expression Builder

To change a relative cell reference to an absolute cell reference, highlight the reference and use the ____________ key.

F4

Expression builder represents fields you choose from tables as: [Table]#[Field]

False

In the following example, NewPrice: [Price] *1.5, the text in brackets would be a(n):

Field

An Access object to enter new records into a table, edit or delete existing records in a table, or display existing records is a:

Form

The Column index number:

Is the argument in VLOOKUP function that identifies from which column to return a value.

The function = PMT(C5,C7,-C3) is stored in cell C15. What must be stored in cell C7?

Number of payment periods

Tom purchasing all of his textbooks from Amazon is an example of a _____ - to - _____ relationship ["Tom" would be in a "Person" table and all of the book titles Tom purchased, and book sellers, in this case "Amazon", would be in a "Books" table]

One, Many

A person who does not know that all of his/her quiz answers, quiz scores, and the quizzes themselves, along with all clicker questions and answers, are posted to our class web site would be classified by Dr. Downing as a __________

Pinball

A function is a

Predefined formula that performs a calculation.

What is the missing argument in the following formula: =PMT(rate,nper,_____,[fv],[type])

Present Value (amount)

The Builder command that opens the Expression Builder is found in the:

Query Setup group on the Design tab

After creating a calculated field, you run the query and a parameter dialog box appears on your screen. How do you respond to the parameter dialog box?

Read the field name specified in the parameter box, and ten look for a possible typing error in the calculated expression.

The COUNT function

Tallies the number of cells in a range that contain numbers.

In the query design view, use __________ to format a column.

The Properties sheet

In Expression Builder, how do I get the name of the expression to be what I want it to be (say I want to name it "Rebate")?

You have to type it in... either in expression builder or replace "Expr1" in the query.