Match between columns Premises: SUM AVERAGE MIN MAX MEDIAN

The Answer of Returns the largest number in a range is...

Match between columns Premises: RANK.EQ QUARTILE.INC RANK.AVG PERCENTRANK.EXC PERCENTRANK.INC

The Answer of Identifies the rank of a value but is...

Match between columns Premises: Blogger Pin to list button Flickr embedded video Single File Web page

The Answer of an online photo service and allow you is...

Match between columns Premises: bookmark hyperlink theme background customize Ribbon

The Answer of assign colors to the elements on the is...

Match between columns Premises: Web server FTP index.html URL HTML

The Answer of a process that transfer files between a is...

Match between columns Premises: ANOVA Analysis ToolPak Covariance Inferential statistics Histogram

The Answer of Helps make predictions about the characteristics of is...

Match between columns Premises: Ctrl+Click Ctrl+O Alt+F Alt+Tab Ctrl+A

The Answer of display the Open dialog box of the is...

Exam 8: Data Validation and Data Analysis: Hands On Exercise Videos

A(n)________ allows the user to select a field value from a list of options.

(Multiple Choice)

4.9/5

(36)

Question 21

Match the following terms with the corresponding description:

SUM

Returns the largest number in a range of cells

AVERAGE

Returns the number in the middle of the set of given numbers

MIN

Returns the arithmetic mean of its arguments

Correct Answer:

Verified

SUM

AVERAGE

MIN

MAX

MEDIAN

(Matching)

4.9/5

(39)

Question 22

The IIf function requires ________ parameters.

(Multiple Choice)

4.8/5

(40)

Question 23

Match the following descriptions, sections, and categories to the following PowerPoint features:

Error, Warning, Tip

Compatibility Checker

Comments and Annotations, Custom XML Data, Off-Slide Content

Mark as Final

features not supported by PowerPoint 97-2003

Document Inspector

Correct Answer:

Verified

Error, Warning, Tip

Comments and Annotations, Custom XML Data, Off-Slide Content

features not supported by PowerPoint 97-2003

deactivates PowerPoint tools

encryption

(Matching)

4.8/5

(43)

Question 24

Match the following terms with the corresponding description:

RANK.EQ

Identifies the rank of a value but assigns an average rank when identical values exist.

QUARTILE.INC

Displays a value's rank as a percentile of the range of data in the dataset

RANK.AVG

Returns a value's rank as a percent excluding 0 and 1

Correct Answer:

Verified

RANK.EQ

QUARTILE.INC

RANK.AVG

PERCENTRANK.EXC

PERCENTRANK.INC

(Matching)

4.9/5

(30)

Question 25

Match the following terms to their descriptions:

Blogger

an online photo service

Pin to list button

allow you to change the title of the Web page

Flickr

could be converted to an image with a link

Correct Answer:

Verified

Blogger

Pin to list button

Flickr

embedded video

Single File Web page

(Matching)

4.7/5

(33)

Question 26

The ________ function is used to check whether a field contains no value.

(Multiple Choice)

4.8/5

(44)

Question 27

Match the following terms to their descriptions:

SkyDrive

helps businesses restrict access to sensitive information

IRM

makes a file usable even if the recipient does not have PowerPoint

Microsoft account

virtual, central storage location accessed via the Internet

Correct Answer:

Verified

SkyDrive

IRM

Microsoft account

Adobe Systems

Package Presentation for CD

(Matching)

4.9/5

(35)

Question 28

The DatePart function has ________ required parameters.

(Multiple Choice)

4.8/5

(38)

Question 29

Match the following terms to their meanings:

bookmark

assign colors to the elements on the Web page

hyperlink

an electronic marker for a specific location in a document

theme

add tabs and commands to groups

Correct Answer:

Verified

bookmark

hyperlink

theme

background

customize Ribbon

(Matching)

4.7/5

(27)

Question 30

Match the following terms to their meanings:

Web server

a process that transfer files between a server and a computer

FTP

type in a Web browser address box

index.html

a place where Web pages can be viewed over the Internet

Correct Answer:

Verified

Web server

FTP

index.html

URL

HTML

(Matching)

4.8/5

(39)

Question 31

Validation rules are entered in the ________ pane.

(Multiple Choice)

4.9/5

(26)

Question 32

Match the following descriptions or characteristics with the PowerPoint features:

collaboration usually found in a corporate environment

Slide Library

track changes and receive e-mails when slides are changed

SkyDrive

invite participants to watch a presentation

broadcast

Correct Answer:

Verified

collaboration usually found in a corporate environment

track changes and receive e-mails when slides are changed

invite participants to watch a presentation

edit a presentation in your browser

send a presentation as an attachment

(Matching)

4.8/5

(30)

Question 33

Match the following terms with the corresponding description.

ANOVA

Helps make predictions about the characteristics of a population

Analysis ToolPak

A measure of how two sets of data vary simultaneously

Covariance

A visual display of tabulated frequencies

Correct Answer:

Verified

ANOVA

Analysis ToolPak

Covariance

Inferential statistics

Histogram

(Matching)

4.9/5

(33)

Question 34

When most people in a database reside in New York,you should make NY the ________ value for the State field.

(Multiple Choice)

5.0/5

(32)

Question 35

When creating a parameter query,you are limited to a single parameter in the Criteria row for a given field.

(True/False)

4.9/5

(37)

Question 36

Match the following terms to their descriptions:

Media Group

to insert an online video onto a document

Present Online

a button that allows the reader to go back to the same place that the presenter is presenting

Follow Presenter

empty documents preformatted with frequently used styles

Correct Answer:

Verified

Media Group

Present Online

Follow Presenter

blank design template

Creative Commons license

(Matching)

4.9/5

(36)

Question 37

Match the following terms with their meanings:

linking

a file format created by Adobe Systems for document exchange independent of software application and operating system environment

portable document format (PDF)

a file format developed by Microsoft and designed to display a printed page onscreen identically on any computer platform

Rich Text Format (RTF)

a format that enables documents created in one software application to be opened with a different software application

Correct Answer:

Verified

linking

portable document format (PDF)

Rich Text Format (RTF)

Text file

XML Paper Specification (XPS)

(Matching)

4.8/5

(34)

Question 38

Match the following PowerPoint features with the dialog box where each is located:

warns of features lost when saved as earlier version

Document Inspector dialog box

check for hidden data

Compatibility Checker dialog box

choose the layout of handouts

Encrypt Document dialog box

Correct Answer:

Verified

warns of features lost when saved as earlier version

check for hidden data

choose the layout of handouts

add a password to a file

open a file with a password

(Matching)

4.8/5

(26)

Question 39

Match the following shortcuts to their action:

Ctrl+Click

display the Open dialog box of the Web browser

Ctrl+O

move from one open Web page to another

Alt+F

temporarily display the menu

Correct Answer:

Verified

Ctrl+Click

Ctrl+O

Alt+F

Alt+Tab

Ctrl+A

(Matching)

4.8/5

(40)

Question 40

Exam 8: Data Validation and Data Analysis: Hands On Exercise Videos

A(n)________ allows the user to select a field value from a list of options.

The IIf function requires ________ parameters.

The ________ function is used to check whether a field contains no value.

The DatePart function has ________ required parameters.

Validation rules are entered in the ________ pane.

When most people in a database reside in New York,you should make NY the ________ value for the State field.

When creating a parameter query,you are limited to a single parameter in the Criteria row for a given field.

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

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

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