• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 3 out of 21 pages
Exam (elaborations)

ICS 101 Final Exam

Document preview thumbnail
Preview 3 out of 21 pages

Exam of 21 pages for the course ICS 101 at ICS 101 (ICS 101 Final Exam)

Content preview

ICS 101 Final Exam
Study online at https://quizlet.com/_f230a9

1. How does IF -Identify conditions and determine actions
work? -Ex: IF it is hot, I will wear beach attire to school. Otherwise, I will wear business
casual attire.
-Ex: =IF(A1>=B26,"ICS101B",IF(A8>=B27,"ICS101", 101))

2. How does COUN- Count a range if criteria is met
TIF work?

3. How does SUMIF Sum a range if criteria is met
work?

4. How does AVER- Average of a range if criteria is met
AGEIF work?

5. How does AND -Identify all conditions being true
work? -Ex: If it is sunny AND hot, I will wear beach attire to school. Otherwise, I will wear
business casual attire to school.

6. How does NOT -Identify conditions not being true
work? -Ex: If it is NOT cold, I will wear beach attire to school. Otherwise, I will wear
business casual attire to school.

7. How does OR -Identifies any condition being true (Single conditions is true)
work? -Ex: If it is sunny OR hot, I will wear beach attire to school. Otherwise, I will wear
business casual attire to school.

8. Excel syntax

9. Amortization -Table detailing payments on a loan
schedules -Essentially calculates how much of each of your payments goes toward the
principal (loan) and the amount that is interest
-Typically used with mortgages, car loans, and business loans




, ICS 101 Final Exam
Study online at https://quizlet.com/_f230a9

Includes Loan Amount, Period, Term, Interest Rate, Payment
-

10. Amortization Loan (Present Value): Loan Amount
Schedule Rate: Interest rate; Calculated per periodic payment
Concepts Term: Length of the loan (typically in years)
Payments Per Year: # of payments each year (i.e. monthly, quarterly)
Periodic Payment: Payment amount for each recurring payment (includes interest
and principal portion of the payment)
Period: Recurring payment

11. Comparing loans -Create 2 amortization schedules and compare them
-Identify when the loans would cost an equal amount based on APR and cash
back
-Determine when you can pay off the loan to see which case is better
-Use logic statements to help you with your decision

12. Arguments/lists PER, NPER, RATE, PV

13. PER

14. NPER Number of Periods
-Total number of periods (7 year loan with monthly payments, has 84 periods)

15. RATE (APR)

16. PV PV = Loan Amount

17. Functions PMT, PPMT, IPMT

18. PMT PMT = PPMT + IPMT

19. PPMT Principal Payment
-Amount of each periodic payment that goes toward the loan



, ICS 101 Final Exam
Study online at https://quizlet.com/_f230a9

20. IPMT Interest Payment
-Amount of each periodic payment that is interest

21. Wisdom -Ex: Using knowledge derived from wisdom to predict the future

22. If a person fell Medical
from a tree and
hurt their back
badly, which type
of visualization
would help doc-
tors to determine
the extent of the
injury?

23. We should spend FALSE
hours viewing vi-
sualizations to
fully understand
it.

24. Data science The science and technology of turning data into wisdom

25. Data Values
Ex: Pineapple, coconut, mango, mango, coconut, coconut, coconut

26. Information Data that has been processed with context to give it meaning
Ex: Pineapple, coconut, mango, mango, coconut, coconut, coconut. Those were
flavors of shaved ice sold yesterday.

27. Knowledge Assumptions gathered over time
Ex: Over time you might discover: Mango was popular in Spring, Coconut was
popular in Summer, Pineapple was popular in Fall

Document information

Uploaded on
August 10, 2025
Number of pages
21
Written in
2025/2026
Type
Exam (elaborations)
Contains
Questions & answers
$18.49

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Bestnursekylie
4.4
(2035)
Sold
1132
Followers
706
Items
3140
Last sold
1 week ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions