Match between columns Premises: Present Online SharePoint workspace SharePoint site Windows Live SharePoint library

The Answer of store and manage files and online service is...

Match between columns Premises: hyperlink Internet Web page WWW HTML

The Answer of describe how the Web document is to is...

Match between columns Premises: STDEVA STDEVPA STDEV.P VAR.P VAR.S

The Answer of Variance of a population and Variance of is...

Match between columns Premises: SS df MS F P-value

The Answer of Probability of population being similar to the is...

Match between columns Premises: Binom.dist.range Gamma Gauss PHI Skew.P

The Answer of Returns gamma value and Returns the skewness is...

Match between columns Premises: Population Sample Standard deviation Variance STDEV.P

The Answer of Calculates the standard deviation of a population is...

Match between columns Premises: Quartile 0 Quartile 1 Quartile 2 Quartile 3 Quartile 4

The Answer of Highest value within the dataset. Identical to is...

Match between columns Premises: SUMIF AVERAGEIF COUNTIF SUMIFS AVERAGEIFS

The Answer of Counts the number of cells within a is...

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

Match the following clues with the correct PowerPoint feature:

Present Online

store and manage files

SharePoint workspace

online service to collaborate

SharePoint site

generally found in a corporate environment

Correct Answer:

Verified

Present Online

store and manage files

SharePoint workspace

online service to collaborate

SharePoint site

generally found in a corporate environment

Windows Live

copy for offline use

SharePoint library

transmit over the Internet

Free

(Matching)

4.9/5

(36)

Question 1

Correct Answer:

Verified

Match the following terms to their meanings:

hyperlink

describe how the Web document is to appear when viewed in a Web browser

Internet

marker that points to a location, Web page, or file

Web page

consist of those computers that store Web pages

Correct Answer:

Verified

hyperlink

describe how the Web document is to appear when viewed in a Web browser

Internet

marker that points to a location, Web page, or file

Web page

consist of those computers that store Web pages

WWW

document that may be self-contained and might provide all the information about a topic

HTML

connect computers anywhere in the world

Free

(Matching)

4.8/5

(39)

Question 2

Correct Answer:

Verified

If a validation rule is not met,you CANNOT continue until the data value meets the rule.

Free

(True/False)

4.8/5

(32)

Question 3

Correct Answer:

Verified

True

When a field is required,it must have a default value.

(True/False)

4.9/5

(33)

Question 4

The table that contains the values for a lookup field CANNOT be modified.

(True/False)

4.7/5

(39)

Question 5

Match the following terms to their meanings:

SkyDrive

Microsoft Office products available online

Office 365

to share data online

cloud integration technology

a button in Online Presentation

Correct Answer:

Verified

SkyDrive

Office 365

cloud integration technology

WordPress

Send Invitations

(Matching)

4.9/5

(29)

Question 6

Match the following terms with the corresponding description:

STDEVA

Variance of a population

STDEVPA

Variance of a sample

STDEV.P

Standard deviation of a population including logical values and text

Correct Answer:

Verified

STDEVA

STDEVPA

STDEV.P

VAR.P

VAR.S

(Matching)

4.8/5

(33)

Question 7

Match the following terms with the corresponding description:

SS

Probability of population being similar to the sample

df

Equal to the mean square between/mean square within

MS

The number of data points in the sample -1, (N -1)

Correct Answer:

Verified

SS

df

MS

F

P-value

(Matching)

4.8/5

(27)

Question 8

Match the following terms to their meanings:

Web Page, file type

reduce file size and Word editing options

Web Page, Filtered file type

contains Word and HTML tags

Single File Web Page file type

can edit Web page using Word tools

Correct Answer:

Verified

Web Page, file type

Web Page, Filtered file type

Single File Web Page file type

Web page

Web Layout view

(Matching)

4.9/5

(36)

Question 9

You would use the ________ function to calculate the current date.

(Multiple Choice)

4.8/5

(37)

Question 10

(_)_- is an example of a(n)____.

(Multiple Choice)

4.9/5

(35)

Question 11

Match the following PowerPoint features with the pane or panel where each can be found:

added or removed slides when presentations compared

Document Properties panel

change the author name of a file

Accessibility Checker pane

shows Errors, Warnings, and Tips for a file

Revisions pane

Correct Answer:

Verified

added or removed slides when presentations compared

change the author name of a file

shows Errors, Warnings, and Tips for a file

add files from another presentation

add Final status to a file

(Matching)

4.8/5

(41)

Question 12

The Validation Text property is used to display a message when the corresponding validation rule is not met.

(True/False)

4.9/5

(33)

Question 13

Match the following terms with the corresponding description.

Binom.dist.range

Returns gamma value

Gamma

Returns the skewness of a distribution based on a population

Gauss

Returns the value of the density function for a standard normal distribution

Correct Answer:

Verified

Binom.dist.range

Gamma

Gauss

PHI

Skew.P

(Matching)

4.9/5

(41)

Question 14

Match the following actions to their corresponding dialog boxes or features:

export customized tabs

Word Options dialog box

author Web pages

Fill Effects command

link an e-mail address

Microsoft Expressions

Correct Answer:

Verified

export customized tabs

author Web pages

link an e-mail address

remove a hyperlink

apply a gradient or texture

(Matching)

4.8/5

(27)

Question 15

Match the following terms with the corresponding description:

Population

Calculates the standard deviation of a population

Sample

The measure of how far the data sample is spread around the mean, in the original units of measure

Standard deviation

A data set that contains all the data you would like to evaluate

Correct Answer:

Verified

Population

Sample

Standard deviation

Variance

STDEV.P

(Matching)

4.9/5

(32)

Question 16

Match the following terms with the corresponding description:

Quartile 0

Highest value within the dataset. Identical to using the MAX function. Allowed in QUART ILE.INC only

Quartile 1

Identifies the value at the 75th percentile

Quartile 2

Identifies the value at the 50th percentile

Correct Answer:

Verified

Quartile 0

Quartile 1

Quartile 2

Quartile 3

Quartile 4

(Matching)

4.8/5

(42)

Question 17

Match the following clues with each correct PowerPoint feature:

icon on the status bar

IRM

should be the very last step you perform

protect with a password

an expiration date

encryption

Correct Answer:

Verified

icon on the status bar

should be the very last step you perform

an expiration date

pay close attention to case-sensitive entry

unreadable scrambled text

(Matching)

5.0/5

(43)

Question 18

When data is entered,a(n)________ is used to have a consistent format.

(Multiple Choice)

4.8/5

(41)

Question 19

Match the following terms with the corresponding description:

SUMIF

Counts the number of cells within a range that meet the given condition.

AVERAGEIF

Adds the cells specified by a given set of conditions or criteria

COUNTIF

Finds the mean for the cells specified by a given set of conditions or criteria.

Correct Answer:

Verified

SUMIF

AVERAGEIF

COUNTIF

SUMIFS

AVERAGEIFS

(Matching)

4.8/5

(39)

Question 20

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

If a validation rule is not met,you CANNOT continue until the data value meets the rule.

When a field is required,it must have a default value.

The table that contains the values for a lookup field CANNOT be modified.

You would use the ________ function to calculate the current date.

(___)___-____ is an example of a(n)________.

The Validation Text property is used to display a message when the corresponding validation rule is not met.

When data is entered,a(n)________ is used to have a consistent format.

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

(_)_- is an example of a(n)____.