bus 215 questions Answered
Questions 2025- 2026
✅
When formatting a cell as an absolute reference or address, you - correct answer
Highlight the reference in the formula and Press F4
✅
Why would you use an absolute cell reference in a formula? - correct answer
Using an absolute reference allows you to fill a formula down while still
pointing to the absolute reference
What is an easy way to transpose a long list of numbers? - correct answer
& Paste Special
✅ Copy
You can... - correct answer ✅All of the above:
- change the row height
- hide a row
- insert and delete a row
Hardcoding a variable means - correct answer
in a formula
✅ Including the value of a variable
✅
How are the Currency and Accounting number formats different? - correct answer
Both:
- The currency symbol is flush to the number in the currency format and flush left
in the accounting format
- A zero value is represented as a dash in the accounting format and a 0 in the
currency format
You can round the value of a cell by - correct answer ✅Using the Round formula
,bus 215 questions Answered
Questions 2025- 2026
You can... - correct answer ✅ Both:
- Insert a column
- hide a column
Conditional formatting is powerful because - correct answer ✅ .
It enables rapid visual analysis of a data set
can be displayed? - correct answer ✅
When formatting a cell as a fraction, what is the maximum number of digits that
Three
The best decision makers ... - correct answer ✅use the appropriate analysis of
data they have satisfied themselves are valid as a tool to inform their decision
making.
Statistics ... - correct answer ✅Both:
- is the process of generating or collecting, organizing, analyzing, interpreting, and
presenting data.
- are calculations made from sample data.
The limitations of statistics include ... - correct answer ✅
analyst bias.
damned lies, and statistics." - correct answer ✅
To what did the following quote from the instructor's notes refer? "There are lies,
analyst ethics.
, bus 215 questions Answered
Questions 2025- 2026
Deconstructing a process into its component parts and determining how those
... - correct answer✅
parts relate to each other and the overall purposes of the process is an example of
analyzing.
To what does the phrase "Garbage in, garbage out" refer? - correct answer ✅The
effect the quality of data has on decisions made informed by an analysis of those
data
The value of a specific variable for a specific observation is - correct answer
datum
✅
a
___________ data. - correct answer ✅
The response scale [1. Spruce 2. Hemlock 3. Maple 4. Oak 5. Cedar] will yield
nominal
correct answer ✅
The response scale [Lowest 1 2 3 4 5 Highest] will yield ____________ data. -
interval
- correct answer ✅
To calculate a percentage change between values, we need ______________ data.
ratio
✅
Which data are not continuous or treated as continuous? - correct answer
Number of defects in production runs
type of data? - correct answer ✅
The closing values of the S&P 500 Index for each trading day in 2020 are what
Time Series
Questions 2025- 2026
✅
When formatting a cell as an absolute reference or address, you - correct answer
Highlight the reference in the formula and Press F4
✅
Why would you use an absolute cell reference in a formula? - correct answer
Using an absolute reference allows you to fill a formula down while still
pointing to the absolute reference
What is an easy way to transpose a long list of numbers? - correct answer
& Paste Special
✅ Copy
You can... - correct answer ✅All of the above:
- change the row height
- hide a row
- insert and delete a row
Hardcoding a variable means - correct answer
in a formula
✅ Including the value of a variable
✅
How are the Currency and Accounting number formats different? - correct answer
Both:
- The currency symbol is flush to the number in the currency format and flush left
in the accounting format
- A zero value is represented as a dash in the accounting format and a 0 in the
currency format
You can round the value of a cell by - correct answer ✅Using the Round formula
,bus 215 questions Answered
Questions 2025- 2026
You can... - correct answer ✅ Both:
- Insert a column
- hide a column
Conditional formatting is powerful because - correct answer ✅ .
It enables rapid visual analysis of a data set
can be displayed? - correct answer ✅
When formatting a cell as a fraction, what is the maximum number of digits that
Three
The best decision makers ... - correct answer ✅use the appropriate analysis of
data they have satisfied themselves are valid as a tool to inform their decision
making.
Statistics ... - correct answer ✅Both:
- is the process of generating or collecting, organizing, analyzing, interpreting, and
presenting data.
- are calculations made from sample data.
The limitations of statistics include ... - correct answer ✅
analyst bias.
damned lies, and statistics." - correct answer ✅
To what did the following quote from the instructor's notes refer? "There are lies,
analyst ethics.
, bus 215 questions Answered
Questions 2025- 2026
Deconstructing a process into its component parts and determining how those
... - correct answer✅
parts relate to each other and the overall purposes of the process is an example of
analyzing.
To what does the phrase "Garbage in, garbage out" refer? - correct answer ✅The
effect the quality of data has on decisions made informed by an analysis of those
data
The value of a specific variable for a specific observation is - correct answer
datum
✅
a
___________ data. - correct answer ✅
The response scale [1. Spruce 2. Hemlock 3. Maple 4. Oak 5. Cedar] will yield
nominal
correct answer ✅
The response scale [Lowest 1 2 3 4 5 Highest] will yield ____________ data. -
interval
- correct answer ✅
To calculate a percentage change between values, we need ______________ data.
ratio
✅
Which data are not continuous or treated as continuous? - correct answer
Number of defects in production runs
type of data? - correct answer ✅
The closing values of the S&P 500 Index for each trading day in 2020 are what
Time Series
