Exam 3 Review

Created by tannia_juwana 

Upgrade to
remove ads

218 terms · Excel Ch. 7 & 8, Access Ch. 1-3

You can click the ________ button on the table toolbar to sort records in alphabetical
order, from A to Z.

ascending

Irene is working in a database that organizes city court case information. Irene must find
court cases in either one of two cities. Irene should use the Filter by Form ________
condition.

OR

In the table pictured above, if you wanted to organize the data from the lowest Client ID
to the highest Client ID, you would ________ the Client ID field.

sort

Which of the following statements best describes a one‑to‑many relationship between
two tables?

A primary key in the first table matches several foreign keys in the second table.

When defining a field, the field ________ property determines how much physical storage
space the field requires.

size

Which statement accurately describes the function of a query?

Queries manipulate data stored in tables, displaying only those records which match the query's criteria

A field name can begin with a(n) ________.

number

The ________ view in Access looks similar to an Excel Spreadsheet.

Datasheet

In the table pictured above, the ________ field would make the best primary key.

Client ID

Constants that are used as arguments in expressions can be defined as ________.

Values that do not change

An expression or integer value specifying total number of payments in a loan is the
________ argument in the PMT function.

num_periods

A ________ produces professional appearing formatted information derived from the
information contained in tables or queries.

report

Consider the following equation: 3 * (6 + 5) ‑ 4 /2. Which operation would be calculated
FIRST according the order of operations:

(6 + 5)

Which of the following would be the best choice for a primary key?

Social Security Number

You can use ________ to create a relationship between two tables using a common field.

join lines

What function in a Totals Row would calculate the least valued data item in a group?

Minimum

When choosing between Access and Excel, it is best to use Excel in all of the following
circumstances EXCEPT:

you need to create complex charts or graphs

The ________ organizes and lists the database objects in an Access database.

navigation pane

A(n) ________ is a variable or constant that is needed to produce output for a function in
a calculated field.

argument

Steven is working on a database that stores student data. He needs to find students
majoring in either one of two majors. He is looking for students majoring in Economics.
He also is looking for students majoring in History. Which operator would Steven use to
find this information?

OR

Two or more tables which contain duplicate data is an example of ________.

data redundancy

In the table pictured above, the column labeled Last Name is an example of a:

field.

Consider the table pictured above. The value 4 in the totals row represents the number
of employees listed in this table. How was this value calculated in the totals row?

This value is a result of the Count function being applied to the
LastName Field

Which of the following functions do NOT work with 3‑D formulas?

VLOOKUP

When two windows of the same workbook are opened, Excel adds ________ to the title
bar of the second window.

the number 2

Where is the Analysis ToolPak located if it is already loaded on to Excel?

Analysis group, Data tab

The PERCENTRANK.INC function displays ________ significant digits by default.

3

After saving the arrangement of windows, a workbook can be opened by opening the
________ file.

workspace

Which of the following is NOT a valid argument for the SUMIFS function?

Range

A typical amortization schedule show all of the following EXCEPT:

who each payment goes to.

Which of the following is NOT a valid argument for COUNTIFS?

Range

The ________ function returns TRUE if the argument is false and FALSE if the argument is
true.

NOT

The ________ function returns TRUE if any argument is true and returns FALSE if all arguments are false.

OR

To determine how many logical tests you need for a nested IF function, add the number
of outcomes and then subtract ________.

one

Excel allows you to use up to ________ IF statements in one formula.

64

Where do you go to begin loading the Analysis ToolPak add‑in?

Options on the File tab

The Watch Window command is located on the ________ tab.

Formulas

Which of the following is considered a conditional statistical function?

SUMIF

Which of the following is NOT a method for creating database functions.

Type D and the remaining function.

If the active cell is in column A, but not in row 1 when you click the Split command, the worksheet will appear in two ________ panes.

horizontal

Which of the following is found in Math & Trig in the Function Library?

...

Which function identifies a value's rank with a list of values?

RANK.EQ

Programmers often create ________ tables to help analyze the conditions to determine the overall result.

truth

The ________ symbol in the criteria range will return records with empty fields.

=

Which of the following is NOT a valid argument for RANK.AVG?

Average

If the active cell is in row 1, but not in column A, when you click the Split command, the worksheet will appear in two ________ panes.

vertical

Which of the following is a valid worksheet reference to a sheet named Year3?

Year3!F8

Which of the following is NOT an example of an Access object?

Report tool

Steve is working in a database that stores student exam grades. He needs to create a query that will show the numerical mean of exam grades. He should use the ________ function on the column containing the grades.

sum

The result of a query, which appears similar to a table, is called a ________.

...

Rich is working on a database that stores a list of vendors and price quotes for a remodeling project. If Rich wanted to create a query to find the least expensive price quote, he should use the ________ function on the column containing the price quotes.

min

A primary key:

...

All the following statements are true regarding functions arguments EXCEPT:

An argument can be the value of a label

Which of the following statements offers the best method for ensuring that a database is recoverable in case of corruption?

Make a copy of the database before attempting to make changes to the database

The ________ function isolates a specific portion of a date, such as the day, month, or year, in a date field.

DatePart

In the MATCH function the match_type argument contains a ________ if you are searching for the first value that is an exact match.

0

You can edit a hyperlink by right-clinking the hyperlink and selecting ________ from the shortcut menu.

Edit Hyperlink

When using the Trace Dependent command, blue arrows show cells with no errors and ________ arrows show cells with errors.

red

Textual hyperlinks appear ________ with a ________ underline.

blue, blue

Hyperlinks can do all EXCEPT:

link to another Web browser.

The New Window command located in the Window group on the View tab, opens:

another window of the current workbook.

Which of the following is NOT a method for splitting a worksheet?

Right-click in the active cell and click Split.

The value1 argument in the ________ function represents a sequence of payments and income during an investment period.

NPV

To group adjacent worksheets:

click first tab, hold Shift and then click the last tab.

The quickest way to group all worksheets is to:

...

Which of the following functions has limited usefulness unless used inside another function?

AND

The SUMIF function requires which arguments?

...

Which of the following is NOT a valid argument for the MATCH function?

Range

Which of the following external references is correct for a workbook and worksheet that have no spaces?

[NewJersey.xlsx]Qtr4!B6

A PERCENTRANK.INC function that returns .909 indicates the value is in the:

90.9% percentile.

Which of the following is a proper function of PPMT where B2 is the loan amount, B3 is the APR, B4 is the number of years, and A8 is the payment number?

=PPMT(B3/12,A8,B4*12,-B2)

The PMT function is BEST suited to determine:

The monthly payment on a car loan

The maximum size of the Text data type is ________ characters.

255

Expression Builder can be opened by selecting Builder located in the Query:

Setup group

Jen is working on a database that stores employee data. In the EmployeeData Table, there is a field that stores the number of years each employee has been with the company. She needs to design a query that shows all employees that have worked for company more than ten years. Which of the following query criteria should Jen use to locate is information and display records of employees with the company more than ten years?

>10

Sum, Avg, and Max are examples of ________ functions that are used to evaluate entire columns of data.

...

A(n) ________ field is used to produce a value from an expression or function.

calculated

Which field property type should be applied to fields that should not remain empty?

Required

All of the following are true in reference to built-in functions EXCEPT:

Built-in functions can only perform calculations on numeric data.

Which of the following statements is true regarding multi-table queries?

Skill is required in choosing the right tables and managing table relationships

All of the following are arguments of the built-in PMT function EXCEPT:

Loan payment

A(n) ________ operator, such as the greater than or less than symbol, can can be used in a query ciriterion to limits the results produced by the query.

...

Irene is working on a database that stores customer data and order information. The Customer Information Table holds customer information. A unique customer number serves as the primary key for this table. The Order Information Table holds order information. A unique order number serves as the primary key for this table. A customer only has one customer number but may have several order numbers. If Irene wants to establish a one-to-many relationship between the customer information table and the order information table, which of the following steps should she follow?

Irene should include the primary key in the customer information table as a foreign key in the order information table.

Consider the table pictured above. The value of $17.50 in the totals row represents the mean hourly wage. How was this value calculated in the totals row?

This value is a result of the Average function being applied to the HourlyWage Field

Which of the following statements is true about data types and delimiters?

Different data types require different delimiters

You are reviewing a table you created in an Access database. As you review the table, you notice a column of cells that are supposed to contain sales figures have pound signs through them (#######). What is the cause of these pound signs?

The pound signs are present because the column is not wide enough to display the data.

Which of the following query criteria would be used to produce results for Date/Time fields containing a date of December 12th, 2010?

#12/12/2010#

Alice is working in a database containing the names, service locations, and services offered by landscapers. She needs to find landscapers in that offer services in the Washington area and that service rare flowers. The best way for her to search for this data is to perform a:

Filter by Form

An expression used in queries to filter records in a table is called a(n):

criterion.

The ________ is a special character that is used to represent one or more characters in the criterion of a query.

wildcard

Which of the following statements is true about how Access and Excel share data:

Access can import data from Excel, and export data to Excel

The ________ function measures the amount of time that has elapsed between two dates.

DateDiff

The value in a field with the ________ data type will be automatically increased each time a new record is entered.

...

Marla is working in a database that stores customer purchases. She needs to find customers in the New York area that have purchased over $5000 worth of goods. Which query operator would Marla use in a query to find this information?

AND

An IF function contains all the following arguments EXCEPT:

Range

The #DIV/0 error appears when the ________ function finds no records that meet the criteria.

DAVERAGE

The database argument should contain all EXCEPT:

Criteria

Excel splits a worksheet:

above and to the left of the active cell.

The COUNTIF function requires which arguments?

range, criteria

IF functions allow ________ in the value_if_true and value_if_false arguments.

formulas

Excel's multiple worksheet abilities can do all of the following EXCEPT:

Create PivotCharts

Data validation can do all the following EXCEPT:

specify the correct formatting data must have

Which of the following is considered a relative standing function?

RANK.EQ

Which formula would return the #NAME? error?

...

Craig is working in a database that stores homes for sale for a Realtor. The database contains a table called HomeListings which contains a field called ListingDate that holds the date that a home was listed. Craig is designing a query that will identify houses on the market for less than 30 days as new listings, and houses on the market 30 days or more as old listings. This information will be included in a query column called ListingAge. Which of the following expressions will achieve these results:

ListingAge: IIf(Date-[HomeListings]![ListingDate]<30,"New Listing","Old Listing")

Dianna wants to compact an Access database. She can find the tool to compact the database by clicking on the ________ tab.

File

The ________ tab contains all the tools necessary for producing tables, forms, and queries in Access

Create

The ________ data type can store text, numerals, and symbols

Text

A ________ displays a subset of records based on specified criteria

filter

The ________ tab holds all of the operations necessary to carry out data import and export

External Data

The ________ data type is used to hold sentences or paragraphs of descriptive data

...

The ________ determines what field values are allowed and what other properties the field will have

data type

All of the following are acceptable field names EXCEPT

Clientnumber

Joe is working in a database that stores client data. He needs to design a field that will assign a client ID number each time a user enters a new client. The data type he should apply to this field is:

AutoNumber

In the table pictured above, the last row of data shown ( 2734, Riker, William, 212-566-1701.) is a

record

All of the following are valid statements in reference to the IIf function EXCEPT

IIf functions work only with numeric values and not with text

The first two arguments of the DatePart function are ________ which describes the part of the date that will be returned; and ________ which tells Access where to locate the date/time information

<<interval>>, <<date>>

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

Calculated fields can be used as input for other calculated fields

A ________ is a question you ask about data stored in a database

query

In the table pictured above, each column represents a

field

Selecting data by means of a query

displays only the data that matches the query selection criteria

It is more efficient to copy and use an existing query for a new query when

the query criteria needed will be similar to the original query

Ben is working in a database that stores student information. He wants to determine each student's age based on the student's birthday. Which of the following statements accurately describe how the fields should be designed?

The birthday should be a stored field and the age should be a calculated field

The built-in IIf Function evaluates a condition and displays ________

one value when the condition is true and another value when the condition is false

Katie is working in a customer table and needs to know if any customers are located in Texas. In order to locate this information, she would

create a query

Which of the following is true about the NOT operator

The NOT operator returns all records except those that meet the specified criteria

By selecting the ________ option, you can make sure that data entered into a related table first exists in the primary table

...

Jenny is working on a database that stores invoices. She needs to include the current day, month, and year, which will be derived from the computer system, on each new invoice. She should use the ________ function for this purpose

DatePart

Which of the following is the correct mathematical sequence for the order of operations

Exponentiation, Multiplication, Division, Addition, Subtraction

Database design begins with

grouping data into the correct tables

A form can be used to

enter, edit, and view records in a database

When designing an expression for a calculated field, the name of the calculated field followed by a(n)

colon

David is working in a database that organizes student exam grade information. He needs to find all students who have scored 100 on an exam. David can apply a(n) ________ to the data in order to show only records that meet the criteria

Filter

Expression Builder inserts ________ that tell you where each argument belongs

placeholders

The ________ tab holds some of the more advanced features in Access

Database Tools

The ________ field property changes how a field will appear when displayed or printed, but does not change the values stored in the field

Format

Jose is working on a database that stores stock information. He needs to design a field that will allow a user to connect to a graph created in Excel. The data type he should apply to this field is

OLE

You create a calculated field that finds the average of a column of numbers. Access automatically names the field Expr1. Which of the following statements is true regarding the automatic naming of the calculated field

Access assigns Expr1 to a calculated field without a name, and this name can be edited

In the INDEX function the ________ argument refers to the column in the array from which the reference is to be obtained

Column_num

To create an external reference you must first

open the destination workbook and all source workbooks

Which of the following is NOT a method for creating a hyperlink?

Double-click the cell and then click on Hyperlink.

What happens when you right-click a hyperlink and choose Remove Hyperlink?

The hyperlink is removed, but the text remains

________ a cell in the Watch Window dialog box moves your cursor to that cell in the worksheet.

Double-clicking

Which of the following is NOT a method for removing a split window?

...

To find out how much money you would make on an investment of $1,000.00 with a periodic rate of 5% use the ________ function

FV

Which of the following is found in Math & Trig in the Function Library

SUMIF

The ________ command allows you to visually see the dependent cells of a formula

Trace Dependents

Why is a minus sign (-) used in the Pv argument in a IPMT function?

So the interest payment amount appears as a positive number

The Trace Precedents command is found in the ________ group

Formula Auditing

See More

Please allow access to your computer’s microphone to use Voice Recording.

Having trouble? Click here for help.

We can’t access your microphone!

Click the icon above to update your browser permissions above and try again

Example:

Reload the page to try again!

Reload

Press Cmd-0 to reset your zoom

Press Ctrl-0 to reset your zoom

It looks like your browser might be zoomed in or out. Your browser needs to be zoomed to a normal size to record audio.

Please upgrade Flash or install Chrome
to use Voice Recording.

For more help, see our troubleshooting page.

Your microphone is muted

For help fixing this issue, see this FAQ.

Star this term

You can study starred terms together

NEW! Voice Recording

Create Set