WGU C268 SPREADSHEETS FINAL OA
COMPLETE QUESTIONS AND ANSWERS
GRADED A+
◉ Which two formulas count the number of unique part numbers
with a quantity >0
Answer: =COUNTA (B2,B3,B4,B5,B,6,B7,B8)
=COUNTA (B2:B8)
◉ Which formula reflects the present value of the investment? B1
- Rate 5%, B2- Years 30, B3 - Monthly Payment $125.00
Answer: PV(rate, nper, pmt)
=PV(5%/12,(30x12),15)
=PV(B1/12,B2*12,B3)
Rate - the interest rate, per period
NPER - the number of periods for the lifetime of the annuity or
investment
PMT - an optional argument that specifies the payment per
period.
◉ The commission rate is stored in cell B2, the commission
dollars are in cells D5 through D20. The formulas to calculate the
commission amount is in cells E5 through E20. The sales manager
, does not believe the commission amounts is correct and wants to
know which formulas reference cell B2. Which steps should the
sales manager take to get the desired information?
Answer: Click on the Formulas tab, click cell B2, and then click the
Trace Precedents icon
◉ The owner of a small retail store wants to pay her sales tax,
which is 7.5% of her total sales. Her spreadsheet shows monthly
sales in cells A20 through L20. The sales tax rate is located in cell
B2 (7.5%). The formula to calculate sales tax for each month is
located in cells A21 through L 21. What should be done with cell
B2 to verify the correct sales tax rate is used for each month?
Answer: Click cell B2, click the Formulas tab, and then click "Trace
Dependents"
◉ Cell D21 contains total sales for the current year. Cell E21
contains sales for the previous year. Cell F21 contains the
difference between the two years. Cell F21 contains a negative
number. The sales clerk knows that this is wrong, because sales
increased by $10,000 in the current year, and the clerk wants to
see which cells are in the formula for Cell F21. How can the clerk
meet this goal?
Answer: Click in F21, select the formulas tab and then select the
trace precedents icon.
◉ Cells A1 through A4 contain the values 20, 30, 40, and 50
respectively. Which two options result in an answer of TRUE being
displayed?
COMPLETE QUESTIONS AND ANSWERS
GRADED A+
◉ Which two formulas count the number of unique part numbers
with a quantity >0
Answer: =COUNTA (B2,B3,B4,B5,B,6,B7,B8)
=COUNTA (B2:B8)
◉ Which formula reflects the present value of the investment? B1
- Rate 5%, B2- Years 30, B3 - Monthly Payment $125.00
Answer: PV(rate, nper, pmt)
=PV(5%/12,(30x12),15)
=PV(B1/12,B2*12,B3)
Rate - the interest rate, per period
NPER - the number of periods for the lifetime of the annuity or
investment
PMT - an optional argument that specifies the payment per
period.
◉ The commission rate is stored in cell B2, the commission
dollars are in cells D5 through D20. The formulas to calculate the
commission amount is in cells E5 through E20. The sales manager
, does not believe the commission amounts is correct and wants to
know which formulas reference cell B2. Which steps should the
sales manager take to get the desired information?
Answer: Click on the Formulas tab, click cell B2, and then click the
Trace Precedents icon
◉ The owner of a small retail store wants to pay her sales tax,
which is 7.5% of her total sales. Her spreadsheet shows monthly
sales in cells A20 through L20. The sales tax rate is located in cell
B2 (7.5%). The formula to calculate sales tax for each month is
located in cells A21 through L 21. What should be done with cell
B2 to verify the correct sales tax rate is used for each month?
Answer: Click cell B2, click the Formulas tab, and then click "Trace
Dependents"
◉ Cell D21 contains total sales for the current year. Cell E21
contains sales for the previous year. Cell F21 contains the
difference between the two years. Cell F21 contains a negative
number. The sales clerk knows that this is wrong, because sales
increased by $10,000 in the current year, and the clerk wants to
see which cells are in the formula for Cell F21. How can the clerk
meet this goal?
Answer: Click in F21, select the formulas tab and then select the
trace precedents icon.
◉ Cells A1 through A4 contain the values 20, 30, 40, and 50
respectively. Which two options result in an answer of TRUE being
displayed?
