NUR 354 2 FINAL TEST 2026
QUESTIONS WITH CORRECT
ANSWERS GRADED A+
◍ Amortization - Loan Payment Amount.
Answer: Payment = Rate CEll/12, Term, Princiable ValueEX.
=PMT(Cell/12,cell,Cell)
◍ Calculate the interest amount for period 1 in cell D11.Multiply the balance
in period 0 (cell F10) by the loan interest rate (cell C4) divided by 12 (to
create a monthly interest rate).This formula is reusable. The interest for a
given period is always the monthly interest rate times the balance from the
previous period..
Answer: Interest = balance cell *interest$/12
◍ Amortization - Copy the Intrest amount calc down, complete the "interest
column".
Answer: Pull Interest amount column down
◍ Amortization -Calculate the princinle amount for *p1.
Answer: Payment amount - interest amount=cell - cell
◍ Amortization - Calculate the balance for (period 1).
Answer: Balance for period 0 - princible amount period 1=cell - cell
◍ Amortization - Copy the balance amount calc down, complete the "balance".
Answer: Pull Balance column down
◍ Amortization - Calculate the Total amount paid.
Answer: Payment Amount * Term(Months) of the Loan=cell* cell
◍ Amortization - Calculate the Total Interest paid - SUM.
Answer: =SUM(cell,cell) Whole interst column
,◍ Amortization - Check to see if total interest calc is correct - SUM CHECK.
Answer: Total amount paid - original loan amount=Cell-Cellif loan amount
is negative : =Cell+Cell
◍ Amortization - Assume you made the first (#) payments, you believe you
can sell your car for($) will this cover the balance on the car in period(#)?.
Answer: Is the balance in period(#) less then ($)If No - dont trade in the
carIf Yes - Trade in the car
◍ What feature inserts a function that totals the cells above or to the left of the
selected cell?.
Answer: A. AutoSum
◍ To save a workbook for the first time, you use the Save As dialog box.
Answer: True
◍ Which of the following inserts a function into a cell?.
Answer: B.AutoSum button
◍ To preserve the original version of a workbook so you can make changes to
a copy of it, which of the following would you do?.
Answer: D. Open the workbook, make changes, and then save it using a
different name
◍ If you specify that you want worksheet gridlines to appear on the screen,
they will automatically appear on the printout as well..
Answer: False
◍ four J's painting - Use the HLOOKUP funtion to complete the hourly wage
COLUMN.
Answer: in the first cell of the hourly wage
column=HLOOKUP(Lookup_value, table_array, row_index_num,
[range_lookup)=HLOOKUP(Employee ell, Employee wage info table w/ $,
row that has the money 1 or 2, FALSEDrag column downHourly Wage info
should match in column for horly wage in table
◍ four J's painting - Use the AND function to complete the time bouns
, columnEmployee earns a time bouns of the projects hours worked are fewer
then the estomated hours and if the work quality is grater then 1.
Answer: in the first cell of the time bonus column=AND(logical1,
Logical2)=AND(Hours worked cell<estimated hours cell , quality cell >
1)Drag column down
◍ four J's painting - Use the OR function to complete the outcome bounus
columnemployee earns out come bonus is diff of the job is grater then 3 or if
quality of work is equal to 3.
Answer: in the first cell of the outcome bonus column=OR(logical1,
Logical2)=OR(Diff Cell>3,quality cell >=3)Drag column down
◍ To enter a range of text based on examples that are already in your
worksheet, which of the following can you use?.
Answer: B. Flash fill
◍ Where do you rename a workboard and adjust its save location?.
Answer: A. Save As dialog box
◍ four J's painting - Use the IF function to complete the Time bounus
columNIf the employee earns a time bonus, then "Time Bouus$"is the job
pay for that project, if the value is false 0.
Answer: in the first cell of the outcome Time bonus column=IF( Time bonus
cell =true,job pay cell * bonus percentage cell $, if the value is false 0Drag
column down
◍ four J's painting - Use the IF function to complete the outcome bounus
columnIf the employee earns a outcome bonus, then outcome bouns is the
job pay for that project, if the value is false 0.
Answer: in the first cell of the outcome column=IF( outcome cell =true,job
pay cell * outcome percentage $cell $, if the value is false 0Drag column
down
◍ Which of the following lets you fill a cell with only specific elements of a
copied cell?.
Answer: B. AutoFill options button
QUESTIONS WITH CORRECT
ANSWERS GRADED A+
◍ Amortization - Loan Payment Amount.
Answer: Payment = Rate CEll/12, Term, Princiable ValueEX.
=PMT(Cell/12,cell,Cell)
◍ Calculate the interest amount for period 1 in cell D11.Multiply the balance
in period 0 (cell F10) by the loan interest rate (cell C4) divided by 12 (to
create a monthly interest rate).This formula is reusable. The interest for a
given period is always the monthly interest rate times the balance from the
previous period..
Answer: Interest = balance cell *interest$/12
◍ Amortization - Copy the Intrest amount calc down, complete the "interest
column".
Answer: Pull Interest amount column down
◍ Amortization -Calculate the princinle amount for *p1.
Answer: Payment amount - interest amount=cell - cell
◍ Amortization - Calculate the balance for (period 1).
Answer: Balance for period 0 - princible amount period 1=cell - cell
◍ Amortization - Copy the balance amount calc down, complete the "balance".
Answer: Pull Balance column down
◍ Amortization - Calculate the Total amount paid.
Answer: Payment Amount * Term(Months) of the Loan=cell* cell
◍ Amortization - Calculate the Total Interest paid - SUM.
Answer: =SUM(cell,cell) Whole interst column
,◍ Amortization - Check to see if total interest calc is correct - SUM CHECK.
Answer: Total amount paid - original loan amount=Cell-Cellif loan amount
is negative : =Cell+Cell
◍ Amortization - Assume you made the first (#) payments, you believe you
can sell your car for($) will this cover the balance on the car in period(#)?.
Answer: Is the balance in period(#) less then ($)If No - dont trade in the
carIf Yes - Trade in the car
◍ What feature inserts a function that totals the cells above or to the left of the
selected cell?.
Answer: A. AutoSum
◍ To save a workbook for the first time, you use the Save As dialog box.
Answer: True
◍ Which of the following inserts a function into a cell?.
Answer: B.AutoSum button
◍ To preserve the original version of a workbook so you can make changes to
a copy of it, which of the following would you do?.
Answer: D. Open the workbook, make changes, and then save it using a
different name
◍ If you specify that you want worksheet gridlines to appear on the screen,
they will automatically appear on the printout as well..
Answer: False
◍ four J's painting - Use the HLOOKUP funtion to complete the hourly wage
COLUMN.
Answer: in the first cell of the hourly wage
column=HLOOKUP(Lookup_value, table_array, row_index_num,
[range_lookup)=HLOOKUP(Employee ell, Employee wage info table w/ $,
row that has the money 1 or 2, FALSEDrag column downHourly Wage info
should match in column for horly wage in table
◍ four J's painting - Use the AND function to complete the time bouns
, columnEmployee earns a time bouns of the projects hours worked are fewer
then the estomated hours and if the work quality is grater then 1.
Answer: in the first cell of the time bonus column=AND(logical1,
Logical2)=AND(Hours worked cell<estimated hours cell , quality cell >
1)Drag column down
◍ four J's painting - Use the OR function to complete the outcome bounus
columnemployee earns out come bonus is diff of the job is grater then 3 or if
quality of work is equal to 3.
Answer: in the first cell of the outcome bonus column=OR(logical1,
Logical2)=OR(Diff Cell>3,quality cell >=3)Drag column down
◍ To enter a range of text based on examples that are already in your
worksheet, which of the following can you use?.
Answer: B. Flash fill
◍ Where do you rename a workboard and adjust its save location?.
Answer: A. Save As dialog box
◍ four J's painting - Use the IF function to complete the Time bounus
columNIf the employee earns a time bonus, then "Time Bouus$"is the job
pay for that project, if the value is false 0.
Answer: in the first cell of the outcome Time bonus column=IF( Time bonus
cell =true,job pay cell * bonus percentage cell $, if the value is false 0Drag
column down
◍ four J's painting - Use the IF function to complete the outcome bounus
columnIf the employee earns a outcome bonus, then outcome bouns is the
job pay for that project, if the value is false 0.
Answer: in the first cell of the outcome column=IF( outcome cell =true,job
pay cell * outcome percentage $cell $, if the value is false 0Drag column
down
◍ Which of the following lets you fill a cell with only specific elements of a
copied cell?.
Answer: B. AutoFill options button
