Filters
Question type
Study Flashcards

Which of the following is a new statistical function in Excel 2013?


A) Skew.P
B) STDEV.P
C) VARPA
D) CORREL

Correct Answer

verifed

verified

Which of the following will determine the variance of a population?


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

Correct Answer

verifed

verified

The ________ function determines how often a set of numbers appears within a dataset.

Correct Answer

verifed

verified

Which of the following is not a statistical function?


A) AVERAGEIF
B) MAX
C) COUNTIFS
D) DSUM

Correct Answer

verifed

verified

The ________ is best suited to measure the strength of the relationship between credit score and salary.

Correct Answer

verifed

verified

Match the following terms with the corresponding description:

Premises
STDEV.S
VARPA
VARA
FREQUENCY
CORREL
Responses
Descriptive statistic function in Excel that determines the frequency distribution of a dataset.
Standard deviation of a sample
Helps determine the strength of a relationship between two variables
Variance of a sample including logical values and text
Variance of a population including logical values and text

Correct Answer

STDEV.S
VARPA
VARA
FREQUENCY
CORREL

Which of the following tools is not included in the Analysis ToolPak?


A) Anova: Single Factor
B) Correlation
C) Rank Average
D) Covariance

Correct Answer

verifed

verified

COVARIANCE.S determines how two sets of data from a sample vary simultaneously.

Correct Answer

verifed

verified

When using the QUARTILE.INC function which quartile would include the lowest value in the dataset?


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

Correct Answer

verifed

verified

Which feature of the Analysis ToolPak is best suited to determine if samples were taken from the same population?


A) Correlation
B) Histogram
C) Descriptive Statistics
D) ANOVA

Correct Answer

verifed

verified

A ________ is a visual display of tabulated frequencies.

Correct Answer

verifed

verified

The PERCENTRANK.INC function excludes 0 and 1.

Correct Answer

verifed

verified

STDEV.P should be used to calculate standard deviation when all data for a population is present.

Correct Answer

verifed

verified

The .EXC descriptor in PERCENTRANK.EXC stands for:


A) inclusive.
B) increment.
C) expert.
D) exclusive.

Correct Answer

verifed

verified

VARPA calculates the variance of a population including logical values and text.

Correct Answer

verifed

verified

If the number 0 is entered in the order argument of the RANK.AVG function the numbers will appear in ascending order.

Correct Answer

verifed

verified

The ________ function can be used to perform a single condition summary.

Correct Answer

verifed

verified

Which function is best suited to determine how the data set is spread around the mean?


A) COVARIANCE
B) CORREL
C) STDEV.P
D) VARA

Correct Answer

verifed

verified

VAR.P is included in the Analysis ToolPak.

Correct Answer

verifed

verified

When active,where does the Analysis ToolPak appear?


A) Data tab
B) Formulas tab
C) View tab
D) Insert tab

Correct Answer

verifed

verified

Showing 81 - 100 of 103

Related Exams

Exam 1

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

16 Questions

Exam 2

Desktop Publishing and Graphic Design: Hands On Exercise Videos

16 Questions

Exam 3

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

100 Questions

Exam 4

Infographics: Creating Text Charts, tables, and Graphs

100 Questions

Exam 5

Subtotals Pivot-tables and Pivot-charts

136 Questions

Exam 6

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

132 Questions

Exam 7

Infographics: Hands On Exercise Videos

51 Questions

Exam 8

Data Validation and Data Analysis: Hands On Exercise Videos

50 Questions

Exam 9

What If Analysis: Hands On Exercise Videos

31 Questions

Exam 10

Time Saving Tools: Hands On Exercise Videos

32 Questions

Exam 11

Time Saving Tools: Using Templates multiple Documents and Themes

110 Questions

Exam 12

Interactivity and Advanced Animation: Engaging the Audience

110 Questions

Exam 13

What If Analysis

103 Questions

Exam 14

Action and Specialized Queries: Moving Beyond the Select Query

100 Questions

Exam 15

Interactivity and Advanced Animation: Hands On Exercise Videos

15 Questions

Exam 16

Action and Specialized Queries: Hands On Exercise Videos

14 Questions

Exam 17

Specialized Functions: Hands On Exercise Videos

16 Questions

Exam 18

Document Automation: Hands On Exercise Videos

19 Questions

Exam 19

Document Automation: Forms, macros, and Security

100 Questions

Exam 20

Customization: Customizing Powerpoint and the Slide Show

100 Questions

Exam 21

Specialized Functions

103 Questions

Exam 22

Advanced Forms and Reports: Moving Beyond the Basics

100 Questions

Exam 23

Customization: Hands On Exercise Videos

19 Questions

Exam 24

Advanced Forms and Reports: Hands On Exercise Videos

12 Questions

Exam 25

Statistical Functions: Hands On Exercise Videos

17 Questions

Exam 26

Word and the Internet: Hands On Exercise Videos

17 Questions

Exam 27

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

100 Questions

Exam 28

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

100 Questions

Exam 30

Get Connected: Exchanging Data Between Access and Other Applications

100 Questions

Exam 31

Collaboration and Distribution: Hands On Exercise Videos

15 Questions

Exam 32

Get Connected: Hands On Exercise Videos

17 Questions

Exam 33

Multiple Sheet Workbook Management: Hands On Exercise Videos

16 Questions

Exam 34

Multiple Sheet Workbook Management

103 Questions

Exam 35

Fine Tuning the Database: Analyzing and Improving Database Performance

100 Questions

Exam 36

Fine Tuning the Database: Hands On Exercise Videos

17 Questions

Exam 37

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

13 Questions

Exam 38

Imports, web Queries, and XML

103 Questions

Exam 39

Using Macros and SQL in Access: Advanced Techniques

100 Questions

Exam 40

Using Macros and SQL in Access: Hands On Exercise Videos

16 Questions

Exam 41

Collaboration and Workbook Distribution: Hands On Exercise Videos

17 Questions

Exam 42

Collaboration and Workbook Distribution

103 Questions

Exam 43

Templates styles and Macros

103 Questions

Exam 44

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

18 Questions

Show Answer