CIS 105 FINAL EXAM QUESTIONS WITH
REVIEWED CORRECT ANSWERS
CERTIFICATION STUDY SET
SUM( E9:G9) - answer ✔✔-The total score for Barnes at cell H9 is missing ... what should it be?
MAX(H8:H15) - answer ✔✔-The MAX score at cell H17 doesn't appear to be correct. What is the correct
formula?
Yes, a valid rating in the range should be 0 to 5 - answer ✔✔-Do you find an error with the quality of
work ratings for Thomas in cell E13?
Yes, a valid rating in the range should be 0 to 5 - answer ✔✔-Are the ratings in cell G10 for Gordon
incorrect?
RANK(M10,$M$8:$M$15) - answer ✔✔-The rank calculation formulae for the team manager at cell N10
seems to be off. What is the correct formula?
SUM(F9:K9) - answer ✔✔-The total score for Barnes at cell L9 in the table doesn't seem to be adding up
correctly. What is the correct formula?
No the formula is correct - answer ✔✔-The ranks for Adam and Francis seem to be the same. Is there an
error in their formula?
(L14/60)*10 - answer ✔✔-The average ratings for Terry in cell M14 is very different as compared to the
other ratings. What is the correct formula?
Yes, a valid rating was not used - answer ✔✔-Do you see an error with the productivity rating for
Damien in cell G12?
, Two-sided, cross-side - answer ✔✔-In _______ markets, users gain benefits from interacting with a
separate, complementary class of users. This is called ______ exchange benefit.
Two-sided market - answer ✔✔-The video game industry where console owners are attracted to
platforms, with the most games, and innovative developers are attracted to platforms that have the
most users, is an example of:
Cloud computing - answer ✔✔-_____ is shared pools of configurable computer system resources and
higher - level services that can be rapidly provisioned with minimal management effort, often over the
internet.
Kilo-byte (KB); mega-byte (MG); giga-byte (GB); terabyte (TB) - answer ✔✔-Computers express data as
bits that are either one or zero. Right bits from a byte (B); a ____ is one thousand bytes; a ____ is one
million bytes; a ____ is one billion bytes; and a ______ is one trillion bytes.
Complementary benefits - answer ✔✔-Products or services that add additional value to the network are
called:
One-sided; same-side - answer ✔✔-In _____ markets, users gain benefits from interacting with a similar
category of users. This is called ____ exchange benefits.
Envelopment - answer ✔✔-When a firm seeks to make an existing market a subset of its product
offering (much like iPhone did with iPod, email, browsing), it is called :
Convergence - answer ✔✔-When two or more markets, once considered distinctly separate, begin to
offer similar features and capabilities, it is called:
The Halo Effect - answer ✔✔-"Sasha scores an 'A' on every single one of her tests. I bet she could be a
good student leader." This is an example of:
- increasing the number of users can lower the value of a product or service
REVIEWED CORRECT ANSWERS
CERTIFICATION STUDY SET
SUM( E9:G9) - answer ✔✔-The total score for Barnes at cell H9 is missing ... what should it be?
MAX(H8:H15) - answer ✔✔-The MAX score at cell H17 doesn't appear to be correct. What is the correct
formula?
Yes, a valid rating in the range should be 0 to 5 - answer ✔✔-Do you find an error with the quality of
work ratings for Thomas in cell E13?
Yes, a valid rating in the range should be 0 to 5 - answer ✔✔-Are the ratings in cell G10 for Gordon
incorrect?
RANK(M10,$M$8:$M$15) - answer ✔✔-The rank calculation formulae for the team manager at cell N10
seems to be off. What is the correct formula?
SUM(F9:K9) - answer ✔✔-The total score for Barnes at cell L9 in the table doesn't seem to be adding up
correctly. What is the correct formula?
No the formula is correct - answer ✔✔-The ranks for Adam and Francis seem to be the same. Is there an
error in their formula?
(L14/60)*10 - answer ✔✔-The average ratings for Terry in cell M14 is very different as compared to the
other ratings. What is the correct formula?
Yes, a valid rating was not used - answer ✔✔-Do you see an error with the productivity rating for
Damien in cell G12?
, Two-sided, cross-side - answer ✔✔-In _______ markets, users gain benefits from interacting with a
separate, complementary class of users. This is called ______ exchange benefit.
Two-sided market - answer ✔✔-The video game industry where console owners are attracted to
platforms, with the most games, and innovative developers are attracted to platforms that have the
most users, is an example of:
Cloud computing - answer ✔✔-_____ is shared pools of configurable computer system resources and
higher - level services that can be rapidly provisioned with minimal management effort, often over the
internet.
Kilo-byte (KB); mega-byte (MG); giga-byte (GB); terabyte (TB) - answer ✔✔-Computers express data as
bits that are either one or zero. Right bits from a byte (B); a ____ is one thousand bytes; a ____ is one
million bytes; a ____ is one billion bytes; and a ______ is one trillion bytes.
Complementary benefits - answer ✔✔-Products or services that add additional value to the network are
called:
One-sided; same-side - answer ✔✔-In _____ markets, users gain benefits from interacting with a similar
category of users. This is called ____ exchange benefits.
Envelopment - answer ✔✔-When a firm seeks to make an existing market a subset of its product
offering (much like iPhone did with iPod, email, browsing), it is called :
Convergence - answer ✔✔-When two or more markets, once considered distinctly separate, begin to
offer similar features and capabilities, it is called:
The Halo Effect - answer ✔✔-"Sasha scores an 'A' on every single one of her tests. I bet she could be a
good student leader." This is an example of:
- increasing the number of users can lower the value of a product or service
