IMT || acknowledged answers 100%.
____ analysis determines how much projected profits will change if the cost of goods sold per
unit changes by $1 or by $2 correct answers Sensitivity
____ is a measure of how widely the data values are dispersed from the arithmetic mean. correct
answers Standard deviation
____ is the process of copying an item from the Office Clipboard into the document at the
location of the insertion point correct answers Pasting
______ is one way to manipulate data in a PivotChart environment correct answers Filter
________ displays alternate fill colors for even and odd rows to help distinguish fields. correct
answers Banded rows
_________controls are often used to display report titles, informational text, lines, rectangles,
and graphics not stored in an underlying table. (18) correct answers Unbound
=IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)) is an example of a(n): correct answers nested IF
function
You must create ____ before any of the other database objects. correct answers Tables
You may choose Access over Excel in all of the following situations EXCEPT when you correct
answers need to create complex charts.
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? correct answers Print Preview
,You can use the ________ allows to make changes to the layout while you are viewing the data
on the form. correct answers Stacked layout
You can click the ________ button on the table toolbar to sort records in alphabetical order, from
A to Z. correct answers Ascending
Why is it important to analyze the relationships between a sample and full population? correct
answers To help make more informed statements about a population
Why is formatting important in Excel documents? correct answers All of the above (improves
readability and clarity, helps with clearly printed hard copies, ensures files are consistent and
organized)
Which what-if analysis tool is best suited to determine the exact interest rate required for a $600
car payment repaid over five years? correct answers GOAL SEEK
Which view is normally used for data entry? correct answers Form View
Which tab is not available for modifying a report? correct answers group
Which tab in Excel can PivotTable be created from? correct answers Insert
Which paste option would you choose if you wanted only the computed values to be pasted but
with all formatting intact? correct answers Values and Source formatting
Which option would this wildcard, "H[!oe]" not display? correct answers House
Which of these would be a good candidate for a one-variable data table and payment function?
correct answers Checking scenarios with variable down payments
, Which of these characters is not an acceptable character to use in a range name? correct
answers !
Which of the following would make a good primary key? correct answers AutoNumber data type
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) correct answers Find
Duplicates
$B$1 is an example of a(n) _____ reference. correct answers absolute
A ____ analysis asks, "How much will projected profits change if the cost of goods sold per unit
changes by $1? By $2?" correct answers sensitivity
A ___ is used to respond to Microsoft Excel what-if questions involving a range of values. (2)
correct answers Data Table
A ________ is a document that displays database information in a meaningful format. correct
answers Report
A chart filter in Excel: correct answers controls which data series and categories are visible in a
chart.
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? correct answers
PERCENTILE.INC
A criteria may be created from a query that matches a range of values by using (19) correct
answers comparison operators
____ analysis determines how much projected profits will change if the cost of goods sold per
unit changes by $1 or by $2 correct answers Sensitivity
____ is a measure of how widely the data values are dispersed from the arithmetic mean. correct
answers Standard deviation
____ is the process of copying an item from the Office Clipboard into the document at the
location of the insertion point correct answers Pasting
______ is one way to manipulate data in a PivotChart environment correct answers Filter
________ displays alternate fill colors for even and odd rows to help distinguish fields. correct
answers Banded rows
_________controls are often used to display report titles, informational text, lines, rectangles,
and graphics not stored in an underlying table. (18) correct answers Unbound
=IF(E5<J7,F5*K7,IF(E5<=J8,F5*K8,F5*K9)) is an example of a(n): correct answers nested IF
function
You must create ____ before any of the other database objects. correct answers Tables
You may choose Access over Excel in all of the following situations EXCEPT when you correct
answers need to create complex charts.
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? correct answers Print Preview
,You can use the ________ allows to make changes to the layout while you are viewing the data
on the form. correct answers Stacked layout
You can click the ________ button on the table toolbar to sort records in alphabetical order, from
A to Z. correct answers Ascending
Why is it important to analyze the relationships between a sample and full population? correct
answers To help make more informed statements about a population
Why is formatting important in Excel documents? correct answers All of the above (improves
readability and clarity, helps with clearly printed hard copies, ensures files are consistent and
organized)
Which what-if analysis tool is best suited to determine the exact interest rate required for a $600
car payment repaid over five years? correct answers GOAL SEEK
Which view is normally used for data entry? correct answers Form View
Which tab is not available for modifying a report? correct answers group
Which tab in Excel can PivotTable be created from? correct answers Insert
Which paste option would you choose if you wanted only the computed values to be pasted but
with all formatting intact? correct answers Values and Source formatting
Which option would this wildcard, "H[!oe]" not display? correct answers House
Which of these would be a good candidate for a one-variable data table and payment function?
correct answers Checking scenarios with variable down payments
, Which of these characters is not an acceptable character to use in a range name? correct
answers !
Which of the following would make a good primary key? correct answers AutoNumber data type
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) correct answers Find
Duplicates
$B$1 is an example of a(n) _____ reference. correct answers absolute
A ____ analysis asks, "How much will projected profits change if the cost of goods sold per unit
changes by $1? By $2?" correct answers sensitivity
A ___ is used to respond to Microsoft Excel what-if questions involving a range of values. (2)
correct answers Data Table
A ________ is a document that displays database information in a meaningful format. correct
answers Report
A chart filter in Excel: correct answers controls which data series and categories are visible in a
chart.
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? correct answers
PERCENTILE.INC
A criteria may be created from a query that matches a range of values by using (19) correct
answers comparison operators
