CS 235 Exam 3

Created by reidb93 

Upgrade to
remove ads

The function IF(E2<=A3,E2B3,IF(E2<=A4,E2B4,E2*B5)) has two logical tests and will produce one of ________ potential outcomes.

three

The tabs of grouped worksheets are displayed with a ________ background

white

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

AND

The NPV function has ________ required arguments.

two

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

An IF function contains all the following arguments EXCEPT:

Range

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

Edit Hyperlink

To create an external reference you must first:

open the destination workbook and all source workbooks

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

Range

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

the number 2

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

[NewJersey.xlsx]Qtr4!B6

Data validation can do all the following EXCEPT:

specify the correct formatting data must have.

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

Right-click in the active cell and click Split

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

=

In addition to verifying the accuracy of a calculated field using a calculator, you can also use a(n) ________ to verify results

Excel spreadsheet

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

Setup group

A field, or a combination of fields, that has a unique value is a:

primary key/

Data from two or more tables can be connected by specifying a:

common field

Sarah is working in a database that stores resort vacation information. She needs to design a field that will allow a user to link to an external website. The data type she should apply to this field is:

Hyperlink

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#

Which field property type should be used to enter a predefined value into a field when most of the records will have the same value?

Default Value

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

Argument

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

Values that do not change

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

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

criterion.

________ a database rearranges data and objects in a database to make its size smaller.

Compacting

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

three

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

NOT

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 NOT a valid argument for COUNTIFS?

Range

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

0

A ________ allows you to see, inspect, audit or confirm formula calculations of cells not immediately visible on the screen.

watch window

The Advanced Filter dialog box allows you to do all EXCEPT:

Enter criteria.

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

RANK.EQ

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>>

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

Which of the following statements is INCORRECT regarding aggregate functions?

Aggregate functions can return multiple values

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

Setup group

A ________ displays a subset of records based on specified criteria.

filter

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

Argument

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

referential integrity

The ________ tab is the default Access tab and contains basic editing functions.

Home

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

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

Aggregate

The Trace Precedents command is found in the ________ group.

Formula Auditing

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

Double-clicking

To group nonadjacent worksheets:

click first tab, hold Ctrl and then click last tab.

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

64

The quickest way to group all worksheets is to:

right-click a worksheet tab, then select Select All Sheets

Which of the following is considered a relative standing function?

RANK.EQ

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

OR

Grouping worksheets helps you to do all of the following EXCEPT:

apply Conditional Formatting.

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.

Jenna is working on a database that stores a company's invoices. The database includes a Table called Invoices, which has a column called outBalances that shows all outstanding balances. Jenna's boss has asked her to design a query that calculates the numerical mean of all outstanding balances. Which function should Jenna use on the outBalances column to help her complete this task?

Avg

A ________ displays a subset of records based on specified criteria.

filter

A relational database is a collection of:

related tables.

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.

Date

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.

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

one

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

NOT

The SUMIF function requires which arguments?

Range, criteria, sum_range

If a worksheet name has a space in it, ________ surround the worksheet name in the worksheet reference.

single quotation marks

Each row in the criteria range sets a(n) ________ condition where any of the conditions can be met.

OR

The COUNTIF function requires which arguments?

Range, criteria

A form can be used to:

enter, edit, and view records in a database.

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

Sort

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

recordset

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

Calculated fields can be used as input for other calculated fields

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

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

ascending

A form can best be described as a(n):

object

Which of the following is the proper use of a 3-D formula?

=SUM('Yr1:Yr5'!C7)

The database argument should contain all EXCEPT:

Criteria

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

wildcard

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

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

Memo

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

The AVERAGEIF function requires which arguments?

Range, criteria, average_range

Which of the following is considered a conditional statistical function?

SUMIF

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

Average

Each entry in a row of the criteria range sets a(n) ________ condition where each condition must be met.

AND

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

Year3!F8

The IPMT and PPMT functions have ________ required arguments.

four

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.

Expression Builder inserts ________ that tell you where each argument belongs.

placeholders

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