CIS 105 FINAL EXAM STUDY SET 100% Accurate!

The total score for Barnes at cell H9 is missing ... what should it be? - ANSWERSSUM( E9:G9) The MAX score at cell H17 doesn't appear to be correct. What is the correct formula? - ANSWERSMAX(H8:H15) Do you find an error with the quality of work ratings for Thomas in cell E13? - ANSWERSYes, a valid rating in the range should be 0 to 5 Are the ratings in cell G10 for Gordon incorrect? - ANSWERSYes, a valid rating in the range should be 0 to 5 The rank calculation formulae for the team manager at cell N10 seems to be off. What is the correct formula? - ANSWERSRANK(M10,$M$8:$M$15) The total score for Barnes at cell L9 in the table doesn't seem to be adding up correctly. What is the correct formula? - ANSWERSSUM(F9:K9) The ranks for Adam and Francis seem to be the same. Is there an error in their formula? - ANSWERSNo the formula is correct The average ratings for Terry in cell M14 is very different as compared to the other ratings. What is the correct formula? - ANSWERS(L14/60)*10 Do you see an error with the productivity rating for Damien in cell G12? - ANSWERSYes, a valid rating was not used In _______ markets, users gain benefits from interacting with a separate, complementary class of users. This is called ______ exchange benefit. - ANSWERSTwo-sided, cross-side 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: - ANSWERSTwo-sided market _____ 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. - ANSWERSCloud computing 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. - ANSWERSKilo-byte (KB); mega-byte (MG); giga-byte (GB); terabyte (TB) Products or services that add additional value to the network are called: - ANSWERSComplementary benefits I