Exam (elaborations)
CIS 105 FINAL EXAM Quizzes with 100% Correct Verified Solutions
- Course
- Institution
CIS 105 FINAL EXAM Quizzes with 100% Correct Verified Solutions
[Show more]
Seller
Follow
Content preview
CIS 105 FINAL EXAM Quizzes with 100%Correct Verified Solutions
Why is cell J7 in the pivot Table associated with the Sales Data empty? - Answer Because
Monica did not sell any washing machines on august 1st
______ comes about when we make judgments about the probability of an event under
uncertainty. - Answer representative heuristic
Bob wins the lottery. Since he knows the overall probability of winning the lottery is
really low, he does not bother buying another ticket. This is an example of Base
Rate Fallacy. True or false? - Answer False
Keyword for advertising target ads based on a user's MAC address. True or false?
- Answer False
In the case of CPC (cost per click), advertisers are charged for ad placement whether
or not a user clicks on it. True or false? - Answer False
___ comes about when we make judgements about the probability of an event
under uncertainty. - Answer Representative Heuristic
, Bob wins the lottery. Since he knows the overall probability of winning the lottery is
really low, he does not bother buying another ticket. This is an example of Base Rate
Fallacy. True or false? - Answer False
The total score for Barnes at cell H9 is missing ... what should it be? - Answer SUM(
E9:G9)
The MAX score at cell H17 doesn't appear to be correct. What is the correct formula?
- Answer MAX(H8:H15)
Do you find an error with the quality of work ratings for Thomas in cell E13? - Answer
Yes, a valid rating in the range should be 0 to 5
Are the ratings in cell G10 for Gordon incorrect? - Answer Yes, 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? - Answer RANK(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? - Answer SUM(F9:K9)
The ranks for Adam and Francis seem to be the same. Is there an error in their
formula? - Answer No 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? - Answer (L14/60)*10
Do you see an error with the productivity rating for Damien in cell G12? - Answer Yes, a
valid rating was not used
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying these notes from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller KenAli. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $12.49. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
77254 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now