Match between columns Premises: URL action button hyperlink trigger motion path

The Answer of initiates something when clicked or pointed to is...

Match between columns Premises: thumbnails padlock F3 Ctrl+G only one scroll bar

The Answer of Navigation Pane and bookmarks and Quick Parts is...

Match between columns Premises: Solver Add-in Optimization models Non binding constraint Objective cell

The Answer of Find the highest, lowest, or exact value is...

Exam 6: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

Match the following terms with the corresponding description.

Non binding constraint

The cell that contains the formula-based value that you want to maximize, minimize, or set to a value in Solver

Optimization model

An add-in application that manipulates variables based on constraints to find the optimal solution to a problem

Objective cell

A constraint that Solver enforces to reach the target value

Correct Answer:

Verified

Non binding constraint

Optimization model

Objective cell

Solver

Binding constraint

(Matching)

4.7/5

(36)

Question 41

When a report has been created and used in Access,it can be formatted and laid out differently than the original design.

(True/False)

4.8/5

(36)

Question 42

If a field in a table has a ________ a drop down menu will appear in the field.

(Short Answer)

4.9/5

(33)

Question 43

________ is the correct syntax for the Round function.

(Multiple Choice)

4.7/5

(37)

Question 44

Match the following PowerPoint features with their descriptions:

URL

initiates something when clicked or pointed to

action button

track that an object follows

hyperlink

connection that branches to another location

Correct Answer:

Verified

URL

action button

hyperlink

trigger

motion path

(Matching)

4.8/5

(37)

Question 45

Match the following scenarios with their PowerPoint feature to solve the problem:

add information for a viewer to determine the purpose of a hyperlink

ScreenTip

open a program and a show a feature within it

link to a Web page

link from a menu item in a presentation to slides in another presentation

link to new document

Correct Answer:

Verified

add information for a viewer to determine the purpose of a hyperlink

open a program and a show a feature within it

link from a menu item in a presentation to slides in another presentation

insert an image instead of embedding it

want to access a university department URL during a presentation

(Matching)

5.0/5

(33)

Question 46

Match the following Word options to their related Word features:

start a new, blank document

Create from file

want to start with a partially-complete resume

document theme

don't want to type a company logo over and over again

Building Blocks

Correct Answer:

Verified

start a new, blank document

want to start with a partially-complete resume

don't want to type a company logo over and over again

insert a file into a document without opening it

want to create a coordinated, stylish set of documents

(Matching)

4.8/5

(34)

Question 47

________ is the first method for controlling data input in a field of a table.

(Multiple Choice)

4.9/5

(40)

Question 48

What does a IsNull function do?

(Essay)

4.8/5

(36)

Question 49

Match the following Word terms to their meanings:

thumbnails

Navigation Pane

padlock

bookmarks

F3

Quick Parts

Correct Answer:

Verified

thumbnails

padlock

F3

Ctrl+G

only one scroll bar

(Matching)

4.7/5

(37)

Question 50

The Date function is commonly used as a default value for a date field.

(True/False)

4.7/5

(41)

Question 51

A parameter query is similar to creating most other query types.

(True/False)

4.8/5

(35)

Question 52

When you violate a validation rule,Access allows you to continue entering the record.

(True/False)

5.0/5

(29)

Question 53

________ enable you to execute programming tasks whenever data in a table is changed.

(Short Answer)

4.9/5

(30)

Question 54

A(n)________ rule limits the type of data a user can enter into a field.

(Short Answer)

4.8/5

(35)

Question 55

When using an input mask,parentheses and hyphens are automatically stored with the data.

(True/False)

4.9/5

(32)

Question 56

________ affects the display of the date without affecting the underlying value.

(Multiple Choice)

4.8/5

(40)

Question 57

Match the following terms with the corresponding description.

Solver

Find the highest, lowest, or exact value for one particular result by adjusting values for selected variables

Add-in

Specifies the cell that contains a formula that produces a value that you want to optimize

Optimization models

A constraint that does not restrict the target value that Solver finds

Correct Answer:

Verified

Solver

Add-in

Optimization models

Non binding constraint

Objective cell

(Matching)

4.8/5

(34)

Question 58

A(n)________ property sets the property of a field to force data entry.

(Short Answer)

4.7/5

(44)

Question 59

A(n)________ sets the property of a field to force data entry.

(Multiple Choice)

4.9/5

(36)

Question 60

Exam 6: Data Validation and Data Analysis: Reducing Errors and Extracting Better Information

When a report has been created and used in Access,it can be formatted and laid out differently than the original design.

If a field in a table has a ________ a drop down menu will appear in the field.

________ is the correct syntax for the Round function.

________ is the first method for controlling data input in a field of a table.

What does a IsNull function do?

The Date function is commonly used as a default value for a date field.

A parameter query is similar to creating most other query types.

When you violate a validation rule,Access allows you to continue entering the record.

________ enable you to execute programming tasks whenever data in a table is changed.

A(n)________ rule limits the type of data a user can enter into a field.

When using an input mask,parentheses and hyphens are automatically stored with the data.

________ affects the display of the date without affecting the underlying value.

A(n)________ property sets the property of a field to force data entry.

A(n)________ sets the property of a field to force data entry.

Subtotals, Pivot-tables, and Pivot-charts: Hands-On-Exercise Videos

Desktop Publishing and Graphic Design: Hands On Exercise Videos

Desktop Publishing and Graphic Design: Creating a Newsletter working With Graphics and Linking Objects

Infographics: Creating Text Charts, tables, and Graphs

Subtotals Pivot-tables and Pivot-charts

Infographics: Hands On Exercise Videos

Data Validation and Data Analysis: Hands On Exercise Videos

What If Analysis: Hands On Exercise Videos

Time Saving Tools: Hands On Exercise Videos

Time Saving Tools: Using Templates multiple Documents and Themes

Interactivity and Advanced Animation: Engaging the Audience

What If Analysis

Action and Specialized Queries: Moving Beyond the Select Query

Interactivity and Advanced Animation: Hands On Exercise Videos

Action and Specialized Queries: Hands On Exercise Videos

Specialized Functions: Hands On Exercise Videos

Document Automation: Hands On Exercise Videos

Document Automation: Forms, macros, and Security

Customization: Customizing Powerpoint and the Slide Show

Specialized Functions

Advanced Forms and Reports: Moving Beyond the Basics

Customization: Hands On Exercise Videos

Advanced Forms and Reports: Hands On Exercise Videos

Statistical Functions: Hands On Exercise Videos

Word and the Internet: Hands On Exercise Videos

Word and the Internet: Web Page Creation and Enhancement and Blogs

Collaboration and Distribution: Collaborating, preparing, securing, and Sharing a Presentation

Statistical Functions

Get Connected: Exchanging Data Between Access and Other Applications

Collaboration and Distribution: Hands On Exercise Videos

Get Connected: Hands On Exercise Videos

Multiple Sheet Workbook Management: Hands On Exercise Videos

Multiple Sheet Workbook Management

Fine Tuning the Database: Analyzing and Improving Database Performance

Fine Tuning the Database: Hands On Exercise Videos

Imports, web Queries, and XML: Hands-On-Exercise Videos

Imports, web Queries, and XML

Using Macros and SQL in Access: Advanced Techniques

Using Macros and SQL in Access: Hands On Exercise Videos

Collaboration and Workbook Distribution: Hands On Exercise Videos

Collaboration and Workbook Distribution

Templates styles and Macros

Templates, styles, and Macros: Hands-On-Exercise Videos

Filters