Question 1

Goal Seek allows you to vary ____ input(s).

Accepted Answer

A)  a single 
B)  up to 3 
C)  up to 5 
D)  up to 10 
A)  a single 
B)  up to 3 
C)  up to 5 
D)  up to 10

Question 2

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

Accepted Answer

•Mean is the arithmetic average of a set

Question 3

The ROUND argument num_digits is the specified number of ____.

Accepted Answer

A)  decimal places 
B)  digits 
C)  integers 
D)  operators 
A)  decimal places 
B)  digits 
C)  integers 
D)  operators

Question 4

Performing a ____ analysis means, simply, to determine the outcome of changing one or more input values and to evaluate the recalculated results.

Accepted Answer

A)  maybe 
B)  what-if 
C)  factor 
D)  research 
A)  maybe 
B)  what-if 
C)  factor 
D)  research

Question 5

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 6

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

Accepted Answer

A) True 
 B)False

Question 7

Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision, which is six digits, to whatever format is displayed in that cell.

Accepted Answer

A) True 
 B)False

Question 8

The formula =____________________(3.432,1) rounds the value 3.432 up to the next highest tenth, or 3.5.

Accepted Answer

ROUNDUP
Ro

Question 9

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

Accepted Answer

Values & Source Formatting
Val

Question 10

Result Seek uses an iterative approach to finding the right input that achieves the desired result, or goal, in the dependent cell.

Accepted Answer

A) True 
 B)False

Goal Seek allows you to vary ____ input(s).

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

The ROUND argument num_digits is the specified number of ____.

Performing a ____ analysis means, simply, to determine the outcome of changing one or more input values and to evaluate the recalculated results.

The syntax of the COUNTIF function is ____.

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

Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision, which is six digits, to whatever format is displayed in that cell.

The formula =____________________(3.432,1) rounds the value 3.432 up to the next highest tenth, or 3.5.

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

Result Seek uses an iterative approach to finding the right input that achieves the desired result, or goal, in the dependent cell.

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

Goal Seek allows you to vary ____ input(s).

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

The ROUND argument num_digits is the specified number of ____.

Performing a ____ analysis means, simply, to determine the outcome of changing one or more input values and to evaluate the recalculated results.

The syntax of the COUNTIF function is ____.

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

Selecting the Set precision as displayed workbook option permanently changes the values in all workbook cells from full precision, which is six digits, to whatever format is displayed in that cell.

The formula =____________________(3.432,1) rounds the value 3.432 up to the next highest tenth, or 3.5.

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

Result Seek uses an iterative approach to finding the right input that achieves the desired result, or goal, in the dependent cell.

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