# Working with Formulas and Functions

### 25 terms by MattyMS24

#### Study  only

Flashcards Flashcards

Scatter Scatter

Scatter Scatter

## Create a new folder

Ex 3

### syntax

which specifies how the function should be written.

### nested

functions can also be placed inside another function.

middle

### mode

values that may be repeated several times.

### You need to reference cell Q57 in a formula. What is the absolute cell reference? What are the two mixed references?

Absolute: =\$Q\$57
Mixed: =\$Q57 or Q\$57

=S11+S12

=U11+U2

### Assume that cell V10 contains the formula =AVERAGE(\$U1:\$U5). What formula is entered if this formula is copied and pasted into cell W20?

=AVERAGE(V11,\$U15)

### What are optional arguments? What happens if you do not include an optional argument in a function?

They are not required for the function to return a value but can be included to provide more control over how Excel calculates the returned value. If an optional argument is not included, Excel assumes a default value for it. [arg1,arg2...]

=SUM(X1:X10)

=MAX(Y1:Y10)
=MIN(Y1:Y10)

### What formula with functions can you enter to calculate the ratio of the maximum value in the range Z1:Z10 to minimum value?

=MAX(Z1:Z10)/MIN(Z1:Z10)

### comparison operator

is a symbol that indicates the relationship between two values.

### principle

is the amount of money being loaned.

### interest

is the amount of money added to the principle by the lender.

### simple interest

the interest is equal to a percentage of principle for each period that the money has been lent.

### compound interest

the interest is applied not only to the principle but also to any accrued interest.

### How do you use AutoFill to copy a set of cell values, but not the formatting?

Drag the box to where you want to stop, then by the options bar expand it and click fill without formatting.

12,15,18

### If cell P5 contains the text "Mon," and then you select the cell and drag the fill handle over the range P6:P8, what text will be entered into those cells?

Tues. , Wed. , Thurs.

### If cell Q3 is greater than cell Q4, you want to display "OK"; otherwise, you want to display "RETRY". Write the formula that accomplishes this.

=IF(Q3>Q4,"OK","RETRY")

=TODAY()

=NOW()

### You want to take out a loan for \$130,000. The interest on the loan is 5% compounded monthly. You intend to pay back the loan in 20 years. Write the formula to calculate the monthly payment required to pay off the loan under those conditions.

=PMT(0.05/12, 20*12, 130000)

NPER

Example: