exam review module 2

Question 1

formulas begin with

Answer 1

”=”

Question 2

values can be represented in 4 ways

Answer 2

text (labels)

numbers

boolean (true/false)

date and time

Question 3

1 =

Answer 3

value

Question 4

1 + 1

Answer 4

expression

Question 5

+

Answer 5

an operator

Question 6

f(X) = 2x+3
f(5) = 13
f(10)=23

what is the function name

Answer 6

f(x)

Question 7

f(X) = 2x+3
f(5) = 13
f(10)=23

function parameter?

Answer 7

2x+3

Question 8

f(X) = 2x+3
f(5) = 13
f(10)=23

function value

Answer 8

13,23

Question 9

nesting functions

Answer 9

the combination of multiple functions in one formula

Question 10

referencing

Answer 10

the process of using a cells name in the function or another cell

Question 11

Calculating course grade average
CS100 = 100
PSYCH101 = 70
REC100 = 85
ENGL 104 = 75
ECON101 = 90

Answer 11

= average(b1,b2,b3,b4,b5)

Question 12

Calculating course grade average using range selection

CS100 = 100
PSYCH101 = 70
REC100 = 85
ENGL 104 = 75
ECON101 = 90

Answer 12

=average(b1:b5)

Question 13

how to select numbers in multiple columns

Answer 13

your range would be the upper-left number, and the most bottom-right number

=average(a1:B5)

Question 14

payment examples

(PMT)

Price of car : $23,889

Annual interest rate: 4.5%

monthly interest rate?

Answer 14

=C3/12 (yearly rate / 12 months) -> 0.375%

Question 15

monthly payments

Answer 15

rate= interest rate
nper= number of periods
pv= principal value

=pmt(C4,C6,C2)
=247.69

Question 16

autofill

Answer 16

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

Question 17

absolute references

Answer 17

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.

Question 18

named ranges

Answer 18

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

Question 19

naming ranges

Answer 19

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.

Question 20

how to add cells to your selected range

Answer 20

Go to Formulas -> Name Manager -> Select range (ex: Total_Sales) -> Highlight new selected range of values.