WPC 300 FINAL EXAM 2026/2027 QUESTIONS AND
SOLUTIONS RATED A+
✔✔In a multi dimensional analytical operation, analyzing a smaller version of a cube is
called
A. Slice
B. Pivot
C. Dice
D. Drill-down - ✔✔C. Dice
✔✔Let us assume that you started a job on 08/21/2019. You graduated on 05/20/2022.
How many days have you been working at the job as a student? - ✔✔1003
✔✔What is The difference between VLOOKUP and HLOOKUP?
HLOOKUP works exactly like VLOOKUP, except that the data in the lookup table is
organized in rows instead of columns.
VLOOKUP works exactly like HLOOKUP, except that the data in the lookup table is
organized in rows instead of columns.
VLOOKUP always works with an exact match, whereas HLOOKUP is not.
VLOOKUP always works with an approximate match, whereas HLOOKUP is not -
✔✔HLOOKUP works exactly like VLOOKUP, except that the data in the lookup table is
organized in rows instead of columns.
✔✔A continuous random variable x is normally distributed with a mean of 0 and a
standard deviation of 1. The probability of an observation that lies within the range of -
1.0 < X < 1.0 is:
0.68
0.5
0.62
1 - ✔✔0.68
✔✔Company A wants to return to profitability, and they define the problem statement in
terms of a reduction in their operating costs. Which of the options below is the best
choice to improve this problem statement?
Make it more specific, measurable, and time-bound
Make it time-bound only
Research the market and competitors
Add the statement and increase revenue - ✔✔Make it more specific, measurable, and
time-bound
✔✔Which of the following statements is true about problem-solving?
Good problem-solving is a process, not a quick mental calculation or a logical
deduction.
, The process of problem-solving is over once your analysis is complete.
The first step of the problem-solving process is problem disaggregation.
There are six steps of problem-solving in the bulletproof problem-solving framework. -
✔✔Good problem-solving is a process, not a quick mental calculation or a logical
deduction.
✔✔During the problem disaggregation process, the logic trees should have branches
that are
Both mutually exclusive and collectively exhaustive
Mutually exclusive
Collectively exhaustive
Neither mutually exclusive or collectively exhaustive - ✔✔Both mutually exclusive and
collectively exhaustive
✔✔During the pruning process, we remove elements of the disaggregation that have...
Only a minor influence on the problem
Only a significant influence on the problem
Easy to affect
The larger potential scale of impact - ✔✔Only a minor influence on the problem
✔✔In a multi-dimensional analysis, keeping one of the dimensions constant and
analyzing two dimensions of a cube is called:
Slice
Dice
Pivot
Roll-Up - ✔✔Slice
✔✔Poisson distribution is applied for
Discrete random variable
Continuous random variable
Uniform random variable
Uncertain random variable - ✔✔Discrete random variable
✔✔Which of the following are not examples of measures in a multi-dimensional
analysis:
Time period
Revenue
Quantity
Cost of goods sold - ✔✔Time period
✔✔Which of the following logic trees starts with sub-elements on the left and the
problem statements to the far right?
Inductive logic tree
Deductive logic tree
Hypothesis tree
SOLUTIONS RATED A+
✔✔In a multi dimensional analytical operation, analyzing a smaller version of a cube is
called
A. Slice
B. Pivot
C. Dice
D. Drill-down - ✔✔C. Dice
✔✔Let us assume that you started a job on 08/21/2019. You graduated on 05/20/2022.
How many days have you been working at the job as a student? - ✔✔1003
✔✔What is The difference between VLOOKUP and HLOOKUP?
HLOOKUP works exactly like VLOOKUP, except that the data in the lookup table is
organized in rows instead of columns.
VLOOKUP works exactly like HLOOKUP, except that the data in the lookup table is
organized in rows instead of columns.
VLOOKUP always works with an exact match, whereas HLOOKUP is not.
VLOOKUP always works with an approximate match, whereas HLOOKUP is not -
✔✔HLOOKUP works exactly like VLOOKUP, except that the data in the lookup table is
organized in rows instead of columns.
✔✔A continuous random variable x is normally distributed with a mean of 0 and a
standard deviation of 1. The probability of an observation that lies within the range of -
1.0 < X < 1.0 is:
0.68
0.5
0.62
1 - ✔✔0.68
✔✔Company A wants to return to profitability, and they define the problem statement in
terms of a reduction in their operating costs. Which of the options below is the best
choice to improve this problem statement?
Make it more specific, measurable, and time-bound
Make it time-bound only
Research the market and competitors
Add the statement and increase revenue - ✔✔Make it more specific, measurable, and
time-bound
✔✔Which of the following statements is true about problem-solving?
Good problem-solving is a process, not a quick mental calculation or a logical
deduction.
, The process of problem-solving is over once your analysis is complete.
The first step of the problem-solving process is problem disaggregation.
There are six steps of problem-solving in the bulletproof problem-solving framework. -
✔✔Good problem-solving is a process, not a quick mental calculation or a logical
deduction.
✔✔During the problem disaggregation process, the logic trees should have branches
that are
Both mutually exclusive and collectively exhaustive
Mutually exclusive
Collectively exhaustive
Neither mutually exclusive or collectively exhaustive - ✔✔Both mutually exclusive and
collectively exhaustive
✔✔During the pruning process, we remove elements of the disaggregation that have...
Only a minor influence on the problem
Only a significant influence on the problem
Easy to affect
The larger potential scale of impact - ✔✔Only a minor influence on the problem
✔✔In a multi-dimensional analysis, keeping one of the dimensions constant and
analyzing two dimensions of a cube is called:
Slice
Dice
Pivot
Roll-Up - ✔✔Slice
✔✔Poisson distribution is applied for
Discrete random variable
Continuous random variable
Uniform random variable
Uncertain random variable - ✔✔Discrete random variable
✔✔Which of the following are not examples of measures in a multi-dimensional
analysis:
Time period
Revenue
Quantity
Cost of goods sold - ✔✔Time period
✔✔Which of the following logic trees starts with sub-elements on the left and the
problem statements to the far right?
Inductive logic tree
Deductive logic tree
Hypothesis tree
