IMT

What icon is not displayed when you select a chart?

Chart Types

Which function is best suited to calculate quartiles including quartiles 0 and 4?

QUARTILE.INC

Which of the following functions will rank two values evenly if there is a duplicate value present?

RANK.EQ

Which function calculates a periodic rate for an investment or loan given the number of payments, fixed periodic payments, and present value?

RATE

____ analysis determines how much projected profits will change if the cost of goods sold per unit changes by $1 or by $2

Sensitivity

When you apply a multiple sort in Access, columns are sorted:

from left to right

Which tab is not available for modifying a report?

group

The object in the database that contains the information you want to display in a report is called the report's ______________ . (17)

record source

A range:

refers to a group of adjacent or contiguous cells.

An X Y (scatter) chart shows:

relationship between two variables

Each column in a table:

represents a field which can contain an individual piece of data for a record.

Keying/typing errors may be corrected by ____ to display a list of suggested spellings and then clicking the correct word.

right clicking a word

Which method of creating a database demands the least amount of expertise in Access?

using a template

Which of these characters is not an acceptable character to use in a range name?

!

In the formula, =1+(2-3)+⅚-6^2, what will Excel evaluate first?

(2-3)

If you set up a two-variable data table to calculate monthly payments on different interest rates and loan terms, what values would be a likely set of entries in the left column of your data table?

3.0%, 3.25%, 3.5%, 3.75%

If there are 5 possible outcomes, how many logical tests are required?

4

Consider the following five values: 1, 1, 6, 7, and 10. The arithmetic mean of these values is ____. (5)

5

In the formula, =1+(2-3)+⅚-6^2, what will Excel evaluate second?

6^2

To set up this two-variable data table, what is in B9?

=$E$5

Which of the following is not a valid criteria in a filter?

=>14

If you need to find the day of the month on which events occurred from a list of dates in the named range of Start_Date, which formula would provide the correct result?

=DAY(Start_Date)

Pressing the Ctrl key plus what other key enables you to select all the controls on a form?

A

What is a nested function?

A function embedded within an argument of another function

What does a green triangle in the upper left corner of a cell signify?

A possible error has been flagged

Which of the following is not a valid test in an =IF statement?

A4-B4

All customer data have been grouped into a single collection of records. This collection should be referred to as a __. (10)

AND

Ryan is working in a database that organizes vendor contact information. Ryan must find vendors located in Seattle and Portland. The vendors must have offices in both cities in order to meet Ryan's requirements. He should use the Filter by Form ________ condition.

AND

If you wanted to reference a cell in a formula and you did not want that cell to change when copying and pasting you would use what kind of reference?

Absolute

What type of cell reference should be used when a value remains constant?

Absolute

What would changing the Value Field Settings in a table accomplish?

Changes the type of calculation that you want to use to summarize data from the selected field.

Which of these would be a good candidate for a one-variable data table and payment function?

Checking scenarios with variable down payments

How do you start Goal Seek?

Click What-If Analysis On the Data tab and then select Goal Seek

Which is an effective way to change a SUM of Price field in the VALUES area to an AVERAGE function?

Click to field's arrow in the VALUES area and select Value Field Settings.

Which chart type displays the data vertically?

Column

What chart type can display two different chart types at the same time?

Combo

The data format that separates the values in each record with commas is often called ____.

Comma-seperated valued CSV

Which is an example of a clear Excel file name

Course_Assignment_LastName.xlsx

What field property would you use to automatically enter "PA" in a state field?

Default type

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

What are the two ways you can view a table?

Design and datasheet views

What is a scenario in Excel What-if analysis?

Detailed set of values that represent different possible situations

What is the purpose of an Excel What-if scenario?

Detailed set of values that represent different possible situations

To exit a slide show, press the ____ key.

ECS

Each time the _____ key is pressed in WORD, the paragraph formatting in the previous paragraph is carried forward to the next paragraph

ENTER

The purpose of formatting data with a chart is to make it ___. (3)

Easier for the viewer to understand

The purpose of formatting data with a chart is to make it ______.

Easier for the viewer to understand

When in Layout or Design view, which of the follow is NOT a form layout tab?

Edit

Auto fill in Excel:

Enables you to copy the contents of a cell or to continue a sequence by dragging the fill handle

After a bullet is created on a PowerPoint Slide, what is pressed to create the next bullet?

Enter

Which of the following is not one of the recommendations when first designing a spreadsheet?

Estimate the amount of time required to complete the spreadsheet

The ________ group on the External Data tab has options that you can use to send a portion of a database to other applications.

Export

What two tabs are unique to Access?

External Data and Database Tools

There is no need to print in our increasingly digital world.

FALSE

Which function would you use to determine the number of occurrences of a particular value in a dataset?

FREQUENCY

Which function will calculate the final value of an investment of $100 a month that earns 4% interest over 5 years?

FV

Dates stored using the Date/Time data type cannot be used in calculations. (11)

False

If a term, instruction, or abbreviation is included in one part of an Access form, then avoid using the same term of abbreviation in another part of the form. (10)

False

The values TRUE, FALSE, SOMETIMES are referred to as Boolean values. (8)

False

To sort fields in a report, click Group & Sort in the:

Grouping & Totals group on the DESIGN tab.

Which option would this wildcard, "H[!oe]" not display?

House

Which of the following is not a primary consideration when designing a report?

How many pages long the report will be

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 a Web page. Sarah should apply a(n) ________ type.

Hyperlink

Which function returns a value at the intersection of a specified row and column?

INDEX

What effect does paying an extra small bit of principal on a mortgage have on the life of a 30 year loan?

It saves money in interest and shortens the length of the loan.

What would be the result if you sorted the following dates in ascending order: December 25 2000, January 1 2015, January 16 1957, December 26 1959?

January 16 1957, December 26 1959, December 25 2000, January 1 2015.

Which of the following names of worksheets tabs would be best?

January Payroll information

Grouping is ______.

Joining rows or columns of related data into a single entity for analysis

What can you not easily do using a form?

Move data

What is not an option in the Layout Options for Grouped Data in the Report Wizard?

Multi-level

The report marked 5 in the accompanying figure is a ____ report.

Multiple columns

Which of the following is not a form tool that is available in Access?

Multiple form

Which financial function calculates the net present value of an investment, given a fixed discount rate?

NPV

Irene is working in a database that organizes city court case information. Irene must find court cases in either Jackson county or Jefferson county. Irene should use the Filter by Form ________ condition.

OR

Where would you find the command to center the printout both horizontally and vertically on your paper?

On the Page Setup, Margins tab

A college admissions office might use which of the following functions to offer scholarships to incoming student who are in the top 10% of their high school classes?

PERCENTILE.INC

The ______________ function finds the value of the payment per period, assuming that there are constant payments and a constant interest rate for the duration of the loan. (16)

PMT

The ________ function calculates the principal payment for a specified period on a loan or investment.

PPMT

On which tab will you find options if you have to print a large dataget?

Page layout

When modifying a report, on which tab would you find the commands for changing the margins of the report?

Page setup

In a VLOOKUP function, the argument ____ refers to the range containing the data that you want to search to find the lookup value.

Table_array

You must create ____ before any of the other database objects.

Tables

The report marked 1 in the accompanying figure is a ____ report.

Tabular detailed

Why is it important to analyze the relationships between a sample and full population?

To help make more informed statements about a population

What is one of the weaknesses of the column chart shown above?

Too many columns

To create a table from an existing range of data:

click the Insert tab and then click Table in the Tables group.

A criteria may be created from a query that matches a range of values by using (19)

comparison operators

A chart filter in Excel:

controls which data series and categories are visible in a chart.

One reason to begin with a template is that you do not have to ________.

create as many objects

Which of the following is not a chart element?

data area

A(n) ____ key is a field or a combination of fields that creates a unique value in each record so you can identify each record in the table.

primary

Goal Seek differs from one and two-variable data table analysis by ________.

providing a single best answer rather than a table of possible answers

A_____________ is a database object that stores criteria for selecting records from one or more tables based on conditions you specify. (15)

query

To add a column header of Payment for the calculation column in a one-variable data table, Select the cell with the calculation formula and then ________.

select Custom Number format and type "Payment" in the type box

A ____ analysis asks, "How much will projected profits change if the cost of goods sold per unit changes by $1? By $2?"

sensitivity

All customer data have been grouped into a single collection of records. This collection should be referred to as a __. (10)

table

Penny has grouped one customer base into a single collection of records. Meredith informs Penny that she should refer to this collection as a ____.

table

A relational database has the ability to create relationships between two:

tables

Filtering the First_Name field to display only records that begin with the letter J uses a:

text filter

Mark tests a formula with a FALSE type in the worksheet shown above: =VLOOKUP(D14,A$7:B$8,2,FALSE). The result is ____.

the #N/A error message

By entering a variety of input data, and comparing the results to output you have already calculated outside the worksheet, you can use ____ analysis to indirectly verify the validity of your worksheet. (6)

What if

Which of the following is FALSE about multi table queries?

You can add fields by clicking a field selector and clicking Add

In the formula Mark is discussing with his co-worker, =VLOOKUP(Z10,H$1:I10,1,FALSE), the lookup_value is ____.

Z10

Which of the following would make a good primary key?

AutoNumber data type

The report marked 3 in the accompanying figure is a ____ report.

Grouped Summary

By default, what is the first table on a worksheet named?

Table 1

Which of the following is not a conditional formatting option?

Table format

If 5% is displayed in a cell, the actual value that is stored is _____.

.05

If A1=2, B2=3, and C3=10, the resulting value of =A1-B2+C3/10 is ____.

0

When using the MATCH function with an exact match lookup_value, the match type must be set to:

0

The ROUND function requires how many arguments?

2

How many characters can be stored in a field with a Short Text data type?

255

What is not a common format for a number control?

Accounting

What is not true about slicers?

Aggregate values do not respond to slicers

The Word Count dialog box in WORD displays the number of words as well as the number of _____ in the current document.

All of the above

Why is formatting important in Excel documents?

All of the above (improves readability and clarity, helps with clearly printed hard copies, ensures files are consistent and organized)

What kind of information should be included within the in-sheet identification

All of the above (name, date prepared, course, assignment)

When using Advanced Filtering empty cells in the criteria range will return which of the following?

All records

What is not true about using the And function in a custom conditional formatting rule?

All the tests must be of the same data type, for example: all numbers or all text

Take a look at the Field List section. The "Values" box is almost always numerical data that is to be summarized. Which field would Jane put into the Values field?

Amount

Which of the following is an Excel Add-in?

Analysis ToolPak

Which chart does a better job of illustrating the collective sales trend in the equipment, footwear, and apparel categories over the eight years?

Area chart

When creating a range for use with a Microsoft Excel TRUE VLOOKUP table, make sure to sort the values in the first column of the table array in _______ order

Ascending

When creating a range for use with a Microsoft Excel TRUE VLOOKUP table, make sure to sort the values in the first column of the table array in ___order. (2)

Ascending

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

Ascending

What are the row and column input cells in this table?

B5 and B4

________ displays alternate fill colors for even and odd rows to help distinguish fields.

Banded rows

Which chart type displays the data horizontally?

Bar

Which of the following is NOT a type of sparkline?

Bar

Which chart type cannot be displayed as a sparkline?

Bar Chart

What is the Criteria2 argument of =COUNTIFS(A2:A64,"Blue",B2:B64, "Black")?

Black

A(n) ____ paragraph is a paragraph that begins with a dot or other symbol.

Bulletted

Which of the following is not considered one of the most common methods to create a form?

Default form

If you wanted to count the number of entries in a list that contain numbers, text, and blank cells, but ignore the blank cells, which function would you use?

COUNTA

Which of the following functions is best suited to count numbers based on multiple conditions?

COUNTIFS

Which function calculates the total amount of interest paid over a specific number of payments?

CUMIPT

In Excel, if a column shows the numbers 1, 2, and 3 and also the SUM equaling 6, the number "6" is a ____.

Calculated value

Which of the following is not a statistical function?

DSUM

If Solver is loaded, it will appear on this tab.

Data

A ___ is used to respond to Microsoft Excel what-if questions involving a range of values. (2)

Data Table

Where is Goal Seek located in Excel?

Data tab

Which of the following is a collection of data organized into meaningful information to be used in a meaningful way?

Database

Which of the following is NOT a number format available in the Number group on the Home tab?

Date Format

What is not a group on the Report Layout Tools Format tab?

Fields

______ is one way to manipulate data in a PivotChart environment

Filter

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

Filter by form

Which of the following wizards for specialized queries is most helpful to identify the same customer who is entered in an Access database with different IDs? (12)

Find Duplicates

The _____, or typeface, defines the appearance and shape of letters, numbers, and special characters.

Font

Most users enter information into a database through the use of a ________.

Form

The section named ____ in the accompanying figure often displays instructions for using the form.

Form Footer

The section named ____ in the accompanying figure contains unbound controls like title, date, and time.

Form Header

Which view is normally used for data entry?

Form View

When modifying a report, on which tab would you find the commands for adding a background image on the report?

Format

Where is the Show Formulas command found?

Formula Auditing group on the Formulas tab

Which of the following is not a freeze option?

Freeze Section

Select PivotTable styles _______.

From thumbnails in a style gallery

Which what-if analysis tool is best suited to determine the exact interest rate required for a $600 car payment repaid over five years?

GOAL SEEK

If Doug would like to determine how many hot dogs to sell at a profit margin of $10.00 to raise $250.00 without constraints, which what-if analysis tool should he use?

Goal seek

The report marked 2 in the accompanying figure is a ____ report.

Grouped

A(n) ____ does not contain an entire record--it only contains the field from the record and a pointer to the record number.

Index

One of the first tasks of creating a database is to identify the ____ that the organization needs to manage and organize.

Information

Which of the following best describes information?

Information is the finished product that is produced by a database.

What field property would you use to insure that all the phone numbers looked consistent?

Input mask

Which tab in Excel can PivotTable be created from?

Insert

What is not found on the Report Layout Tools Arrange tab?

Insert Existing Field

The____ function returns a True value when the field or control is null and False when it is not.

IsNull

PowerPoint draws a red, wavy line below a word on the slide when the word ____.

Isn't in the dictionary

What is not true about an effective chart?

It always contains more than one series.

Which of the following is not true of a form?

It can only display one record at a time

What is a lookup table used for?

It contains data for the basis of a lookup and the data to be retrieved.

The ________Wizard is used to easily create name tags and other specialized tags.

Lable

The accompanying figure shows the tblCustomer form in ____________________ view.

Layout

What type of control is used to help keep controls aligned horizontally and vertically, giving forms a uniform appearance?

Layout

To modify a report, the Arrange tab is displayed in both the ________ views.

Layout and Design

The labels "Equipment", "Footwear", and "Apparel" in the Area Chart are collectively known as ___.

Legend

Which chart element identifies the patterns or colors associated with a data series?

Legend

Which of the following charts displays lines connecting data points to show trends over equal time periods?

Line chart

If you wanted the user to pick from a particular list, what would you pick from the data type drop down list for that field?

Lookup Wizard

The report marked 4 in the accompanying figure is a ____ report.

Mailing Lables

Which form tools creates a box asking for user input?

Modal Dialog

What is the advantage of saving a report as a PDF file?

More people can open the file

John, a manager for a known retail store, finds himself running some queries multiple times with changes to the criteria. He wants to look up in Access Help how to do this more efficiently. What term should he research in the help system? (17)

Parameter query

Excel formulas abides by the order of operations that you may be familiar with in previous math classes. Put the following operations in order

Parenthesis, Exponents, Multiply, Divide, Add, Subtract

____ is the process of copying an item from the Office Clipboard into the document at the location of the insertion point

Pasting

If Jane wants to summarize the data for easy analysis, what tool can she use in MS Excel?

PivotTable

Which of the following is NOT a way to insert a new standard worksheet in Excel?

Press Ctrl+F11

Which of the following is not considered an Excel element?

Print Preview

You have been working in a database. Your boss asks you to design and print out a report for an upcoming board meeting. What view should you use to ensure that the report will print out as intended?

Print Preview

Of the following, which is NOT a main object type in an Access database?

Record

Penny has collected all of the fields for a given customer together. Meredith uses the term ____ to refer to this grouping.

Record

In Access, table relationships are defined in the ____ window.

Relationships

What is the default method of referencing cells in formulas?

Relative

A ________ is a document that displays database information in a meaningful format.

Report

When running a report, which sort order takes precedence?

Report

A PivotChart _______.

Represents the consolidated data of a PivotTable visually.

To create a one-dimensional table, which box would the Salesperson field be placed?

Row

Which of the following is not a report view?

SQL view

The ________ function is the default summary statistic for PivotTables.

SUM

Which of the following functions is best suited to add numbers based on one condition?

SUMIF

Which of the following is not a valid method to remove a field from a PivotTable?

Select the field to be removed in the PivotTable and Press DELETE

Which is not true of filters in a PivotTable?

Summary statistics do not change to reflect the values selected in the slicer.

Microsoft has moved toward __________________ services for sharing data on you company's local Intranet or on the web.(18)

Share point

What can you not import from one Access database into another Access database?

Sheets

In Form view, to sort a field containing names from A to Z, click Ascending in the:

Sort & Filter group on the HOME tab.

You can use the ________ allows to make changes to the layout while you are viewing the data on the form.

Stacked layout

What is the common name for the square root of the variance?

Standard deviation

____ is a measure of how widely the data values are dispersed from the arithmetic mean.

Standard deviation

What is not one of the six guidelines for creating fields?

Store data in as large of number of parts as possible

The accompanying figure shows a(n) ____________________ near the bottom of the tblCustomer form, which represents related records from another table.

Subform

What database object organizes your data by rows and columns?

Table

What type of form control is normally used to display data?

Text box

The filter "Begins With..." option is found on which type of filter?

Text filter

When creating a report, ________ asks a series of questions and uses the answers to generate a customized report.

The report wizard

PowerPoint provides design ____, which are files that contain colors and formats for the background and the type style for titles, accents, and other text.

Themes

To add a field to a report, click Add Existing Fields in the:

Tools group on the DESIGN tab.

A pie chart may be used to show relative percentages rather than values.(9)

True

A primary key and its foreign key counterparts must have the same data type and field size.(16)

True

Data in a relational database is stored in one or more tables. (20)

True

Every solver problem must include an objective function which should either be maximized, minimized, or set to a specific value.

True

Given a pharmacy's database, when one member of a customer household reports a new address or change of insurance that also affects other people in the household, the pharmacy database must update the records for everyone affected by the change. (13)

True

Microsoft Excel provides a variety of predefined functions, including statistical functions that can be used to determine such values as the arithmetic mean, median, mode, and standard deviation of a set of data. (8)

True

Query results made to a transaction database are dynamic. (12)

True

The DStDevP function calculates the standard deviation across a population in a specified set of records. (21)

True

The Query wizard lets you choose your data source and select the database table and fields you want to import into a workbook.(15)

True

The formula =C4*D4 uses only relative cell references.

True

The timeline of the cash flows should be considered when constructing a formula with a financial function.(1)

True

When you click the Enable Content warning, the database is now ________.

Trusted on this computer.

A(n) ________is a matrix that provides the results (TRUE or FALSE) for every possibility of an AND, OR, or NOT criteria combination.

Truth table

Simulation is an analytical method that creates artificially generated data to imitate real data.(7)

Ture

What tool would be most effective when comparing the impact of changes in interest rate and purchase price on a new car loan?

Two variable data table

Which of the following tools is best suited for comparing the effects of two variables on a formula?

Two-variable data table

Which of the following is NOT a way to create a table in Access?

Typing a field name in a row in Design view

_________controls are often used to display report titles, informational text, lines, rectangles, and graphics not stored in an underlying table. (18)

Unbound

If you create a Recommended PivotTable on a group of data about book sales with these columns: Discipline (i.e. business), Area (i.e. Finance and Marketing), Units sold, wholesale price, what column might Excel use as values?

Units sold

Which of the following are elements to consider when designing an Excel spreadsheet for business use?

Usability, readability and size

Which of the following is not recommended as a professional way of styling a form?

Use several fonts to indicate different types of data

What is the best practice for centering a title over multiple columns?

Use the Merge and Center alignment

What function returns the variance of a population?

VAR.P

Which field property helps a user know why an entry error was generated?

Validation Text

Which axis in a chart displays incremental numbers for the data points?

Value

Which of the following is not an argument associated with the IF function?

Value if neither true nor false

Which paste option would you choose if you wanted only the computed values to be pasted but with all formatting intact?

Values and Source formatting

When creating a one-variable data table that depicts the effect of different interest rates on a car payment, the interest rate is an example of which of the following?

Variable

In a bar chart, which axis displays the categories?

Vertical

An output area is defined as:

a region of a worksheet with formulas dependent on values from an input area

In the formula =B2=C2, the second equal sign is interpreted as ____. (4)

a relational operator

$B$1 is an example of a(n) _____ reference.

absolute

Which function is not a Subtotal function?

aggregate

The Microsoft Excel OR function returns a value of FALSE if ___.`

all arguments in the function are FALSE

Data may be entered into an Excel worksheet by ____.

all of the above

Goal Seek uses ____ approach to finding the right input that achieves the desired result, or goal, in the dependent cell. (6)

an iterative

The random values ____ every time another value or formula is entered in a cell anywhere on a Microsoft Excel worksheet. (7)

automatically changes

The Freeze Panes option keeps:

both rows and columns above and to the left of the active cell visible as you scroll.

To assign a field size of 12 to a field you would ________.

enter 12 in the Field Size property of that field

The IF function:

evaluates a condition and returns one value if the condition is true, a different if false.

A customer's cell phone would be an example of a ________.

field

Penny is confused by Meredith's use of the term column. Meredith informs Penny that column is a synonym for ____.

field

Penny knows that items such as first name, last name, city, state, and zip are referred to by a common name. Meredith informs Penny that she can use the term ____ to refer to these items.

fields

The error message ###### means that there is____.

insufficient width in cell to display data, or negative date/time.

What is the first argument of the IF function?

logical_test

A significant new feature of computer technology with ethical implications is (14)

malleability of information

A primary key:

must contain a unique value for each record within a table.

What describes a functions purpose?

name

You may choose Access over Excel in all of the following situations EXCEPT when you

need to create complex charts.

=IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)) is an example of a(n):

nested IF function

Access lets you update table records from a query datasheet if the query is based on tables that have a ____ relationship. (20

one-to-one

A major factor in raising ethical and legal issues is (14)

opportunities for anonymity

Jane wants to filter the report based on which holiday package was being purchased. Which field should be added to the Report Filter box?

package

In the FV function, the rate argument refers to the:

periodic rate

One of Mark's co-workers asks what would happen if he changed the formula to one having a FALSE type. As an example for discussion, Mark writes: =VLOOKUP(Z10,H$1:I10,1,FALSE). How does the FALSE type affect this formula: ____.

the VLOOKUP function looks only for an exact match of the lookup_value

The nper in a PMT function is:

the total number of payment periods.

A range is specified by its

top left and bottom right cells

The ___ is the vertical axis where data values are plotted. (3)

y- axis

Enforcing referential integrity ensures that ________.

you cannot enter a value in the foreign key if there is no corresponding value in the primary key