exam review module 2 Flashcards
formulas begin with
”=”
values can be represented in 4 ways
text (labels)
numbers
boolean (true/false)
date and time
1 =
value
1 + 1
expression
+
an operator
f(X) = 2x+3
f(5) = 13
f(10)=23
what is the function name
f(x)
f(X) = 2x+3
f(5) = 13
f(10)=23
function parameter?
2x+3
f(X) = 2x+3
f(5) = 13
f(10)=23
function value
13,23
nesting functions
the combination of multiple functions in one formula
referencing
the process of using a cells name in the function or another cell
Calculating course grade average CS100 = 100 PSYCH101 = 70 REC100 = 85 ENGL 104 = 75 ECON101 = 90
= average(b1,b2,b3,b4,b5)
Calculating course grade average using range selection
CS100 = 100 PSYCH101 = 70 REC100 = 85 ENGL 104 = 75 ECON101 = 90
=average(b1:b5)
how to select numbers in multiple columns
your range would be the upper-left number, and the most bottom-right number
=average(a1:B5)
payment examples
(PMT)
Price of car : $23,889
Annual interest rate: 4.5%
monthly interest rate?
=C3/12 (yearly rate / 12 months) -> 0.375%
monthly payments
rate= interest rate nper= number of periods pv= principal value
=pmt(C4,C6,C2)
=247.69
autofill
select a range of cells, drag down from the bottom left corner, cell will autofill according to patterns
works for months, numbers, any recognizable patterns
absolute references
f4 = absolute reference
notation: c4 -> c$4$
$b = keep the column the same $5 = keep the row the same
$B -> keeps the formatting of one column/row the same. $b$3 would keep the formatting of both the column and the row.
named ranges
Unit_Price refers to =Sheet1!C$4$ -> (cell c4 with absolute referencing)
You can now use this “defined name” to use as a value.
example: C8*Unit_Price
naming ranges
select a range of values, and rename them in the name box
“total_sale”
in one cell, type “Total Sales:” . In the cell next to it, you can type “=sum(Total_Sales) to calculate the sum of the range of values you previously selected.
how to add cells to your selected range
Go to Formulas -> Name Manager -> Select range (ex: Total_Sales) -> Highlight new selected range of values.
