Question 1

The syntax of the AVERAGEIF function ____ is very similar to the syntax of the SUMIF function.

Accepted Answer

A)  (range,criteria,average_range) 
B)  (criteria,average,range) 
C)  (ref,range,criteria) 
D)  (array,average_range,ref) 
A)  (range,criteria,average_range) 
B)  (criteria,average,range) 
C)  (ref,range,criteria) 
D)  (array,average_range,ref)

Question 2

When working with the RAND and RANDBETWEEN functions, every time you enter another value in a cell anywhere on the worksheet, the random values ____.

Accepted Answer

A)  automatically change 
B)  prompt you with a dialog box 
C)  prompt you with an error message 
D)  stay the same 
A)  automatically change 
B)  prompt you with a dialog box 
C)  prompt you with an error message 
D)  stay the same

Question 3

If you wrote the formula =ODD(1.23), the resulting value would be ____.

Accepted Answer

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

Question 4

The ____ symbol indicates to skip the width of the next character. It's frequently used with ( ) to make sure positive numbers align with negative numbers displayed with ( ).

Accepted Answer

A)  _ (underscore) 
B)  - (dash) 
C)  @ 
D)  + 
A)  _ (underscore) 
B)  - (dash) 
C)  @ 
D)  +

Question 5

With the LARGE function, the argument called analysis describes the range of cells being evaluated.

Accepted Answer

A) True 
 B)False

Question 6

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

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 7

The critical argument is essentially a test that the data must meet in order for it to be counted in the grouping. _________________________

Accepted Answer

A) True 
 B)False

Question 8

If you select the Paste option button called Values, you will paste only the values; the formulas and any formatting from the original cell(s) are not pasted.

Accepted Answer

A) True 
 B)False

Question 9

The ____ symbol inserts a percentage sign and automatically multiplies the value inserted by 100 for display.

Accepted Answer

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

Question 10

Up to four different format codes can be applied to a cell: one for positive numbers, one for negative numbers, one for zero values, and one for ____________________.

Accepted Answer

The answer of Up to four different format codes can...

Question 11

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

Accepted Answer

The answer of ____________________ is a measure of how widely...

Question 12

The SMALL function determines the nth smallest value in a range.

Accepted Answer

A) True 
 B)False

Question 13

When the # symbol acts as a placeholder for a digit, it is considered to be a(n) ____________________ code.

Accepted Answer

The answer of When the # symbol acts as a...

Question 14

Identify the letter of the choice that best matches the function.
-21

Accepted Answer

A) =ROUND(25.449,0) 
B) =ROUND(SUM(10.33,10.44),0) 
C) =ROUND(25.33%,2) 
D) =INT(-4.3) 
E) =ROUND(103234,-2)
F)=ROUND(23.75%,2)
G)=ROUNDDOWN(9.99,0)
H)=EVEN(2.23) 
A) =ROUND(25.449,0) 
B) =ROUND(SUM(10.33,10.44),0) 
C) =ROUND(25.33%,2) 
D) =INT(-4.3) 
E) =ROUND(103234,-2)
F)=ROUND(23.75%,2)
G)=ROUNDDOWN(9.99,0)
H)=EVEN(2.23)

Question 15

Simulation is an analytical method that creates artificially generated data to imitate real data.

Accepted Answer

A) True 
 B)False

Question 16

The ____________________ Paste option button pastes a connection to the original cell, including the applied formatting.

Accepted Answer

Paste Link

Question 17

The Step button in Goal Seek ____.

Accepted Answer

A)  allows you to step through each iteration one step at a time 
B)  returns the data in separate spreadsheets 
C)  walks you through the steps similar to a wizard 
D)  none of the above 
A)  allows you to step through each iteration one step at a time 
B)  returns the data in separate spreadsheets 
C)  walks you through the steps similar to a wizard 
D)  none of the above

Question 18

The Format Painter can be used to copy a format into multiple noncontiguous cells.

Accepted Answer

A) True 
 B)False

Question 19

The technique used to fix certain rows while you scroll to other rows in a worksheet is called freezing panes.

Accepted Answer

A) True 
 B)False

Question 20

To calculate a(n) ____ between two data sets, you subtract the old value from the new value and then divide the difference by the old value.

Accepted Answer

A)  average difference 
B)  standard deviation difference 
C)  percent difference 
D)  none of the above 
A)  average difference 
B)  standard deviation difference 
C)  percent difference 
D)  none of the above

The syntax of the AVERAGEIF function ____ is very similar to the syntax of the SUMIF function.

When working with the RAND and RANDBETWEEN functions, every time you enter another value in a cell anywhere on the worksheet, the random values ____.

If you wrote the formula =ODD(1.23), the resulting value would be ____.

The ____ symbol indicates to skip the width of the next character. It's frequently used with ( ) to make sure positive numbers align with negative numbers displayed with ( ).

With the LARGE function, the argument called analysis describes the range of cells being evaluated.

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

The critical argument is essentially a test that the data must meet in order for it to be counted in the grouping. _________________________

If you select the Paste option button called Values, you will paste only the values; the formulas and any formatting from the original cell(s) are not pasted.

The ____ symbol inserts a percentage sign and automatically multiplies the value inserted by 100 for display.

Up to four different format codes can be applied to a cell: one for positive numbers, one for negative numbers, one for zero values, and one for ____________________.

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

The SMALL function determines the nth smallest value in a range.

When the # symbol acts as a placeholder for a digit, it is considered to be a(n) ____________________ code.

Identify the letter of the choice that best matches the function. -21

Simulation is an analytical method that creates artificially generated data to imitate real data.

The ____________________ Paste option button pastes a connection to the original cell, including the applied formatting.

The Step button in Goal Seek ____.

The Format Painter can be used to copy a format into multiple noncontiguous cells.

The technique used to fix certain rows while you scroll to other rows in a worksheet is called freezing panes.

To calculate a(n) ____ between two data sets, you subtract the old value from the new value and then divide the difference by the old value.

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

The syntax of the AVERAGEIF function ____ is very similar to the syntax of the SUMIF function.

When working with the RAND and RANDBETWEEN functions, every time you enter another value in a cell anywhere on the worksheet, the random values ____.

If you wrote the formula =ODD(1.23), the resulting value would be ____.

The ____ symbol indicates to skip the width of the next character. It's frequently used with ( ) to make sure positive numbers align with negative numbers displayed with ( ).

With the LARGE function, the argument called analysis describes the range of cells being evaluated.

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

The critical argument is essentially a test that the data must meet in order for it to be counted in the grouping. _________________________

If you select the Paste option button called Values, you will paste only the values; the formulas and any formatting from the original cell(s) are not pasted.

The ____ symbol inserts a percentage sign and automatically multiplies the value inserted by 100 for display.

Up to four different format codes can be applied to a cell: one for positive numbers, one for negative numbers, one for zero values, and one for ____________________.

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

The SMALL function determines the nth smallest value in a range.

When the # symbol acts as a placeholder for a digit, it is considered to be a(n) ____________________ code.

Identify the letter of the choice that best matches the function. -21

Simulation is an analytical method that creates artificially generated data to imitate real data.

The ____________________ Paste option button pastes a connection to the original cell, including the applied formatting.

The Step button in Goal Seek ____.

The Format Painter can be used to copy a format into multiple noncontiguous cells.

The technique used to fix certain rows while you scroll to other rows in a worksheet is called freezing panes.

To calculate a(n) ____ between two data sets, you subtract the old value from the new value and then divide the difference by the old value.

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