Question 1

The ________ function can be used to perform a multiconditional average of data.

Accepted Answer

A) AVERAGE 
B) AVERAGEIF 
C) AVERAGEIFS 
D) MU 
A) AVERAGE 
B) AVERAGEIF 
C) AVERAGEIFS 
D) MU

Question 2

Which of the following functions is best suited to calculate the variance of a population including logical values and text?

Accepted Answer

A) VAR.P 
B) VARA 
C) VARPA 
D) VAR.S 
A) VAR.P 
B) VARA 
C) VARPA 
D) VAR.S

Question 3

When using the CORREL function a value of 1 would indicate:

Accepted Answer

A) a weak relationship. 
B) a mild relationship. 
C) a strong relationship. 
D) no relationship. 
A) a weak relationship. 
B) a mild relationship. 
C) a strong relationship. 
D) no relationship.

Question 4

ANOVA stands for ________.

Accepted Answer

analysis o

Question 5

The QUARTILE.EXC function excludes quartiles 0 and 4.

Accepted Answer

A) True 
 B)False

Question 6

The ________ is a predefined set of numerical values that are used to organize and count data using the FREQUENCY function.

Accepted Answer

The answer of The ________ is a predefined set of...

Question 7

The ________ function determines the strength of a relationship between two datasets.

Accepted Answer

The answer of The ________ function determines the strength of...

Question 8

What function is best suited to determine how often a set of numbers appears within a dataset?

Accepted Answer

A) SUMIF 
B) FREQUENCY 
C) SUMIFS 
D) AVERAGEIF 
A) SUMIF 
B) FREQUENCY 
C) SUMIFS 
D) AVERAGEIF

Question 9

The ________ tool within the Analysis ToolPak can place its output on a blank worksheet.

Accepted Answer

The answer of The ________ tool within the Analysis ToolPak...

Question 10

STDEV.S calculates the standard deviation of a sample.

Accepted Answer

A) True 
 B)False

Question 11

Which of the following percentiles is excluded when using the PERCENTILE.EXC function?

Accepted Answer

A) 0 
B) 25th 
C) 50th 
D) 75th 
A) 0 
B) 25th 
C) 50th 
D) 75th

Question 12

________ is a tool included in the Analysis ToolPak.

Accepted Answer

The answer of ________ is a tool included in the...

Question 13

Which of the following is not included in an ANOVA summary report?

Accepted Answer

A) SS 
B) df 
C) MS 
D) TF 
A) SS 
B) df 
C) MS 
D) TF

Question 14

When using text for criteria in conditional logic functions,the text must be surrounded by double quotation marks.

Accepted Answer

A) True 
 B)False

Question 15

Which of the following is included in an ANOVA summary report?

Accepted Answer

A) F crit 
B) STDEV 
C) Correlation 
D) Covariance 
A) F crit 
B) STDEV 
C) Correlation 
D) Covariance

Question 16

The Analysis ToolPak appears in the Data tab.

Accepted Answer

A) True 
 B)False

Question 17

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

Accepted Answer

The Answer of Returns a value's rank as a percent is...

Question 18

Which function is best suited to determine a student's test score percentile based on all class scores?

Accepted Answer

A) RANK.AVG 
B) PERCENTRANK.EXC 
C) AVERAGE 
D) AVERAGEIFS 
A) RANK.AVG 
B) PERCENTRANK.EXC 
C) AVERAGE 
D) AVERAGEIFS

Question 19

When using the QUARTILE.INC function a quartile of 3 represents which percentile?

Accepted Answer

A) 25th 
B) 50th 
C) 75th 
D) 100th 
A) 25th 
B) 50th 
C) 75th 
D) 100th

Question 20

Which of the following functions will exclude quartiles 0 and 4 in its calculations?

Accepted Answer

A) QUARTILE.INC 
B) QUARTILE.EXC 
C) QUARTILE 
D) PERCENTILE.EXC 
A) QUARTILE.INC 
B) QUARTILE.EXC 
C) QUARTILE 
D) PERCENTILE.EXC

Exam 29: Statistical Functions

The ________ function can be used to perform a multiconditional average of data.

Which of the following functions is best suited to calculate the variance of a population including logical values and text?

When using the CORREL function a value of 1 would indicate:

ANOVA stands for ________.

The QUARTILE.EXC function excludes quartiles 0 and 4.

The ________ is a predefined set of numerical values that are used to organize and count data using the FREQUENCY function.

The ________ function determines the strength of a relationship between two datasets.

What function is best suited to determine how often a set of numbers appears within a dataset?

The ________ tool within the Analysis ToolPak can place its output on a blank worksheet.

STDEV.S calculates the standard deviation of a sample.

Which of the following percentiles is excluded when using the PERCENTILE.EXC function?

________ is a tool included in the Analysis ToolPak.

Which of the following is not included in an ANOVA summary report?

When using text for criteria in conditional logic functions,the text must be surrounded by double quotation marks.

Which of the following is included in an ANOVA summary report?

The Analysis ToolPak appears in the Data tab.

Which function is best suited to determine a student's test score percentile based on all class scores?

When using the QUARTILE.INC function a quartile of 3 represents which percentile?

Which of the following functions will exclude quartiles 0 and 4 in its calculations?

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

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

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