CIS 2010 Exam 2 || A+ GRADED
Which of the following are steps in real-world problem solving? correct answers a) Define
(identify the problem)
B) Reflect (review and re-examine)
C)Prepare a solution (Research & Brainstorm)
D)Try (test to see what works)
Which of the following best characterizes a compound problem? correct answers Errors that
have more than one problem
Which of the following characterize disruptive technology? correct answers - A new way of
doing things that initially doesn't meet the needs of existing customers
- Tend to open new markets and destroy old ones
Which of the following are characteristics of a typical company growth curve?
a)Eagerly cannibalize existing core business in order to embrace immature technologies.
b)Companies focus on what works and make changes in order to generate consistent cash
flow to support growth.
c)Established incumbent businesses embrace radical and even risky changes to technologies
and processes.
d) As a business matures early experimentation gives way to standardization. correct answers
b)Companies focus on what works and make changes in order to generate consistent cash
flow to support growth.
d) As a business matures early experimentation gives way to standardization.
Which of the following are examples of digital distuption? correct answers - Uber & Lyft
-World-Wide-Web
-Netflix
-iPhone
Disruptive Technology correct answers Tend to open new markets and destroy old ones
- A new way of doing things that initially doesn't meet
Digital Darwinism correct answers What's best for the current business might not be what's
best for it in long term?
Sustaining Technology correct answers Tend to provide us with better, faster, and cheaper
products in established markets
- produces an improved product customers are eager to but such as a faster car or larger hard
drive
life cycle disruption correct answers 1. detectable
2.clear
3.inevitable
4. new normal
, Which of the following are examples of Disruptive Technologies since the advent of the
World Wide Web? correct answers Smartphones,eCommerce.Internet of Things., YouTube
Which of these functions in excel is best suited for extracting a substring from within a long
text message? correct answers Left
Which of these functions in excel is best suited for uniting two (or more) substrings into a
single larger string? correct answers Concatenate
syntax error correct answers Incorrect, missing, or extra punctuation such as commas,
periods, quotes
wrong function correct answers function name is known but is incorrect for the task
argument error correct answers parameter or argument error (supplies incorrect data to a
function)
math error correct answers math formula does not accomplish the intended calculation
logic error correct answers conditional logic does not accomplish intended action
boundary condition correct answers logic incorrect for start, end, or equivalency condition
format error correct answers display of value is incorrect or misleading
other correct answers errors not matching other categories
correct answer correct answers correct answer
Debugging Excel error goal correct answers Your goal is to explain the facts (that is, the
specific error(s) that occurred) and examine the chain of events that led up to them.
Define (identify the problem). correct answers • Recognize the problem.
•Investigate to gather clues and information.
- Excel sometimes gives hints
- Excel also has tools to provide information
•Check your assumptions
• Attempt to label the problem (give it a name, category or label)
Auditing tools correct answers tracing error values: determines where the error originates
formula tab-> error checking button-> error-> trace error
- to show formula that is in the cell and value
Check Assumptions correct answers Check if the assumptions are as accurate as we think
- look at the FX function
Multiple Windows correct answers Shrink the Excel window to be less than full screen
• Open a second window for this file: VIEW ribbon > New Window[MAC: Apple menu >
New Window]
Which of the following are steps in real-world problem solving? correct answers a) Define
(identify the problem)
B) Reflect (review and re-examine)
C)Prepare a solution (Research & Brainstorm)
D)Try (test to see what works)
Which of the following best characterizes a compound problem? correct answers Errors that
have more than one problem
Which of the following characterize disruptive technology? correct answers - A new way of
doing things that initially doesn't meet the needs of existing customers
- Tend to open new markets and destroy old ones
Which of the following are characteristics of a typical company growth curve?
a)Eagerly cannibalize existing core business in order to embrace immature technologies.
b)Companies focus on what works and make changes in order to generate consistent cash
flow to support growth.
c)Established incumbent businesses embrace radical and even risky changes to technologies
and processes.
d) As a business matures early experimentation gives way to standardization. correct answers
b)Companies focus on what works and make changes in order to generate consistent cash
flow to support growth.
d) As a business matures early experimentation gives way to standardization.
Which of the following are examples of digital distuption? correct answers - Uber & Lyft
-World-Wide-Web
-Netflix
-iPhone
Disruptive Technology correct answers Tend to open new markets and destroy old ones
- A new way of doing things that initially doesn't meet
Digital Darwinism correct answers What's best for the current business might not be what's
best for it in long term?
Sustaining Technology correct answers Tend to provide us with better, faster, and cheaper
products in established markets
- produces an improved product customers are eager to but such as a faster car or larger hard
drive
life cycle disruption correct answers 1. detectable
2.clear
3.inevitable
4. new normal
, Which of the following are examples of Disruptive Technologies since the advent of the
World Wide Web? correct answers Smartphones,eCommerce.Internet of Things., YouTube
Which of these functions in excel is best suited for extracting a substring from within a long
text message? correct answers Left
Which of these functions in excel is best suited for uniting two (or more) substrings into a
single larger string? correct answers Concatenate
syntax error correct answers Incorrect, missing, or extra punctuation such as commas,
periods, quotes
wrong function correct answers function name is known but is incorrect for the task
argument error correct answers parameter or argument error (supplies incorrect data to a
function)
math error correct answers math formula does not accomplish the intended calculation
logic error correct answers conditional logic does not accomplish intended action
boundary condition correct answers logic incorrect for start, end, or equivalency condition
format error correct answers display of value is incorrect or misleading
other correct answers errors not matching other categories
correct answer correct answers correct answer
Debugging Excel error goal correct answers Your goal is to explain the facts (that is, the
specific error(s) that occurred) and examine the chain of events that led up to them.
Define (identify the problem). correct answers • Recognize the problem.
•Investigate to gather clues and information.
- Excel sometimes gives hints
- Excel also has tools to provide information
•Check your assumptions
• Attempt to label the problem (give it a name, category or label)
Auditing tools correct answers tracing error values: determines where the error originates
formula tab-> error checking button-> error-> trace error
- to show formula that is in the cell and value
Check Assumptions correct answers Check if the assumptions are as accurate as we think
- look at the FX function
Multiple Windows correct answers Shrink the Excel window to be less than full screen
• Open a second window for this file: VIEW ribbon > New Window[MAC: Apple menu >
New Window]
