Question 1

A list of values can contain ____.

Accepted Answer

A)  constants and cell references 
B)  a range of cells along a column or row 
C)  a two-dimensional block of cells 
D)  all of the above 
A)  constants and cell references 
B)  a range of cells along a column or row 
C)  a two-dimensional block of cells 
D)  all of the above

Question 2

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

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 3

The ____ of a normal distribution are the same value.

Accepted Answer

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

Question 4

The ____ wildcard specifies that a single character 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 5

The MODE.SNGL, MEDIAN, and STDEV.S functions work in a similar way, containing only one type of ____________________, which is a list of values.

Accepted Answer

The answer of The MODE.SNGL, MEDIAN, and STDEV.S functions work...

Question 6

The ____ symbol(s) specify/specifies that text enclosed in between these marks should be inserted as shown.

Accepted Answer

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

Question 7

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

Accepted Answer

A) True 
 B)False

Question 8

Use ____ to copy a format from one cell to another cell or group of contiguous cells.

Accepted Answer

A)  the Format Painter 
B)  the Format Copier 
C)  Paint 
D)  Special Format 
A)  the Format Painter 
B)  the Format Copier 
C)  Paint 
D)  Special Format

Question 9

The Paste Special dialog box offers the ____ option, which enables you to copy and paste a cell range that contains one or more blank cells where the blank cells are not pasted over any existing values in the range into which they are pasted.

Accepted Answer

A)  Copy Blanks 
B)  Blank Over 
C)  Comments 
D)  Skip Blanks 
A)  Copy Blanks 
B)  Blank Over 
C)  Comments 
D)  Skip Blanks

Question 10

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

Accepted Answer

A) True 
 B)False

Question 11

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

Accepted Answer

A)  Simulation 
B)  Play acting 
C)  Role playing 
D)  Regression 
A)  Simulation 
B)  Play acting 
C)  Role playing 
D)  Regression

Question 12

Identify the letter of the choice that best matches the function.
-25%

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 13

When using Goal Seek, you can specify the outcome you want and which input value you want to vary, and Excel ____.

Accepted Answer

A)  gives you a set of code to use in a database program 
B)  automatically calculates the solution 
C)  prompts you with a dialog box 
D)  none of the above 
A)  gives you a set of code to use in a database program 
B)  automatically calculates the solution 
C)  prompts you with a dialog box 
D)  none of the above

Question 14

The BIG function determines the nth largest value in a range. _________________________

Accepted Answer

A) True 
 B)False

Question 15

A simulation that is based on randomly generating specific values that have an equal chance of appearing, such as numbers on a set of dice, is often referred to as a ____ simulation.

Accepted Answer

A)  Las Vegas 
B)  Blackjack 
C)  Lucky 7 
D)  Monte Carlo 
A)  Las Vegas 
B)  Blackjack 
C)  Lucky 7 
D)  Monte Carlo

Question 16

Identify the letter of the choice that best matches the function.
-24%

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 17

Case 2-2
   
Nevia is using Goal Seek for the first time. She is determining what to put in each text box inside the Goal Seek dialog box shown in the above figure.
-Once Nevia clicks the correct tab, to open Goal Seek, she clicks the ____ button in the Data Tools group, then selects Goal Seek.

Accepted Answer

A)  What-If Analysis 
B)  Simulation 
C)  Goal Minder 
D)  Data Dialog 
A)  What-If Analysis 
B)  Simulation 
C)  Goal Minder 
D)  Data Dialog

Question 18

Relational operators are used to compare data.

Accepted Answer

A) True 
 B)False

Question 19

Case 2-1
   
Julia is learning how to use relational operators with the COUNTIF function. Her boss handed her the chart in the above figure and asked her to solve some everyday business problems.
-On a separate project, the head of Human Resources is looking for a list of people who do not have 100% attendance. In the database, the number 1 means 100% attendance; all other numbers indicate that some work was missed (for example, .75 is 75% attendance). The data is listed in column E of a worksheet. The correct COUNTIF formula would be ____.

Accepted Answer

A) =COUNTIF(E3:E13,"1") B) =COUNTIF(E3:E13,"=1") C) =COUNTIF(E3:E13,">=1") D) =COUNTIF(E3:E13,"<1") A) =COUNTIF(E3:E13,"1") B) =COUNTIF(E3:E13,"=1") C) =COUNTIF(E3:E13,">=1") D) =COUNTIF(E3:E13,"<1")

Question 20

Identify the letter of the choice that best matches the function.
-103,200

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)

A list of values can contain ____.

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

The ____ of a normal distribution are the same value.

The ____ wildcard specifies that a single character can be substituted.

The MODE.SNGL, MEDIAN, and STDEV.S functions work in a similar way, containing only one type of ____________________, which is a list of values.

The ____ symbol(s) specify/specifies that text enclosed in between these marks should be inserted as shown.

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

Use ____ to copy a format from one cell to another cell or group of contiguous cells.

The Paste Special dialog box offers the ____ option, which enables you to copy and paste a cell range that contains one or more blank cells where the blank cells are not pasted over any existing values in the range into which they are pasted.

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

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

Identify the letter of the choice that best matches the function. -25%

When using Goal Seek, you can specify the outcome you want and which input value you want to vary, and Excel ____.

The BIG function determines the nth largest value in a range. _________________________

A simulation that is based on randomly generating specific values that have an equal chance of appearing, such as numbers on a set of dice, is often referred to as a ____ simulation.

Identify the letter of the choice that best matches the function. -24%

Case 2-2 Nevia is using Goal Seek for the first time. She is determining what to put in each text box inside the Goal Seek dialog box shown in the above figure. -Once Nevia clicks the correct tab, to open Goal Seek, she clicks the ____ button in the Data Tools group, then selects Goal Seek.

Relational operators are used to compare data.

Identify the letter of the choice that best matches the function. -103,200

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

A list of values can contain ____.

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

The ____ of a normal distribution are the same value.

The ____ wildcard specifies that a single character can be substituted.

The MODE.SNGL, MEDIAN, and STDEV.S functions work in a similar way, containing only one type of ____________________, which is a list of values.

The ____ symbol(s) specify/specifies that text enclosed in between these marks should be inserted as shown.

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

Use ____ to copy a format from one cell to another cell or group of contiguous cells.

The Paste Special dialog box offers the ____ option, which enables you to copy and paste a cell range that contains one or more blank cells where the blank cells are not pasted over any existing values in the range into which they are pasted.

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

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

Identify the letter of the choice that best matches the function. -25%

When using Goal Seek, you can specify the outcome you want and which input value you want to vary, and Excel ____.

The BIG function determines the nth largest value in a range. _________________________

A simulation that is based on randomly generating specific values that have an equal chance of appearing, such as numbers on a set of dice, is often referred to as a ____ simulation.

Identify the letter of the choice that best matches the function. -24%

Case 2-2 Nevia is using Goal Seek for the first time. She is determining what to put in each text box inside the Goal Seek dialog box shown in the above figure. -Once Nevia clicks the correct tab, to open Goal Seek, she clicks the ____ button in the Data Tools group, then selects Goal Seek.

Relational operators are used to compare data.

Identify the letter of the choice that best matches the function. -103,200

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