WGU C268 FINAL EXAM Study Guide for EXCEL PA |2025-2026 LATEST
UPDATED|REAL EXAM COMPLETE QUESTIONS AND ANSWERS | 100%
RATED CORRECT | 100% VERFIED | ALREADY GRADED A+
1. Which Excel function calculates the monthly payment for a loan?
A) PV
B) PMT
C) NPER
D) RATE
Answer: B
Rationale: PMT calculates payment for a loan based on constant interest and time.
2. In an amortization table, the formula to calculate interest for a given month is:
A) =Balance * Rate
B) =Balance * Rate / 12
C) =PMT * Rate
D) =Balance / Rate
Answer: B
Rationale: Interest per month is the remaining balance times the annual interest rate divided by
12.
3. Which chart type is best for comparing monthly sales across multiple categories?
A) Line chart
B) Clustered column chart
C) Pie chart
D) Scatter plot
Answer: B
,Rationale: Clustered columns compare multiple data series across discrete categories.
4. What is the purpose of using Absolute References (e.g., $B$2) in formulas?
A) To allow formulas to adjust when copied
B) To keep the reference fixed when copying formulas
C) To apply conditional formatting
D) To create a range name
Answer: B
Rationale: Absolute references lock the cell so it does not change when copied.
5. Which function is most appropriate to sum sales for a specific product category?
A) COUNTIF
B) VLOOKUP
C) SUMIF
D) HLOOKUP
Answer: C
Rationale: SUMIF adds values in a range based on a single condition.
6. In a pivot table, what does the “Values” area control?
A) The filter applied
B) The row labels displayed
C) The data calculations performed
D) The column headers shown
Answer: C
Rationale: The Values area determines what data is summarized and how it’s calculated.
, 7. The What-If Analysis tool in Excel that finds an input value to achieve a desired result is:
A) Scenario Manager
B) Data Table
C) Goal Seek
D) Solver
Answer: C
Rationale: Goal Seek changes an input to reach a specific output.
8. Which function retrieves data from a table based on a row heading and column index?
A) INDEX
B) HLOOKUP
C) MATCH
D) VLOOKUP
Answer: D
Rationale: VLOOKUP searches for a value in the first column and returns data from a specified
column.
9. What’s the correct formula to calculate remaining loan balance in an amortization schedule?
A) =PreviousBalance - CurrentPrincipal
B) =PreviousBalance - CurrentInterest
C) =PMT - CurrentPrincipal
D) =CurrentPrincipal - PreviousBalance
Answer: A
Rationale: Balance decreases each month by the principal paid.
10. Which keyboard shortcut is used to insert the current date into a cell?
A) CTRL + ;
B) CTRL + SHIFT + ;
UPDATED|REAL EXAM COMPLETE QUESTIONS AND ANSWERS | 100%
RATED CORRECT | 100% VERFIED | ALREADY GRADED A+
1. Which Excel function calculates the monthly payment for a loan?
A) PV
B) PMT
C) NPER
D) RATE
Answer: B
Rationale: PMT calculates payment for a loan based on constant interest and time.
2. In an amortization table, the formula to calculate interest for a given month is:
A) =Balance * Rate
B) =Balance * Rate / 12
C) =PMT * Rate
D) =Balance / Rate
Answer: B
Rationale: Interest per month is the remaining balance times the annual interest rate divided by
12.
3. Which chart type is best for comparing monthly sales across multiple categories?
A) Line chart
B) Clustered column chart
C) Pie chart
D) Scatter plot
Answer: B
,Rationale: Clustered columns compare multiple data series across discrete categories.
4. What is the purpose of using Absolute References (e.g., $B$2) in formulas?
A) To allow formulas to adjust when copied
B) To keep the reference fixed when copying formulas
C) To apply conditional formatting
D) To create a range name
Answer: B
Rationale: Absolute references lock the cell so it does not change when copied.
5. Which function is most appropriate to sum sales for a specific product category?
A) COUNTIF
B) VLOOKUP
C) SUMIF
D) HLOOKUP
Answer: C
Rationale: SUMIF adds values in a range based on a single condition.
6. In a pivot table, what does the “Values” area control?
A) The filter applied
B) The row labels displayed
C) The data calculations performed
D) The column headers shown
Answer: C
Rationale: The Values area determines what data is summarized and how it’s calculated.
, 7. The What-If Analysis tool in Excel that finds an input value to achieve a desired result is:
A) Scenario Manager
B) Data Table
C) Goal Seek
D) Solver
Answer: C
Rationale: Goal Seek changes an input to reach a specific output.
8. Which function retrieves data from a table based on a row heading and column index?
A) INDEX
B) HLOOKUP
C) MATCH
D) VLOOKUP
Answer: D
Rationale: VLOOKUP searches for a value in the first column and returns data from a specified
column.
9. What’s the correct formula to calculate remaining loan balance in an amortization schedule?
A) =PreviousBalance - CurrentPrincipal
B) =PreviousBalance - CurrentInterest
C) =PMT - CurrentPrincipal
D) =CurrentPrincipal - PreviousBalance
Answer: A
Rationale: Balance decreases each month by the principal paid.
10. Which keyboard shortcut is used to insert the current date into a cell?
A) CTRL + ;
B) CTRL + SHIFT + ;
