Question 1

In the LARGE function, the second argument, k, is the desired ranking, where 1 is ____.

Accepted Answer

A)  the largest value 
B)  the smallest value 
C)  required 
D)  not allowed 
A)  the largest value 
B)  the smallest value 
C)  required 
D)  not allowed

Question 2

The ____ wildcard specifies that any number of characters can be substituted.

Accepted Answer

A)  asterisk (*) 
B)  question mark (?) 
C)  forward slash (/) 
D)  backward slash (\) 
A)  asterisk (*) 
B)  question mark (?) 
C)  forward slash (/) 
D)  backward slash (\)

Question 3

MATCHING
   
Using the above figure, identify the letter of the choice that best matches the figure.
-#4

Accepted Answer

A) Counts all Inspector IDs that contain the text value "1" anywhere in the value (A313, C321, B313, and so on) 
B) Counts all Inspector IDs that end with the text value "3" 
C) Counts all Inspector IDs that have the value "3" in the third-to-last position in the text value, regardless of the number of preceding characters 
D) Counts all Inspector IDs with a single character followed by the characters "313"; notice that cell H7 is not counted because it contains two characters preceding the characters "313" 
A) Counts all Inspector IDs that contain the text value "1" anywhere in the value (A313, C321, B313, and so on) 
B) Counts all Inspector IDs that end with the text value "3" 
C) Counts all Inspector IDs that have the value "3" in the third-to-last position in the text value, regardless of the number of preceding characters 
D) Counts all Inspector IDs with a single character followed by the characters "313"; notice that cell H7 is not counted because it contains two characters preceding the characters "313"

Question 4

The ____________________ Paste option button pastes the formulas and formatting from the original cell(s), but not the format of the cell borders.

Accepted Answer

The answer of The ____________________ Paste option button pastes the...

Question 5

List and explain briefly mean, median, mode, and standard deviation.

Accepted Answer

•Mean is the arithmetic average of a set

Question 6

The Paste option called ____ pastes the contents of the copied cells(s) as a picture.

Accepted Answer

A)  Picture 
B)  As Picture 
C)  Paste Picture 
D)  Paste Graphic 
A)  Picture 
B)  As Picture 
C)  Paste Picture 
D)  Paste Graphic

Question 7

The statistical function MODE returns the most frequently occurring value in a range of data.

Accepted Answer

A) True 
 B)False

Question 8

The ____ symbol acts as a digit placeholder that does not display insignificant digits, but does hold a place so that decimal points will align.

Accepted Answer

A)  (#) 
B)  (0) 
C)  (?) 
D)  (%) 
A)  (#) 
B)  (0) 
C)  (?) 
D)  (%)

Question 9

Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision (____ digits) to whatever format is displayed in that cell, including the number of decimal places.

Accepted Answer

A)  5 
B)  9 
C)  15 
D)  21 
A)  5 
B)  9 
C)  15 
D)  21

Question 10

The ______________________________ Paste option button pastes values from the original cell(s) and formatting.

Accepted Answer

Values & Source Formatting
Val

Question 11

Automatic calculation can be turned off from the ribbon or from the ____ dialog box accessed via the FILE tab.

Accepted Answer

A)  Excel Options 
B)  Worksheet Options 
C)  Automatic Options 
D)  Ribbon Options 
A)  Excel Options 
B)  Worksheet Options 
C)  Automatic Options 
D)  Ribbon Options

Question 12

The syntax of the COUNTIF function is ____.

Accepted Answer

A)  =COUNTIF(range,array) 
B)  =COUNTIF(ref,range) 
C)  =COUNTIF(array,k) 
D)  =COUNTIF(range,criteria) 
A)  =COUNTIF(range,array) 
B)  =COUNTIF(ref,range) 
C)  =COUNTIF(array,k) 
D)  =COUNTIF(range,criteria)

Question 13

The ____ function allows you to sort a list and then count the number of entries either above or below the value in question.

Accepted Answer

A)  RANK.EQ 
B)  POSITION 
C)  FIND 
D)  COUNT 
A)  RANK.EQ 
B)  POSITION 
C)  FIND 
D)  COUNT

Question 14

In the Goal Seek dialog box, you use the Set cell box to specify the cell ____.

Accepted Answer

A)  in which the output value will appear 
B)  that contains the formula to use 
C)  with the output label 
D)  none of the above 
A)  in which the output value will appear 
B)  that contains the formula to use 
C)  with the output label 
D)  none of the above

Question 15

The ____ symbol(s) indicate(s) the location where text should be inserted in cells formatted with a custom format.

Accepted Answer

A)  , 
B)  * 
C)  "" 
D)  @ 
A)  , 
B)  * 
C)  "" 
D)  @

Question 16

Excel uses the Goal Find tool to try various input values in order to calculate the required input to achieve your desired outcome. _________________________

Accepted Answer

A) True 
 B)False

Question 17

The ____ symbol acts as a digit placeholder that displays both significant and insignificant zeros.

Accepted Answer

A)  (#) 
B)  (0) 
C)  (?) 
D)  (%) 
A)  (#) 
B)  (0) 
C)  (?) 
D)  (%)

Question 18

When you ____________________ a function, you include that function inside another formula or function as one of its arguments.

Accepted Answer

The answer of When you ____________________ a function, you include...

Question 19

The ____ is a measure of how widely the data values are dispersed from the arithmetic mean.

Accepted Answer

A)  mean 
B)  median 
C)  mode 
D)  standard deviation 
A)  mean 
B)  median 
C)  mode 
D)  standard deviation

Question 20

The Format Cells dialog box, which can be opened from the ____ group Dialog Box Launcher on the HOME tab, provides many options for changing the display of cell values.

Accepted Answer

A)  Cells 
B)  Data 
C)  Number 
D)  Data. 
A)  Cells 
B)  Data 
C)  Number 
D)  Data.

In the LARGE function, the second argument, k, is the desired ranking, where 1 is ____.

The ____ wildcard specifies that any number of characters can be substituted.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#4

The ____________________ Paste option button pastes the formulas and formatting from the original cell(s), but not the format of the cell borders.

List and explain briefly mean, median, mode, and standard deviation.

The Paste option called ____ pastes the contents of the copied cells(s) as a picture.

The statistical function MODE returns the most frequently occurring value in a range of data.

The ____ symbol acts as a digit placeholder that does not display insignificant digits, but does hold a place so that decimal points will align.

Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision (____ digits) to whatever format is displayed in that cell, including the number of decimal places.

The ______________________________ Paste option button pastes values from the original cell(s) and formatting.

Automatic calculation can be turned off from the ribbon or from the ____ dialog box accessed via the FILE tab.

The syntax of the COUNTIF function is ____.

The ____ function allows you to sort a list and then count the number of entries either above or below the value in question.

In the Goal Seek dialog box, you use the Set cell box to specify the cell ____.

The ____ symbol(s) indicate(s) the location where text should be inserted in cells formatted with a custom format.

Excel uses the Goal Find tool to try various input values in order to calculate the required input to achieve your desired outcome. _________________________

The ____ symbol acts as a digit placeholder that displays both significant and insignificant zeros.

When you ____________________ a function, you include that function inside another formula or function as one of its arguments.

The ____ is a measure of how widely the data values are dispersed from the arithmetic mean.

The Format Cells dialog box, which can be opened from the ____ group Dialog Box Launcher on the HOME tab, provides many options for changing the display of cell values.

Applying Fundamental Excel Skills and Tools in Problem Solving

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters

Exam 2: Solving Problems with Statistical Analysis Tools

In the LARGE function, the second argument, k, is the desired ranking, where 1 is ____.

The ____ wildcard specifies that any number of characters can be substituted.

MATCHING Using the above figure, identify the letter of the choice that best matches the figure. -#4

The ____________________ Paste option button pastes the formulas and formatting from the original cell(s), but not the format of the cell borders.

List and explain briefly mean, median, mode, and standard deviation.

The Paste option called ____ pastes the contents of the copied cells(s) as a picture.

The statistical function MODE returns the most frequently occurring value in a range of data.

The ____ symbol acts as a digit placeholder that does not display insignificant digits, but does hold a place so that decimal points will align.

Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision (____ digits) to whatever format is displayed in that cell, including the number of decimal places.

The ______________________________ Paste option button pastes values from the original cell(s) and formatting.

Automatic calculation can be turned off from the ribbon or from the ____ dialog box accessed via the FILE tab.

The syntax of the COUNTIF function is ____.

The ____ function allows you to sort a list and then count the number of entries either above or below the value in question.

In the Goal Seek dialog box, you use the Set cell box to specify the cell ____.

The ____ symbol(s) indicate(s) the location where text should be inserted in cells formatted with a custom format.

Excel uses the Goal Find tool to try various input values in order to calculate the required input to achieve your desired outcome. _________________________

The ____ symbol acts as a digit placeholder that displays both significant and insignificant zeros.

When you ____________________ a function, you include that function inside another formula or function as one of its arguments.

The ____ is a measure of how widely the data values are dispersed from the arithmetic mean.

The Format Cells dialog box, which can be opened from the ____ group Dialog Box Launcher on the HOME tab, provides many options for changing the display of cell values.

Applying Fundamental Excel Skills and Tools in Problem Solving

Determining Effective Data Display with Charts

Applying Logic in Decision Making

Retrieving Data for Computation, Analysis, and Reference

Evaluating the Financial Impact of Loans and Investments

Organizing Data for Effective Analysis

Using Data Tables and Excel Scenarios for What If Analysis

Enhancing Decision Making with Solver

Troubleshooting Workbooks and Automating Excel Applications

Filters