NUR 354 2 PRACTICE EXAMINATION
2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ In the "Input Analysis" section of the spreadsheet model, calculate the
sample standard deviation for attendance and sales for each type of product
from the past events listed on the "Past Events" worksheet. (Note for Excel
2007 users: Excel 2007 does not support a specific function to calculate
sample standard deviations. Use the STDEV function instead.).
Answer: =STDEV.S('Past Events'!C4:C103)=STDEV.S('Past
Events'!D4:D103)=STDEV.S('Past Events'!E4:E103)=STDEV.S('Past
Events'!F4:F103)
◍ Use the SUMIF function to complete the "Total Pay" column in table 3.
Reference the "Employee" field in table 1 as your range, the "Employee"
names in table 3 as your criteria, and the "Total Pay" field in table 1 as your
sum_range..
Answer: =SUMIF($D$16:$D$35,G39,N16:N35)looks in table range
D16-D35, looks for value from G39, Adds the number from table range
N16-N35
◍ Embedded Chart.
Answer: A chart inserted in the center of the worksheet.
◍ Use the CONCAT function (or the CONCATENATE function if you are
using Excel 2013 or earlier) to create the "Transaction Statement" in cell
K18. The statement in cell K18 should read "I spent $24.06 at merchant
#4931 on: 8/1". To make this statement, combine "Statement P1" in cell
D13, the "Amount" in cell D18, "Statement P2" in cell D14, the "Merchant
ID" in cell C18, "Statement P3" in cell D15, and the "Date" in cell J18.
Copy and paste your function down to complete the "Transaction
, Statement" column of the table. [.
Answer: =CONCATENATE($D$13,D18,$D$14,C18,$D$15,J18)Combines,
absolute D13, with D18, and absolute D14, and C18, and absolute D15, and
J18.
◍ Use the AND function to complete the "Time Bonus?" column of table 1.
An employee earns a time bonus if the project's "Hours Worked" are fewer
than the "Estimated Hours" and if the work "Quality" is greater than 1..
Answer: =AND(E16<C16,H16>1)And used when all logical functions are
true. (E16 greater than C16, AND H16 greater than 1)
◍ 1. 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)Payment
◍ Month.
Answer: =MONTH(J21)
◍ Days since last.
Answer: =DATEDIF(J21,J27,"D")
◍ Plot Area.
Answer: The graphical representation of all of the data series.
◍ Pie Chart.
Answer: A chart that shows the relationship of a part to a whole.
◍ Use the COUNTIF function to complete the "# of Jobs" column in table 3.
Reference the appropriate field in table 1 as your range and the "Employee"
names in table 3 as your criteria..
Answer: =COUNTIF($D$16:$D$35,G39)Counts the occurrences in range
D16-D35, looks for the value in G39.
◍ In the "Input Analysis" section of the spreadsheet model, calculate the
correlations between the sales of each type of product and event attendance.
2026 QUESTIONS WITH ANSWERS
GRADED A+
◍ In the "Input Analysis" section of the spreadsheet model, calculate the
sample standard deviation for attendance and sales for each type of product
from the past events listed on the "Past Events" worksheet. (Note for Excel
2007 users: Excel 2007 does not support a specific function to calculate
sample standard deviations. Use the STDEV function instead.).
Answer: =STDEV.S('Past Events'!C4:C103)=STDEV.S('Past
Events'!D4:D103)=STDEV.S('Past Events'!E4:E103)=STDEV.S('Past
Events'!F4:F103)
◍ Use the SUMIF function to complete the "Total Pay" column in table 3.
Reference the "Employee" field in table 1 as your range, the "Employee"
names in table 3 as your criteria, and the "Total Pay" field in table 1 as your
sum_range..
Answer: =SUMIF($D$16:$D$35,G39,N16:N35)looks in table range
D16-D35, looks for value from G39, Adds the number from table range
N16-N35
◍ Embedded Chart.
Answer: A chart inserted in the center of the worksheet.
◍ Use the CONCAT function (or the CONCATENATE function if you are
using Excel 2013 or earlier) to create the "Transaction Statement" in cell
K18. The statement in cell K18 should read "I spent $24.06 at merchant
#4931 on: 8/1". To make this statement, combine "Statement P1" in cell
D13, the "Amount" in cell D18, "Statement P2" in cell D14, the "Merchant
ID" in cell C18, "Statement P3" in cell D15, and the "Date" in cell J18.
Copy and paste your function down to complete the "Transaction
, Statement" column of the table. [.
Answer: =CONCATENATE($D$13,D18,$D$14,C18,$D$15,J18)Combines,
absolute D13, with D18, and absolute D14, and C18, and absolute D15, and
J18.
◍ Use the AND function to complete the "Time Bonus?" column of table 1.
An employee earns a time bonus if the project's "Hours Worked" are fewer
than the "Estimated Hours" and if the work "Quality" is greater than 1..
Answer: =AND(E16<C16,H16>1)And used when all logical functions are
true. (E16 greater than C16, AND H16 greater than 1)
◍ 1. 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)Payment
◍ Month.
Answer: =MONTH(J21)
◍ Days since last.
Answer: =DATEDIF(J21,J27,"D")
◍ Plot Area.
Answer: The graphical representation of all of the data series.
◍ Pie Chart.
Answer: A chart that shows the relationship of a part to a whole.
◍ Use the COUNTIF function to complete the "# of Jobs" column in table 3.
Reference the appropriate field in table 1 as your range and the "Employee"
names in table 3 as your criteria..
Answer: =COUNTIF($D$16:$D$35,G39)Counts the occurrences in range
D16-D35, looks for the value in G39.
◍ In the "Input Analysis" section of the spreadsheet model, calculate the
correlations between the sales of each type of product and event attendance.
