FNU Case Based Critical Thinking Questions

2 PointsA 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.

1. split
2. delete
3. crack
4. separate

2 PointsCase-Based Critical Thinking Questions 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 situations.
Julia wants to take a count of all employees who are participating in exactly one committee. A correct formula would be ____.

1. =COUNTIF(F3:F13,“<1”)
2. =COUNTIF(F3:F13,“>1”)
3. =COUNTIF(F3:F13,“>=1”)
4. =COUNTIF(F3:F13,“=1”)

2 PointsA format code can include up to four parts, each separated by a semicolon, and does NOT include:

1. Negative number format
2. Positive number format
3. Zero value format
4. Placeholder format

2 PointsCase-Based Critical Thinking Questions Case 2-2
Nevia is looking at using Goal Seek for the first time. She is determining what to put in each of the text boxes inside the Goal Seek dialog box shown in the above figure.
At the end of the project, Nevia is very pleased with the results and is giving a demo of Goal Seek to a few of her co-workers. To open Goal Seek, her first step is to click the ____ tab on the Ribbon.

1. Formulas
2. Page Layout
3. Review
4. Data

2 PointsTo 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.

1. average difference
2. standard deviation difference
3. percent difference
4. none of the above

2 Points____ are symbols that you can use as part of the criteria to search for text strings in which the symbol can be substituted for another character or set of characters.

1. Wingdings
2. Wildwheels
3. Open Text
4. Wildcards

2 PointsThe ____ symbol indicates to skip the width of the next character; frequently used with ( ) to make sure positive numbers align with negative numbers displayed with ( ).

1. underscore
2. dash
3. @
4. +

2 PointsCase-Based Critical Thinking Questions 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 situations.
On a separate project, the head of Human Resources is looking for a list of those 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 _____.

1. =COUNTIF(E3:E13,“<>1”)
2. =COUNTIF(E3:E13,“=1”)
3. =COUNTIF(E3:E13,“>=1”)
4. =COUNTIF(E3:E13,“<1”)

2 PointsThe ____ function returns a random value between 0 and 1.

1. RANDUNDER
2. RAND()
3. RANDZERO
4. RANDONE

2 PointsGoal Seek continues to enter values until it reaches ____.

1. 0.001 of the goal
2. 100 iterations
3. either a or b
4. neither a nor b