W04 Lesson 7: Functions in Excel

Question 11 pts

Use the function f(x) to find the missing values in the table below.

f(x)=3x+5

Input Value	Output Value
1
4
	36.2
12.2

Flag question: Question 2Question 21 pts

Evaluate the function when x=10 and y=5.

f(x,y)=3.7x+2.5y8

Group of answer choices

38.5625

5.4375

6.1875

17.125

Flag question: Question 3Question 31 pts

Yonas works driving a large harvesting machine. He earns $4 per day plus $2 for every kilometer. If his pay is a function, what are the inputs and outputs.

Group of answer choices

Input: dollars earned Output: days worked, kilometers harvested.

Input: days worked. Output: kilometers harvested.

Inputs: days worked, kilometers harvested. Output: dollars earned.

Input: plants harvested. Output cost per plant.

Flag question: Question 4Question 41 pts

Match each part of the function below with itscorrect description.

f(x)=2x+15

Group of answer choices

=

[ Choose ] The notation that tells us the function's input variable is x The symbol that connects the name of the function to the actual functional rule The name of the function The rule that uses the input value to compute the output value of the function

2x+15

[ Choose ] The notation that tells us the function's input variable is x The symbol that connects the name of the function to the actual functional rule The name of the function The rule that uses the input value to compute the output value of the function

(x)

[ Choose ] The notation that tells us the function's input variable is x The symbol that connects the name of the function to the actual functional rule The name of the function The rule that uses the input value to compute the output value of the function

f

[ Choose ] The notation that tells us the function's input variable is x The symbol that connects the name of the function to the actual functional rule The name of the function The rule that uses the input value to compute the output value of the function

Flag question: Question 5Question 51 pts

Use the function f(x) to find the missing values in the table below.

f(x)=6x+10

Input Value	Output Value
1
4
	71.8
12.2

Flag question: Question 6Question 61 pts

The charge for a taxi includes $3 for entering the taxi and $2 per kilometer. What is the charge for a 16 kilometer trip?

Group of answer choices

$50for16Kilometers

$35for16Kilometers

$21for16Kilometers

$80for16Kilometers

Flag question: Question 7Question 71 pts

Josef took a loan from Banco Verde to start his business selling clothing. The following table show the payments and interest for 3 months on this loan account. The initial loan was $185. Assume the interest rate is 1% per month (12% APR) and that the interest is charged on the balance from the previous month.

Fill in the blanks. Round your answers to two decimal places.

Month	Payment	Interest	Balance
0	-	-	$185
1	$37	$1.85
2	$25
3	$40

Flag question: Question 8Question 81 pts

Use a function in Excel to answer the following question. How much money would you have in a savings account at the end of 7 years if the following were true? You make payments of $23 a month to your savings account every month for7 years. Your savings account an interest rate of 1.2% that does not change during the 7 years. You will not take any money out of your savings account during this 7-year period. You start with $0.

Group of answer choices

$2,014.41 in your savings after 7 years

$3,303.80 in your savings after 7 years

-$2,014.41 in your savings after 7 years

$0.29 in your savings after 7 years

Flag question: Question 9Question 91 pts

How much would your monthly payment be on a 4-year loan if the following assumptions were true? You borrowed $5,000. The fixed APR on the loan is 3.2%. Note: A fixed APR is an annual interest rate that does not change during the 4-year period. You will make equal monthly payments to repay both the loan amount and the monthly interest charges. You want to completely pay off the loan in exactly 4 years.

Group of answer choices

$255,673.86 per month

$111.11 per month

$1,258.34 per month

$205.26 per month

Flag question: Question 10Question 101 pts

Does the following table of data represent a function and Why?

x (input)	y (output)
0	-1
2	5.4
2	6
8	24.6
8	25

Group of answer choices

Yes. The rule is y=3.2x-1

No, "A function is a rule that assigns the input value(s) to a single output value." However some of the same input values are assigned to more than one output values. See inputs 2 and 8.

Yes, as the inputs increase, the outputs increase

No we do not have enough information.

Flag question: Question 11Question 111 pts

Cora has a plan to pay off her business loan of $800. Her annual interest rate is 4.2%. Her payments are $23.69 per month. Complete the amortization table and find the ending balance for month 1. Round your answer to two decimal places.

Month	Beginning Balance	Payment: To Interest	Payment: To Principal	Ending Balance
1				??
2
3

Flag question: Question 12Question 121 pts

The final grade in Luciana's business class is calculated by taking 42 percent of her grade on Projects, 18 percent of her grade on group work, and 50 percent of her grade on Exams. Which of the following is the best representation of Luciana's final business grade?

Group of answer choices

The grade cannot be written as a function because of multiple inputs.

f(p,g,e)=.42p+.18g+.50e

f(p,g,e)=(p+g+e)3

f(p,g,e)=p42+g18+e50

Flag question: Question 13Question 131 pts

When Kian was born, his grandparents started a savings account for him with a beginning balance of $300. Every month they deposited $40 into the account. The savings account paid an annual interest rate of 2.1 percent, compounded monthly. Kian just turned 24 and the balance of his account is now $15458.67 How much of the money in Kian's account was earned in interest?

(Round your answer to the nearest cent, and don't include the dollar sign.)

Group of answer choices

3638.67 was gained by interest

11820.00 was gained by interest

9640.99 was gained by interest

2638.34 was gained by interest