Unknown-2
pdf
keyboard_arrow_up
School
Baruch College, CUNY *
*We aren’t endorsed by this school
Course
2200
Subject
Information Systems
Date
Dec 6, 2023
Type
Pages
16
Uploaded by KidExploration8383
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
1.
A recent report in Forbes suggests that what percent
of firms are failing at digital transformation?
72%
2.
Amazon was started by:
Jeff Bezos
3.
T/F Data analytics and business intelligence are dri-
ving discovery and innovation.
True
4.
A company uses radio frequency identification (RFID)
tags to keep track of its inventory. This is an example
of the impact of technology in the area of _____.
operations
5.
T/F Facebook was founded by Sergey Brin.
False
6.
Experts working in the area of _____ work to make
sure systems are easy to use, while people working
in the area of _____ work to leverage technology to
make firms more efficient.
user-interface de-
sign; process de-
sign
7.
T/F David Karp, founder of the website Tumblr, sold
the website to Google for $1.1 Billion
False
8.
Another reason fueling the boom in fast-growing
technology services is ___________________, which,
when done right, can virally spread awareness of a
firm with nary a dime of conventional ad spending.
App stores
9.
T/F Apple's growing business of consumer services
bring in so much revenue that if they were a separate
division from Apple, they would be ranked as a For-
tune 100 firm.
True
10.
T/F Crowdsourcing tools and question-and-answer
sites like _____ allow firms to reach out for expertise
beyond their organizations.
Quora
11.
A(n) _____ is the symbolic embodiment of all the
information connected with a product or service.
brand
12.
false
1 / 16
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
A trademark is the symbolic embodiment of all the
information connected with a product or service of a
firm.
13.
According to Michael Porter, the reason many firms
suffer margin-eroding competition is because they
have defined themselves according to strategic po-
sitioning rather than operational effectiveness.
false
14.
A strong brand can be an exceptionally power-
ful resource for competitive advantage by lowering
________, proxying _____ and inspiring _____.
search costs;
quality; trust
15.
A salesperson's ability to effectively bargain with
his/her consumers is called viral marketing.
false
16.
According to Porter, strategy is fundamentally about
being _____.
different
17.
A firm can benefit from high switching costs, even
when rivals offer free products.
true
18.
A firm is said to be _____ when it attempts to match
the benefits of a successful position while maintain-
ing its existing position.
straddling
19.
A firm's financial performance that consistently out-
performs its industry's peers is known as _____.
sustainable com-
petitive advantage
20.
A firm's financial performance that consistently out-
performs its industry's peers is known as operational
effectiveness.
false
21.
FreshDirect regained customer trust by:
addressing the
problem head on
and correcting er-
rors as quickly as
possible
22.
2 / 16
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
Entry into the online grocery market can be costly for
FreshDirect competitors because
it would be chal-
lenging to obtain a
distribution facility
in the same area.
23.
At the start of the pandemic, FreshDirect saw an in-
crease in online orders. Website traffic increased by
_______ percent.
800
24.
Early attempts at the online grocery business were
unsuccessful because
consumers were
fine with the con-
ventional way of
shopping.
25.
FreshDirect opted for customer-focused error han-
dling because
it was less expen-
sive than losing a
lifetime of orders
from the customer.
26.
FreshDirect lost ___ percent market share of the New
York grocer market after the move to the larger facil-
ity.
20
27.
As an essential service during the pandemic,
FreshDirect met the growing demands by
limiting variety,
working with the
boroughs to ad-
dress food inse-
curity, and adding
jobs.
28.
A major threat to the FreshDirect model is:
potential entry
of better funded,
growth-seeking ri-
vals
29.
After the move to the new facility, FreshDirect
switched ___ percent of the orders from the old sys-
tem to the new.
100
30.
3 / 16
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
CEO and co-founder Dave McInerney's main goal of
launching FreshDirect was to
address the qual-
ity gap between
store-bought and
restaurant goods.
31.
High-end fashion house Prada's experiment of im-
plementing the latest technology in its flagship store
failed because:
The execution of
the technologi-
cal advancements
was poor and
didn't work well
during customer
interactions, so
managers and
staff stopped us-
ing it.
32.
Goods to be further customized based on design-
er/manager collaboration are called greige.
true
33.
Elaborate customer surveys help Zara designers pre-
dict fashion trends months into the future and design
products accordingly.
false
34.
According to an independent study, Zara books some
85 percent of its products at full price compared to
the industry average markdown ratio of 50 percent.
This is made possible by:
the practice of
having limited pro-
duction runs of its
designs.
35.
Due to limited production runs, Zara's customers:
visit the stores
more often.
36.
Factors such as weather, natural disaster, terrorism,
labor strife, or political unrest can shut down a firm's
operations. Which of the following is one of the mea-
sures taken by firms to hedge such risks?
Spreading pro-
ductions facilities
across the globe
37.
Contract manufacturers used by the apparel industry
are often criticized because:
of poor working
conditions.
38.
true
4 / 16
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
An information system consists of hardware, soft-
ware, data, procedures, and the people who interact
with and are impacted by the system.
39.
At Zara, clothes are ironed in advance and packed
on hangers, with security and price tags affixed. This
system means that employees in Zara stores simply
move items from shipping box to store racks, spend-
ing most of their time on:
value-added func-
tions like help-
ing customers find
what they want.
40.
A value chain is a set of:
activities through
which a product or
service is created
and delivered to
customers.
41.
Based on the author's take on e-waste management,
a manager would do well to learn that:
disposal and re-
cycling partners
must be audited
with the same vig-
or as suppliers
and other part-
ners.
42.
The managerial definition of Moore's Law suggests
that computing costs related to chips (microproces-
sors and silicon-based storage) double every eigh-
teen months.
False
43.
Moore's Law has impacted the camera industry such
that the firms that sell the most cameras aren't cam-
era companies, but phone manufacturers.
True
44.
E-waste is particularly difficult to address because
of:
the complexity of
the modern value
chain.
45.
A Microprocessor is a fast chip-based volatile stor-
age in a computing system.
False
5 / 16
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
46.
E-waste management is extraordinarily difficult to
monitor and track, and loopholes are rampant.
True
47.
The United States has the best environmental legis-
lation to cover e-waste and recycling standards.
False
48.
Moore's Law is possible because the distance be-
tween the pathways inside silicon chips gets smaller
with each successive generation.
True
49.
Managers looking for advice on properly dealing with
obsolete technology hardware can:
a.
consult the e-Stewards program
b.
seek advice from the International Association of
Electronics Recyclers
c.
look for partners with ISO 9001 and ISO 14001 certifi-
cations
d.
investigate resources provided by the Basel Action
Network
e.
all of the above
f.
none of the above
all of the above
50.
Moore's Law applies to all types of technology com-
ponents including hard drives and fiber optic cable
transmission speeds.
False
51.
Data becomes _____ when it is presented in a context
so that it can answer a question or support deci-
sion-making.
information
52.
Advantages based on capabilities and data that oth-
ers can acquire are long-lived.
False
53.
A data cube refers to a
6 / 16
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
special database
used to store data
in OLAP reporting.
54.
A(n) _____ is an AI system that examines data and
hunts down and exposes patterns, in order to build
models to exploit findings.
neural network
55.
Any data-centric effort should involve input not only
from business and technical staff, but from the firm's
legal team, as well.
True
56.
AI systems may reveal biases in processes and work-
force that firms aren't even aware exist.
True
57.
A(n) _____ refers to a heads-up display of critical indi-
cators that allow managers to get a graphical glance
at key performance metrics.
dashboard
58.
A _____ is a system that provides rewards and usage
incentives, typically in exchange for a method that
provides a more detailed tracking and recording of
consumer activity.
loyalty program
59.
An early version of the "Einstein" AI model being
developed at Salesforce identified the top predictor
of a sales opportunity was if a client
had the name
"John"
60.
Computer-driven investment models can be very ef-
fective when the market behaves as it has in the past.
However, in terms of historical consistency, they are
vulnerable to failure in the face of
black swans.
61.
The filter command lets you reorder rows based on
the contents of a selected column.
False
62.
Which one of the following combinations would allow
you to view formulas as they were typed into a work-
sheet as opposed to the formula outputs?
Click the Show
Formulas button in
the Formulas tab
of the Ribbon.
7 / 16
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
63.
If a column is too narrow for the data in it, numbers
will appear as what type of string?
####
64.
A1 is an example of a cell address.
True
65.
The following was entered into an Excel worksheet:
=SUM(A7:A17). Which of the following is true with this
entry?
The values in cell
A7 and all cells
up to and includ-
ing A17 will be
summed.
66.
=B6/B$10 is an example of what reference type?
mixed reference
67.
Which Excel feature is used to combine multiple cells
into a single cell?
merging
68.
Which of the following is a common mathematical
operator used in Excel formulas?
*
69.
An absolute reference is used to turn off relative
referencing so that when the formula is copied or to
a different location it doesn't change.
True
70.
What is the relation between function and formula in
Excel?
A function is a
pre-built formula
that performs spe-
cific calculations
or operations on
data.
71.
Which of the following is a valid cell reference in
Excel?
A$1
72.
When you open a new workbook it could contain
multiple worksheets with cells, rows, and columns.
True
73.
What is the primary purpose of the "Filter" feature in
Microsoft Excel?
Displaying spe-
cific data that
meets certain cri-
8 / 16
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
teria, while hiding
the rest.
74.
What is the file extension for an Excel workbook in
the latest version of Microsoft Excel?
.xlsx
75.
Which of the following is a feature of Excel for range
formatting?
Applying a custom
number format to
display values in a
specific way, such
as adding com-
mas to large num-
bers.
76.
What is the correct function to calculate the value of
all orders marked COMPLETED?
=SUMIF
(D2:D9,"complet-
ed",C2:C9)
77.
Which Paste Special option pastes just the cell con-
tents without any formatting?
Values
78.
What does the "Sort" feature in Microsoft Excel allow
you to do?
Rearrange data in
a selected range
based on speci-
fied criteria, such
as alphabetical or-
der or numerical
value.
79.
Which of the following is a feature of Excel "Paste-
Special"
Transposing the
data from rows to
columns or vice
versa.
80.
Which of the following formulas is used to calculate
the average order amount of a given range of num-
bers?
=SUM
(C2:C9)/COUNT
(C2:C9)
9 / 16
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
81.
Which of the following is a special feature of Excel
tables?
Automatic data
sorting and filter-
ing capabilities.
82.
If the criteria for COUNTIF is entered directly into the
formula, it must be a text string.
True
83.
Which type of chart in Microsoft Excel is best suited
for displaying trends over time?
Line Chart
84.
What is the main purpose of the "COUNTIF" function
in Excel?
Counting the num-
ber of cells within
a range that meets
a specific condi-
tion.
85.
What does the "PIE CHART" in Microsoft Excel rep-
resent?
The proportion of
each data point in
a series to the sum
of all data points,
shown as slices of
a circle.
86.
Which Excel feature is used to highlight cells based
on their values or conditions?
Conditional For-
matting
87.
What is the correct function to mark the order as
INTERNATIONAL if the order# is equal or greater than
200.?
=IF(A7>=200,"IN-
TERNATION-
AL","DOMES-
TIC")
88.
What is the primary benefit of using the "Sort" feature
in Microsoft Excel?
It organizes data
in a specific order,
10 / 16
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
making it easier to
analyze and find
information.
89.
Which keyboard command can be used to format data
as a table?
COMMAND + T
(Mac) / Ctrl + T
(Windows)
90.
What type of chart is best suited for showing the
relationship between two sets of numerical data in
Microsoft Excel?
Scatter Chart
91.
Which number format displays values with decimal
places, even when they are all zeros?
a. Accounting
b. Currency
c. Number
d. General
e. Standard
general
92.
When working with a large dataset that is too big
to view at once, you can keep the upper rows and
columns on the left visible all times using which com-
mand?
View
Freeze Panes
Freeze Row
Freeze Column
Sort
Freeze Panes
93.
Which type of chart connects data points with a con-
tinuous line?
line
94.
Which of the following is true with respect to the
COUNTIF function?
a. The cell range used to define the criteria argument
is what the function will count and use for the output.
b. Any cell that contains a numeric value and matches
the value used to define the range argument will be
counted.
The value used to
define the crite-
ria argument will
be searched in the
cell range used to
define the range
argument.
11 / 16
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
c. Only cells that contain a numeric value and match
what is used to define the criteria argument will be
counted. Cells containing words or text entries will
be ignored.
d. The value used to define the range argument will be
searched in the cell range used to define the criteria
argument.
e. The value used to define the criteria argument will
be searched in the cell range used to define the range
argument.
95.
When using the SUMIF function, which of the follow-
ing best describes the purpose of the Range argu-
ment?
a. range of cells where the function will search for the
data used to define the criteria argument
b. range of cells that contain data to determine which
cells will be summed by the function
c. range of cells that will be selectively summed
based on the data used to define the criteria argument
d. used to determine if the function will search for an
exact match (1) or approximate match (0) for the data
used to define the criteria argument
e. range of cells where the function will search for the
data used to define the criteria argument and is also
the range of cells that will be selectively summed if
the [sum_range] argument is not defined
range of cells
where the func-
tion will search
for the data used
to define the
criteria argument
and is also the
range of cells that
will be selective-
ly summed if the
[sum_range] argu-
ment is not de-
fined
96.
When using the SUMIF function, which of the follow-
ing best describes the purpose of the Criteria argu-
ment?
a. range of cells where the function will search for the
data used to define the criteria argument
b. range of cells that contain data to determine which
cells will be summed by the function
c. range of cells that will be selectively summed
based on the data used to define the criteria argument
d. used to determine if the function will search for an
exact match (1) or approximate match (0) for the data
range of cells that
contain data to
determine which
cells will be
summed by the
function
12 / 16
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
used to define the criteria argument
e. range of cells where the function will search for the
data used to define the criteria argument and is also
the range of cells that will be selectively summed if
the [sum_range] argument is not defined
97.
When using the SUMIF function, which of the follow-
ing best describes the purpose of the [sum_range]
argument?
a. range of cells where the function will search for the
data used to define the criteria argument
b. range of cells that contain data to determine which
cells will be summed by the function
c. range of cells that will be selectively summed
based on the data used to define the criteria argument
d. used to determine if the function will search for an
exact match (1) or approximate match (0) for the data
used to define the criteria argument
e. range of cells where the function will search for the
data used to define the criteria argument and is also
the range of cells that will be selectively summed if
the [sum_range] argument is not defined
range of cells that
will be selectively
summed based on
the data used to
define the criteria
argument
98.
The cell range $A$2:$G$27 is used to define the
table_array argument of an HLOOKUP function. If the
row_index_num argument is defined with the number
10, data from what row will appear as the output of the
function when a match is found for the lookup value?
9
10
11
12
13
11
99.
What do you create when you use one field in the
source data for your pivot table row labels and anoth-
er source field for pivot table column labels?
slicer
pivot Chart
cross-tabulation
13 / 16
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
cross-tabulation
histogram
treemap
100.
A _______ is a built-in formula that saves typing time.
function
101.
Use _______ to enter a formula into several cells at
once.
autofill
102.
A _______ chart has categories on the horizontal axis
and vertical columns that stand for numeric values.
clustered column
103.
A _______ chart is a round chart that is divided into
variously sized wedges to represent each category's
share of a total.
pie
104.
A _______ is a chart element that shows the general
relationship between the two numerical variables.
trendline
105.
The _______ function will use multiple criteria to sum
data in a targeted range of cells.
sumifs
106.
When defining the criteria argument for statistical IF
or IFS functions, words and logical tests must be
enclosed in _______.
quotations
107.
The HLOOKUP function will search in the first
_______ of the cell range used to define the table_ar-
ray argument to find a match to the lookup value.
row
108.
The VLOOKUP function will search in the first
_______ of the cell range used to define the table_ar-
ray argument to find a match to the lookup value.
column
109.
A _______ is a tool that can be used to quickly filter
a pivot table.
slicer
110.
The wrap text command is used to stack non-numeric
contents vertically in a cell.
True
14 / 16
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
111.
If you have selected a row, right-clicking and choos-
ing Insert will add a new, blank row
below the selected one.
False
112.
A major advantage of formatting data as a table in
Excel is that it uses advanced functions that only use
the lines of data actually displayed.
True
113.
The criteria for COUNTIF must be a text string.
True
114.
In conditional formatting, when you have several
rules in the Manage Rules list, each rule takes prece-
dence over those below it.
True
115.
Multiple slicers can be added to analyze a single pivot
table.
True
116.
Four percentages were calculated by entering
=A6/A10 in cell C6 and then autofilling the formula
into cells C7, C8, and C9. Rewrite the formula so that
the denominator doesn't change when the formula is
copied or autofilled.
=A6/$A$10
117.
Assume that there is data entered in a worksheet in
the cell range A1:A117. You realized that you need to
add a row of data between rows 9 and 10. Describe
the steps that you would take to insert a new row.
Select Row 10,
right-click, and se-
lect Insert. Or, on
the Home tab, se-
lect Insert, and In-
sert Cells.
118.
The column letters at the top of a worksheet are as
follows: A C D E F. Explain why column B is missing.
The column is hid-
den.
119.
Which chart should be used to show the relationship
between two numeric variables by plotting pairs of
values as points.
scatter chart
120.
Assume the number 70 is entered into cell A5 on an
Excel worksheet. In cell C5, an IF function will be
entered to produce an output based on the value in
=IF(A5<70, "NO
ACTION", "AC-
TION")
15 / 16
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
CIS EXAM 1
Study online at https://quizlet.com/_drqdyv
cell A5. If the value in cell A5 is less than 70, the output
of the IF function should be the words NO ACTION.
Otherwise, the output of the IF function should be the
word ACTION. Write this IF function
as if you were entering it into cell C5 on an Excel
worksheet.
121.
The following COUNTIF function was entered into a
cell on an Excel worksheet: =COUNTIF(A2:A107, B2)
The function will
search for a match
in the range
A2:A107 to the en-
try in cell B2
122.
The COUNTIF function is being used to summarize
data at the top of a worksheet. The function will be
used to count the number of investments that are in
the Stock category in the dataset that begins in row 10
of the worksheet. The word Stock is entered into cell
B2 on the worksheet. The range C10:C30 contains the
investment categories: Bond, Stock ETF, and Stock.
The range D10:D30 contains the investment cost and
the range E10:E30 contains the current investment
value. How should this function be entered into the
worksheet? Write the function below as if you were
entering it into an Excel worksheet.
=COUN-
TIF(C10:C30,B2)
or
=COUN-
TIF($C$10:$C$30,B2)
123.
Why should column headings in the first row of a
dataset be included in the highlighted
range before creating a pivot table?
The column head-
ings will be shown
as the field names
in the PivotTable
Field Names win-
dow pane. The
field names are
then used to
arrange the Pivot-
Table report.
16 / 16