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
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
