Question 1

When using an array of data with the FREQUENCY function,the following keystroke is required.

Accepted Answer

A) Ctrl+Alt+Delete 
B) Ctrl+Shift+Delete 
C) Ctrl+Shift+Enter 
D) Ctrl+Enter 
A) Ctrl+Alt+Delete 
B) Ctrl+Shift+Delete 
C) Ctrl+Shift+Enter 
D) Ctrl+Enter

Question 2

Which of the following is not a function for measuring central tendency?

Accepted Answer

A) CORREL 
B) STDEV.P 
C) VAR.P 
D) SUMIFS 
A) CORREL 
B) STDEV.P 
C) VAR.P 
D) SUMIFS

Question 3

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

Accepted Answer

The Answer of Lowest value in the dataset.Identical to using is...

Question 4

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

Accepted Answer

The Answer of A measure of a dataset's dispersion,such as is...

Question 5

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 6

Match between columns
                        Premises: SUM
MAX
MEDIAN
AVERAGE
MIN

Accepted Answer

The Answer of Returns the arithmetic mean of its arguments is...

Question 7

The Analysis ToolPak appears in the Data tab.

Accepted Answer

A) True 
 B)False

Question 8

To complete a FREQUENCY function using an array the keystroke Ctrl+Enter must be used.

Accepted Answer

A) True 
 B)False

Question 9

This function is best suited to determine ranks within a data set based on percentile.

Accepted Answer

A) RANK.EQ 
B) PERCENTRANK.INC 
C) RANK.AVG 
D) PERCENTILE 
A) RANK.EQ 
B) PERCENTRANK.INC 
C) RANK.AVG 
D) PERCENTILE

Question 10

Histograms can be created on a separate worksheet when using the Analysis ToolPak.

Accepted Answer

A) True 
 B)False

Question 11

What are the benefits of using the Analysis ToolPakover traditional statistical functions in Excel?

Accepted Answer

Many of the calculations that are incorp

Question 12

The ________ function is best suited to return the rank as a percentage of students within a high school.

Accepted Answer

The answer of The ________ function is best suited to...

Question 13

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

Question 14

When using the CORREL function,a value of .00007 would indicate:

Accepted Answer

A) a weak relationship. 
B) a strong relationship. 
C) an inverse relationship. 
D) no relationship. 
A) a weak relationship. 
B) a strong relationship. 
C) an inverse relationship. 
D) no relationship.

Question 15

How many condition arguments can be defined with the SUMIF function?

Accepted Answer

A) 1 
B) 2 
C) 3 
D) unlimited 
A) 1 
B) 2 
C) 3 
D) unlimited

Question 16

By default,the FREQUENCY function includes numerical outliers.

Accepted Answer

A) True 
 B)False

Question 17

The SUMIF function could be used to add the total salaries of employees over the age of 25 in a dataset.

Accepted Answer

A) True 
 B)False

Question 18

Which function is best suited to calculate quartiles including quartiles 0 and 4?

Accepted Answer

A) QUARTILE.EXC 
B) QUARTILE.INC 
C) QUART 
D) RANK.AVG 
A) QUARTILE.EXC 
B) QUARTILE.INC 
C) QUART 
D) RANK.AVG

Question 19

The Analysis ToolPak can be activated in:

Accepted Answer

A) Formula tab. 
B) Excel Options. 
C) Review tab. 
D) Developer tab. 
A) Formula tab. 
B) Excel Options. 
C) Review tab. 
D) Developer tab.

Question 20

The PERCENTILE.EXC function is the best function to calculate the 25th percentile within a range of values.

Accepted Answer

A) True 
 B)False

Exam 25: Excel: Statistical Functions

When using an array of data with the FREQUENCY function,the following keystroke is required.

Which of the following is not a function for measuring central tendency?

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

The Analysis ToolPak appears in the Data tab.

To complete a FREQUENCY function using an array the keystroke Ctrl+Enter must be used.

This function is best suited to determine ranks within a data set based on percentile.

Histograms can be created on a separate worksheet when using the Analysis ToolPak.

What are the benefits of using the Analysis ToolPakover traditional statistical functions in Excel?

The ________ function is best suited to return the rank as a percentage of students within a high school.

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

When using the CORREL function,a value of .00007 would indicate:

How many condition arguments can be defined with the SUMIF function?

By default,the FREQUENCY function includes numerical outliers.

The SUMIF function could be used to add the total salaries of employees over the age of 25 in a dataset.

Which function is best suited to calculate quartiles including quartiles 0 and 4?

The Analysis ToolPak can be activated in:

The PERCENTILE.EXC function is the best function to calculate the 25th percentile within a range of values.

Office Fundamentals and File Management

Word: Document Presentation: Editing and Formatting

Word: Document Productivity: Working With Tables and Mail Merge

Word: Collaboration and Research: Communicating and Producing Professional Papers

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

Word: Time Saving Tools: Using Templates, multiple Documents, and Themes

Word: Document Automation: Forms,macros,and Security

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

Power: Introduction to Powerpoint: Creating a Basic Presentation

Power: Presentation Development: Planning and Preparing a Presentation

Power: Presentation Design: Illustrations and Infographics

Power: Powerpoint Rich Media Tools: Enhancing With Multimedia

Power: Infographics: Creating Text Charts, tables, and Graphs

Power: Interactivity and Advanced Animation: Engaging the Audience

Power: Customization: Customizing Powerpoint and the Slide Show

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

Excel: Introduction to Excel: What Is a Spreadsheet

Excel: Formulas and Functions: Performing Quantitative Analysis

Excel : Charts: Depicting Data Visually

Excel: Datasets and Tables: Managing Large Volumes of Data

Excel: Subtotals, Pivot-tables, and Pivot-charts

Excel : What-If Analysis

Excel: Specialized Functions

Excel : Multiple-Sheet Workbook Management

Excel: Imports, web Queries, and Xml

Excel : Collaboration and Workbook Distribution

Excel: Templates, styles, and Macros

Access : Introduction to Access: Finding Your Way Through an Access Database

Access: Tables and Queries in Relational Databases: Designing Databases and Extracting Data

Access: Customize,analyze,and Summarize Query Data: Creating and Using Queries to Make Decisions

Access: Creating and Using Professional Forms and Reports: Moving Beyond Tables and Queries

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

Access : Action and Specialized Queries: Moving Beyond the Select Query

Access: Advanced Forms and Reports: Moving Beyond the Basics

Access: Get Connected: Exchanging Data Between Access and Other Applications

Access: Fine-Tuning the Database: Analyzing and Improving Database Performance

Filters