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
