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 3
WGU C268 · Spreadsheets

WGU C268 Practice Questions – Set 3

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 number of periods required to pay off a loan with $250 monthly payments and a total loan of $10,000?

Question 2 of 50

Which feature in Excel will allow you to freeze the first row of a worksheet while scrolling through the rest of the data?

Question 3 of 50

Which formula will return the current date and time in Excel?

Question 4 of 50

Which Excel function calculates the future value of regular monthly payments of $150 over 10 years with a 4% interest rate?

Question 5 of 50

A manager needs to determine how much sales have increased between two periods. Which formula will calculate the difference between sales in cells A1 and B1?

Question 6 of 50

Which function calculates the correlation coefficient between two data arrays in Excel?

Question 7 of 50

A doctor needs to display a filtered list of patients diagnosed with "Flu" from a dataset. What Excel feature should they use?

Question 8 of 50

Which formula would return TRUE if sales in cell B2 are greater than or equal to $1,000?

Question 9 of 50

Which Excel feature would you use to track changes made to a shared workbook by multiple users?

Question 10 of 50

Which formula will correctly calculate the payment for a loan, where the rate is in C13, the number of months is in C12, and the loan amount is in C11?

Question 11 of 50

Which formula will calculate the markup for an item in cell D4 if the cost is in cell C4 and the markup percentage is in A1?

Question 12 of 50

An accountant wants to restrict user input in cell B3 to whole numbers between 1 and 100. Which Excel feature should be used?

Question 13 of 50

A manager tracks the correlation between employee hours and productivity. The correlation coefficient is calculated as 0.65. What does this suggest?

Question 14 of 50

Which Excel function counts the number of sales transactions that exceed $500 in a dataset?

Question 15 of 50

Which of the following is a valid use of a circular reference in an Excel spreadsheet model?

Question 16 of 50

A student wants to track the correlation between hours studied and exam grades in Excel. How should they set this up?

Question 17 of 50

Which formula will calculate the total amount paid for a loan by multiplying the monthly payment in cell C15 by the loan term in cell C12?

Question 18 of 50

Which formula will calculate the interest for period 1 if the loan balance is in F19 and the interest rate is in C13?

Question 19 of 50

An owner wants to know how many orders were placed for a product that sold at least 200 units. Which formula should they use?

Question 20 of 50

Which feature in Excel helps visualize differences in values between categories on a chart?

Question 21 of 50

A client wants to summarize sales data across multiple worksheets named by month abbreviations. Which formula will display the highest sales value for the year?

Question 22 of 50

Which function will calculate the principal payment for a loan by subtracting the interest from the total payment?

Question 23 of 50

A user needs to extract the first 5 characters from a text string in cell A1. Which formula should be used?

Question 24 of 50

Which Excel function allows users to sum values based on a condition, such as summing all sales greater than $500?

Question 25 of 50

Which Excel feature allows users to filter data by adding a button to each column header that can be used to hide or show rows based on certain criteria?

Question 26 of 50

An employee wants to display all the data related to "Manufacturing" in a table with different industry types. What steps should they take?

Question 27 of 50

Which of the following features allows users to add additional filtering to a data field in a PivotTable?

Question 28 of 50

Which of the following chart types can be used to show the percentage breakdown of total sales for different products?

Question 29 of 50

A manager wants to know the total number of employees who have worked more than 40 hours in a week. Which formula should be used?

Question 30 of 50

A PivotTable is used to calculate the total sales for each department. Which feature allows users to filter the data in the PivotTable based on department names?

Question 31 of 50

Which Excel formula will return "Passed" if a student scored more than 60 in cell B2 and "Failed" otherwise?

Question 32 of 50

An analyst wants to calculate the total revenue from products that sold more than 100 units. Which formula should they use?

Question 33 of 50

A business owner tracks monthly sales in columns A through L. Which formula will return the total sales for the year?

Question 34 of 50

Which Excel feature helps create a concise report showing the total sales by product in a summarized format?

Question 35 of 50

A client wants to calculate the present value of future payments of $500 each month for 2 years, at a 5% interest rate. Which function should they use?

Question 36 of 50

Which formula will return the number of unique inventory items in a list that have a quantity greater than zero?

Question 37 of 50

A bank offers several different loan interest rates. Which tool should be used to create a scenario report showing the payments for each option?

Question 38 of 50

A customer wants to calculate the maximum amount they can borrow with a $500 monthly payment for 2 years. Which Excel function should be used?

Question 39 of 50

Which formula will count the number of cells in a range that contain a text string such as "Yes"?

Question 40 of 50

A manager wants to calculate the total number of touch-ups performed on jobs with a difficulty rating of 3 or higher. Which function should be used?

Question 41 of 50

Which function calculates the number of payments required to pay off a $15,000 loan with monthly payments of $300 and an interest rate of 4%?

Question 42 of 50

Which Excel function returns the rightmost 10 digits from a text string in cell A1?

Question 43 of 50

A sales manager wants to identify which sales representatives have met their monthly sales targets. Which formula would return "Met Target" if the value in cell B2 is greater than or equal to 10,000 and "Missed Target" otherwise?

Question 44 of 50

A business owner tracks sales for multiple products and wants to calculate the total for products that sold more than 50 units. Which formula should be used?

Question 45 of 50

Which function will calculate the percentage of total sales for each product in a table, based on the product's sales value divided by the total sales?

Question 46 of 50

Which feature allows you to protect a worksheet from being modified by other users?

Question 47 of 50

An administrator needs to track changes made to an Excel workbook shared with multiple users. Which tool should they use to monitor updates?

Question 48 of 50

A financial analyst needs to predict future sales based on past performance. Which function should be used to forecast the sales of a product?

Question 49 of 50

Which Excel function will return the day portion of a date stored in cell B1?

Question 50 of 50

A user needs to extract the month from a date value stored in cell B1. Which function should they use?

Set 3 complete

You scored 0%

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

Next: Set 4

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