Exam (elaborations)
CGS 2518 Module 5 and 6 Exam Questions and Answers
- Course
- Institution
CGS 2518 Module 5 and 6 Exam Questions and Answers
[Show more]
Content preview
CGS 2518 Module 5 and 6 ExamQuestions and Answers
The date 5/12/2018 is stored (in format MONTH/DAY/YEAR) in cell C1. What function
should you use to extract just 12? - Answers -=DAY(C1)
Today's date (February 12, 2018) is stored in cell B1. The last day of the semester (May
4, 2018) is stored in cell B2. You want to know how many days until the end of the
semester. Which function should you use? - Answers -=DAYS(B2, B1)
You workbook contains a list of artwork. Column B lists Sold Out if the piece is sold out,
Available if it is still readily available, or Limited if only a few pieces are available. In the
third column, you want to display TRUE if the art is not sold out. What function would
produce the same results as =OR(B1="Available", B1="Limited")? - Answers -
=NOT(B1="Sold Out")
The original mortgage loan was for $300,000 with a 5% APR for 30 years. You want to
calculate the interest on the last monthly payment at the end of the 15th year. What
value should be referenced for the per argument in the IPMT function? Hint: Number of
payment periods in a year is 12. - Answers -180
A workbook contains a list of members in the Computer Club. You want to identify the
number of students who are freshmen who are Information Systems majors. Without
filtering the dataset, what function should you use? - Answers -DCOUNT
A worksheet contains the times in which runners completed a race, with the times
organized from fastest to slowest. You will use the MATCH function to identify what
place a runner came in given a time of 4:05 (four minutes and five seconds). Which
argument should contain the specific runner's time? - Answers -Lookup_value
What function would you use to calculate the total (i.e., cumulative) interest paid for the
first year of a mortgage? - Answers -CUMIPMT
When you are performing an advanced filter, where do you enter the rage for the
dataset? - Answers -List range
A local police office wants to create a rule that if an officer pulls over a person for
exceeding the speed limit by at least five miles per hour or if that person has two or
more speeding violations on record, the officer will fine the speeder the higher of $200
or $50 for each mile over the speed limit. Otherwise, the fine is $45. The speed limit is
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 millyphilip. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy these notes for $7.99. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
62890 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy study notes for 14 years now