Question 1

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

Accepted Answer

ROUNDUP
Ro

Question 2

The relational operator >= stands for ____________________ than or equal to.

Accepted Answer

The answer of The relational operator >= stands for ____________________...

Question 3

The ____ function randomly assigns a number between two specified values.

Accepted Answer

A)  RANGERANDOM 
B)  RANDBETWEEN 
C)  INBETWEEN 
D)  RANDOM 
A)  RANGERANDOM 
B)  RANDBETWEEN 
C)  INBETWEEN 
D)  RANDOM

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

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.
-Nevia's boss stops by her desk and asks which of the three numbers in the above figure is considered to be the dependent data, and she correctly answers ____.

Accepted Answer

A)  #1 
B)  #2 
C)  #3 
D)  none of the above 
A)  #1 
B)  #2 
C)  #3 
D)  none of the above

Question 6

In the Goal Seek dialog box, the cell containing the data to vary in order to reach the desired output is labeled ____.

Accepted Answer

A)  By changing cell 
B)  What to change 
C)  What if 
D)  Vary 
A)  By changing cell 
B)  What to change 
C)  What if 
D)  Vary

Question 7

If you wrote the formula =TRUNC(-4.382,1), the resulting value would be ____.

Accepted Answer

A)  -4 
B)  -4.3 
C)  -4.38 
D)  -4.382 
A)  -4 
B)  -4.3 
C)  -4.38 
D)  -4.382

Question 8

The ____ symbol acts as a digit placeholder that displays significant digits.

Accepted Answer

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

Question 9

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 10

The syntax of the RANK.EQ function is as follows: RANK(number,sort,order).

Accepted Answer

A) True 
 B)False

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

The relational operator >= stands for ____________________ than or equal to.

The ____ function randomly assigns a number between two specified values.

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 ( ).

In the Goal Seek dialog box, the cell containing the data to vary in order to reach the desired output is labeled ____.

If you wrote the formula =TRUNC(-4.382,1), the resulting value would be ____.

The ____ symbol acts as a digit placeholder that displays significant digits.

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

The syntax of the RANK.EQ function is as follows: RANK(number,sort,order).

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 formula =____________________(3.432,1) rounds the value 3.432 up to the next highest tenth, or 3.5.

The relational operator >= stands for ____________________ than or equal to.

The ____ function randomly assigns a number between two specified values.

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 ( ).

In the Goal Seek dialog box, the cell containing the data to vary in order to reach the desired output is labeled ____.

If you wrote the formula =TRUNC(-4.382,1), the resulting value would be ____.

The ____ symbol acts as a digit placeholder that displays significant digits.

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

The syntax of the RANK.EQ function is as follows: RANK(number,sort,order).

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