NUR 354 2 ACTUAL EXAM PAPER 2026
QUESTIONS WITH ANSWERS GRADED
A+
◍ Match the way information can be displayed in a spreadsheet with the type
of information to be displayed..
Answer: In rows: 5,6 and 7In columns: AA, BB, CAIn clip art: Images
◍ Calculate the payment amount for the loan in cell C15. Reference the cells
containing the appropriate loan information as the arguments for the
function you use. Cells C20-C67 in the "Payment" column are populated
with the payment amount from cell C15..
Answer: =PMT(C13/12,C12,C11)
◍ Calculate, in cell D20, the interest amount for period 1 by multiplying the
balance in period 0 (cell F19) by the loan interest rate (cell C13) divided by
12. Dividing the interest rate by 12 results in the 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.f.
Answer: =F19*C$13/12
◍ Copy the Interest amount calcualtion down to complete the "interest"
column of the amortization table..
Answer: Paste down column .
◍ What is a possible outcome using Boolean Logic?.
Answer: Only the numbers 0 and 1.
◍ What is possible in freeze panes?.
Answer: Freezing the row above where a person is working.
◍ Match the category with its type of function..
, Answer: Logical: AND, NOR, ORAuto Sum: COUNT, NUMBER,
MAXDate and Time: WEEKNUM, WEEKDAYFinancial: DURATION,
COUPDAYS, EFFECT
◍ What is true about correlation coefficients when using the CORREL
function in Excel?.
Answer: They can be a negative number.
◍ What two options are possible under "review" on the Excel ribbon?.
Answer: Track ChangesProtect Sheet
◍ Calculate, in cell E20, the principal amount for period 1. The principal
amount is the difference between the payment amount (cell C20) and the
interest amount (cell D20) for period 1. Construct your formula in such a
way that it can be reused to complete the "principal" column of the
amortization table..
Answer: =C20-D20
◍ An administer wishes to display the number $3.10 in Cell A4. How can this
goal be met?.
Answer: Select A4, select the currency category, then enter the number 3.1.
◍ A student noted a correlation between hours of studying and test grades. The
student decides to track this correlation using the CORREL function in
Excel. How should this be set up?.
Answer: By setting up hours in array A and grades in array B, and the using
the CORREL function.
◍ Copy the principal amount calculation down to complete the "principal"
column of the amortization table..
Answer: Copy and paste down.
◍ A student wants to have text appear in Excel as it would in a business
document, with all of the text starting on the left-hand side.Which group on
the homepage should be used to accomplish this goal?.
Answer: Alignment
, ◍ A manager has a spreadsheet table with company name, stock prices and
sales dollars. What should the manager do to sort this table by name and
then by sales dollars, from largest to smallest?.
Answer: Click anywhere in the table, click the sort icon, click the name in
the sort by drop box, then click "then by", and choose "sales dollars largest
to smallest".
◍ Calculate, in cell F20, the balance for period 1. The balance is the difference
between the balance for period 0 (cell F19) and the principal amount for
period 1 (cell E20). This formula is reusable. The balance is always
calculated as the difference between the balance from the previous period
and the principal amount for the current period..
Answer: =F19-E20
◍ Copy the balance amount calculation down to complete the balance column
of the amortization table..
Answer: Copy and paste down.
◍ Calculate, in cell G12, the total amount paid by multiplying the payment
amount (cell C15) by the term of the loan (cell C12)..
Answer: =C15*C12
◍ Calculate the total interest paid in cell G13. The total interest paid is the sum
of all interest paid in the "Interest" column of the amortization table..
Answer: =SUM(D20:D67)
◍ The following data is in an Excel spreadsheet:Company A - Manufacturing -
$22,000,000Company B - Industrial - $12,000,000Company C -
Manufacturing - $14,000,000Which steps display only the information for
the Manufacturing Industry?.
Answer: Click anywhere in the table, click the filter button, click the down
arrow next to "industry", and then select "Manufacturing".
◍ A doctor wants to know how many patients she has seen this month and
their diagnoses. The doctor's assistant puts together a report showing each
patients name in column A and diagnosis in column
QUESTIONS WITH ANSWERS GRADED
A+
◍ Match the way information can be displayed in a spreadsheet with the type
of information to be displayed..
Answer: In rows: 5,6 and 7In columns: AA, BB, CAIn clip art: Images
◍ Calculate the payment amount for the loan in cell C15. Reference the cells
containing the appropriate loan information as the arguments for the
function you use. Cells C20-C67 in the "Payment" column are populated
with the payment amount from cell C15..
Answer: =PMT(C13/12,C12,C11)
◍ Calculate, in cell D20, the interest amount for period 1 by multiplying the
balance in period 0 (cell F19) by the loan interest rate (cell C13) divided by
12. Dividing the interest rate by 12 results in the 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.f.
Answer: =F19*C$13/12
◍ Copy the Interest amount calcualtion down to complete the "interest"
column of the amortization table..
Answer: Paste down column .
◍ What is a possible outcome using Boolean Logic?.
Answer: Only the numbers 0 and 1.
◍ What is possible in freeze panes?.
Answer: Freezing the row above where a person is working.
◍ Match the category with its type of function..
, Answer: Logical: AND, NOR, ORAuto Sum: COUNT, NUMBER,
MAXDate and Time: WEEKNUM, WEEKDAYFinancial: DURATION,
COUPDAYS, EFFECT
◍ What is true about correlation coefficients when using the CORREL
function in Excel?.
Answer: They can be a negative number.
◍ What two options are possible under "review" on the Excel ribbon?.
Answer: Track ChangesProtect Sheet
◍ Calculate, in cell E20, the principal amount for period 1. The principal
amount is the difference between the payment amount (cell C20) and the
interest amount (cell D20) for period 1. Construct your formula in such a
way that it can be reused to complete the "principal" column of the
amortization table..
Answer: =C20-D20
◍ An administer wishes to display the number $3.10 in Cell A4. How can this
goal be met?.
Answer: Select A4, select the currency category, then enter the number 3.1.
◍ A student noted a correlation between hours of studying and test grades. The
student decides to track this correlation using the CORREL function in
Excel. How should this be set up?.
Answer: By setting up hours in array A and grades in array B, and the using
the CORREL function.
◍ Copy the principal amount calculation down to complete the "principal"
column of the amortization table..
Answer: Copy and paste down.
◍ A student wants to have text appear in Excel as it would in a business
document, with all of the text starting on the left-hand side.Which group on
the homepage should be used to accomplish this goal?.
Answer: Alignment
, ◍ A manager has a spreadsheet table with company name, stock prices and
sales dollars. What should the manager do to sort this table by name and
then by sales dollars, from largest to smallest?.
Answer: Click anywhere in the table, click the sort icon, click the name in
the sort by drop box, then click "then by", and choose "sales dollars largest
to smallest".
◍ Calculate, in cell F20, the balance for period 1. The balance is the difference
between the balance for period 0 (cell F19) and the principal amount for
period 1 (cell E20). This formula is reusable. The balance is always
calculated as the difference between the balance from the previous period
and the principal amount for the current period..
Answer: =F19-E20
◍ Copy the balance amount calculation down to complete the balance column
of the amortization table..
Answer: Copy and paste down.
◍ Calculate, in cell G12, the total amount paid by multiplying the payment
amount (cell C15) by the term of the loan (cell C12)..
Answer: =C15*C12
◍ Calculate the total interest paid in cell G13. The total interest paid is the sum
of all interest paid in the "Interest" column of the amortization table..
Answer: =SUM(D20:D67)
◍ The following data is in an Excel spreadsheet:Company A - Manufacturing -
$22,000,000Company B - Industrial - $12,000,000Company C -
Manufacturing - $14,000,000Which steps display only the information for
the Manufacturing Industry?.
Answer: Click anywhere in the table, click the filter button, click the down
arrow next to "industry", and then select "Manufacturing".
◍ A doctor wants to know how many patients she has seen this month and
their diagnoses. The doctor's assistant puts together a report showing each
patients name in column A and diagnosis in column
