Skip to content
Pass Any WGU OA Exam Now & Pay After You Pass. Contact Us!
  1. Home
  2. WGU Exams
  3. WGU C268
  4. Set 2
WGU C268 · Spreadsheets

WGU C268 Practice Questions – Set 2

50 multiple-choice questions with answers and detailed explanations. Untimed — choose an answer to check it instantly.

Question 1 of 50

Which Excel function calculates the monthly payment for a loan based on constant payments and a constant interest rate?

Question 2 of 50

Which formula will correctly calculate the difference between the total amount paid over a loan and the original loan amount?

Question 3 of 50

Which function will provide the present value of an investment when given the interest rate, number of periods, and payment?

Question 4 of 50

Which two tools are found in the Review tab of Excel and can be used for protecting and managing changes in a worksheet?

Question 5 of 50

A student is calculating the correlation between study hours and exam scores using Excel. Which function should they use?

Question 6 of 50

Which Excel feature will allow you to display the number $3.10 in a cell?

Question 7 of 50

Which of the following functions will count the total number of employees in a table who worked more than 40 hours?

Question 8 of 50

Which formula will calculate the principal amount for the first period in an amortization schedule?

Question 9 of 50

Which Excel function allows you to automatically populate the "Hourly Wage" column by looking up the employee name in a reference table?

Question 10 of 50

Which formula correctly calculates the payment for a loan, assuming the rate is in cell C13, the term is in C12, and the loan amount is in C11?

Question 11 of 50

A manager wants to determine how much money a customer will have after saving $100 per month for two years at a 5% interest rate. Which function should they use?

Question 12 of 50

A doctor tracks patient diagnoses in a report and wants to filter the data to show only patients diagnosed with a specific illness. What tool should they use?

Question 13 of 50

Which Excel formula will calculate the interest amount for the first period of a loan if the balance in period 0 is in cell F19 and the loan interest rate is in cell C13?

Question 14 of 50

A grocery store wants to track how many products sold at least 500 units. Which function will accomplish this?

Question 15 of 50

An analyst is calculating the sales forecast for each product if expected attendance is 18,000 people. Which function should they use?

Question 16 of 50

Which function will count the number of responses in a survey that contain an age, where non-responses are marked with an "N"?

Question 17 of 50

A restaurant tracks daily sales. Which formula will return the total sales for days that exceeded $10,000?

Question 18 of 50

Which Excel feature should you use to prevent users from entering invalid data in a specific cell?

Question 19 of 50

Which formula will return the text "On Track" if the number of appointments in cell B2 is greater than or equal to 10 and "Off Track" if it is less than 10?

Question 20 of 50

Which Excel function is used to calculate the total amount of sales, where the quantity in each row is greater than zero?

Question 21 of 50

A spreadsheet tracks loan payments. Which formula would you use to calculate the number of monthly payments required to pay off a loan of $10,000 at $200 per month over five years?

Question 22 of 50

Which function will provide the total interest paid over the course of a loan, based on a list of monthly interest payments?

Question 23 of 50

A sales manager wants to know which formulas reference a specific cell, such as B2. Which tool should they use?

Question 24 of 50

Which formula would be used to find the average sales for the days when sales exceeded $10,000?

Question 25 of 50

Which formula will calculate the salary expenses based on the number of employees and their individual salaries?

Question 26 of 50

An analyst needs to determine how much more food sales were generated at concerts compared to other events. Which formula should they use?

Question 27 of 50

Which formula should be used to calculate the total sales for the 4th quarter of the year, with monthly sales in cells B2, B3, and B4?

Question 28 of 50

An employee tracks the correlation between the number of hours worked and job performance. The correlation coefficient is 0.5. What does this suggest?

Question 29 of 50

A business tracks sales for multiple products. Which formula will return the minimum sales for a given range?

Question 30 of 50

An Excel model uses multiple inputs that change frequently. Which feature is useful for evaluating different scenarios within the model?

Question 31 of 50

A client wants to borrow $10,000 with monthly payments of $250. Which function will calculate the maximum annual interest rate that satisfies this payment schedule?

Question 32 of 50

A table contains data for sales reps and their total sales. Which formula will sum the sales for a specific rep, such as Rep B?

Question 33 of 50

A bank offers several loan interest rate options. Which Excel tool would allow a user to compare the total monthly payments across all options?

Question 34 of 50

Which formula will display "Y" for sales greater than or equal to $3,000 and "N" for sales below $3,000?

Question 35 of 50

A doctor wants to know how many patients have been diagnosed with a specific illness. Which function will filter the list of patients by diagnosis?

Question 36 of 50

Which feature of Excel should be used to track the percentage of sales attributed to each product in a pie chart?

Question 37 of 50

A student wants to align all text to the left in an Excel worksheet. Which group on the Home Tab should they use?

Question 38 of 50

Which two options are available in Solver’s parameter dialog window for optimization analysis?

Question 39 of 50

An Excel model includes formulas that reference other worksheets. What tool can be used to verify the cells referenced in these formulas?

Question 40 of 50

A table contains a list of sales for multiple products. Which formula will return the average sales for products that sold more than 100 units?

Question 41 of 50

Which function would calculate the maximum monthly sales for a range of data covering multiple months?

Question 42 of 50

Which feature in Excel allows you to add an additional filter to a data field in a PivotTable?

Question 43 of 50

Which formula will display "Good Job" if both the hours worked are less than the estimated hours and the quality is greater than 1?

Question 44 of 50

An analyst uses the CORREL function and gets a coefficient of 0.274 between two variables. What type of relationship does this indicate?

Question 45 of 50

An employee earns an outcome bonus if the difficulty of the job is greater than 3 or the quality of their work equals 3. Which formula will calculate the outcome bonus eligibility?

Question 46 of 50

A company tracks sales data for different departments. Which Excel feature should be used to create a report showing gross pay by department?

Question 47 of 50

Which feature in Excel allows you to visualize the differences in data between categories in a chart?

Question 48 of 50

An owner wants to display the monthly sales tax based on a rate of 7.5% of total sales. Which formula will calculate the sales tax if monthly sales are in cells A1 to L1?

Question 49 of 50

A manager wants to calculate the percentage of total sales each product contributes to a company’s overall sales. Which chart type should be used?

Question 50 of 50

Which formula will calculate how many employees are eligible for a time bonus, based on whether they worked fewer hours than estimated and their work quality exceeded 1?

Set 2 complete

You scored 0%

0 correct out of 0 answered (50 questions in this set).

Next: Set 3

Struggling with WGU C268?

If this exam is giving you a hard time, let us be your helping hand. Contact us, and we'll provide the assistance you need to pass and move forward.

Chat Now