Question 1

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

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" D

Question 2

The symbols > and >= are examples of ____.

Accepted Answer

A)  relational operators 
B)  relational values 
C)  arrays 
D)  reference operators 
A)  relational operators 
B)  relational values 
C)  arrays 
D)  reference operators A

Question 3

The Paste option called Paste Special pastes a connection to the original cells, including the applied formatting. _________________________

Accepted Answer

A) True 
 B)False  False

Question 4

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 5

The values TRUE and FALSE are referred to as ____.

Accepted Answer

A)  operational imperatives 
B)  Boolean values 
C)  base values 
D)  syntax neutral 
A)  operational imperatives 
B)  Boolean values 
C)  base values 
D)  syntax neutral

Question 6

A way to analyze the differences between two sets of data is to look at the percent difference of a value in one data set compared with that value in the second data set.

Accepted Answer

A) True 
 B)False

Question 7

The RANDOM function randomly assigns a number between two specified values. _________________________

Accepted Answer

A) True 
 B)False

Question 8

The Paste option called ____ pastes the formulas and formatting from the original range of cells, but reverses the orientation so that the rows of the original cell range become the columns in the pasted range, and the original columns become rows.

Accepted Answer

A)  Transpose 
B)  Switch 
C)  Wildcard 
D)  Turn 
A)  Transpose 
B)  Switch 
C)  Wildcard 
D)  Turn

Question 9

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

Accepted Answer

A) True 
 B)False

Question 10

The Paste Special dialog box offers Operation options, which allow you to paste values using only three arithmetic operations: Add, Subtract, and Multiply.

Accepted Answer

A) True 
 B)False

Question 11

A technique you can use to see different parts of the screen at the same time is to ____ the window by dragging either the horizontal split box or the vertical split box to create separate, scrollable panes.

Accepted Answer

A)  split 
B)  delete 
C)  crack 
D)  separate 
A)  split 
B)  delete 
C)  crack 
D)  separate

Question 12

The COUNTIF function accommodates a(n) single contiguous range argument. _________________________

Accepted Answer

A) True 
 B)False

Question 13

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

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 14

The ____ function provided by Excel averages a series of values if they meet specific criteria.

Accepted Answer

A)  COUNTIF 
B)  SUMIF 
C)  AVERAGE 
D)  none of the above 
A)  COUNTIF 
B)  SUMIF 
C)  AVERAGE 
D)  none of the above

Question 15

Relational operators are used to compare data.

Accepted Answer

A) True 
 B)False

Question 16

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

Accepted Answer

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

Question 17

In Goal Seek, if the target value cannot be reached exactly, the ____.

Accepted Answer

A)  Goal Seek dialog box asks for your input 
B)  value of zero is listed as the current value 
C)  closest value found is listed as the current value 
D)  none of the above 
A)  Goal Seek dialog box asks for your input 
B)  value of zero is listed as the current value 
C)  closest value found is listed as the current value 
D)  none of the above

Question 18

Case-Based Critical Thinking Questions
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.
-If you were to help Nevia, you would tell her that the space labeled #1 in the above figure ____.

Accepted Answer

A)  indicates the cell containing the output value 
B)  indicates the desired output value 
C)  indicates the cell containing the data to vary in order to reach the desired output 
D)  none of the above 
A)  indicates the cell containing the output value 
B)  indicates the desired output value 
C)  indicates the cell containing the data to vary in order to reach the desired output 
D)  none of the above

Question 19

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 20

In the SMALL function, the first argument, array, is ____.

Accepted Answer

A)  a formula 
B)  the desired ranking 
C)  a range of cells 
D)  a time period 
A)  a formula 
B)  the desired ranking 
C)  a range of cells 
D)  a time period

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

The symbols > and >= are examples of ____.

The Paste option called Paste Special pastes a connection to the original cells, including the applied formatting. _________________________

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

The values TRUE and FALSE are referred to as ____.

A way to analyze the differences between two sets of data is to look at the percent difference of a value in one data set compared with that value in the second data set.

The RANDOM function randomly assigns a number between two specified values. _________________________

The Paste option called ____ pastes the formulas and formatting from the original range of cells, but reverses the orientation so that the rows of the original cell range become the columns in the pasted range, and the original columns become rows.

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

The Paste Special dialog box offers Operation options, which allow you to paste values using only three arithmetic operations: Add, Subtract, and Multiply.

A technique you can use to see different parts of the screen at the same time is to ____ the window by dragging either the horizontal split box or the vertical split box to create separate, scrollable panes.

The COUNTIF function accommodates a(n) single contiguous range argument. _________________________

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

The ____ function provided by Excel averages a series of values if they meet specific criteria.

Relational operators are used to compare data.

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

In Goal Seek, if the target value cannot be reached exactly, the ____.

Case-Based Critical Thinking Questions 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. -If you were to help Nevia, you would tell her that the space labeled #1 in the above figure ____.

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

In the SMALL function, the first argument, array, is ____.

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

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

The symbols > and >= are examples of ____.

The Paste option called Paste Special pastes a connection to the original cells, including the applied formatting. _________________________

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

The values TRUE and FALSE are referred to as ____.

A way to analyze the differences between two sets of data is to look at the percent difference of a value in one data set compared with that value in the second data set.

The RANDOM function randomly assigns a number between two specified values. _________________________

The Paste option called ____ pastes the formulas and formatting from the original range of cells, but reverses the orientation so that the rows of the original cell range become the columns in the pasted range, and the original columns become rows.

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

The Paste Special dialog box offers Operation options, which allow you to paste values using only three arithmetic operations: Add, Subtract, and Multiply.

A technique you can use to see different parts of the screen at the same time is to ____ the window by dragging either the horizontal split box or the vertical split box to create separate, scrollable panes.

The COUNTIF function accommodates a(n) single contiguous range argument. _________________________

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

The ____ function provided by Excel averages a series of values if they meet specific criteria.

Relational operators are used to compare data.

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

In Goal Seek, if the target value cannot be reached exactly, the ____.

Case-Based Critical Thinking Questions 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. -If you were to help Nevia, you would tell her that the space labeled #1 in the above figure ____.

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

In the SMALL function, the first argument, array, is ____.

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