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

WGU C268 Practice Questions – Set 4

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

Question 1 of 50

A spreadsheet contains sales data for different months. Which formula will return the minimum monthly sales?

Question 2 of 50

Which formula will correctly calculate the monthly interest for a loan if the loan balance is in F10 and the annual interest rate is in C5?

Question 3 of 50

A student wants to calculate the average exam score for students who scored above 75. Which formula should they use?

Question 4 of 50

A business owner wants to display only the sales data for the "Manufacturing" industry from a large table. Which Excel feature should they use?

Question 5 of 50

Which Excel function would calculate the payment required for a $10,000 loan over five years with monthly payments of $200?

Question 6 of 50

Which Excel function calculates the total number of periods required to pay off a loan if the loan amount is in C10 and monthly payments are in C11?

Question 7 of 50

Which formula would calculate the monthly sales tax for each month, based on a 7% tax rate stored in cell B2 and total monthly sales in cells A1 through L1?

Question 8 of 50

A table contains data for employees and their total work hours. Which function will count the number of employees who worked more than 40 hours?

Question 9 of 50

A manager needs to calculate the total sales for products that sold more than 500 units. Which formula will accomplish this?

Question 10 of 50

Which Excel function will return the last 5 digits from a text string in cell A2?

Question 11 of 50

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

Question 12 of 50

Which Excel function counts the number of entries in a dataset that are greater than or equal to 100?

Question 13 of 50

A doctor wants to count the number of patients diagnosed with "Allergy" in a dataset. Which function should they use?

Question 14 of 50

A client wants to calculate the total interest paid over the course of a loan. Which formula should they use?

Question 15 of 50

A manager needs to identify the highest sales amount for the year. Which formula will return the maximum value from a list of sales data?

Question 16 of 50

A doctor wants to track how many patients have been diagnosed with "Flu" over the last 12 months. Which feature should they use to filter the data?

Question 17 of 50

A sales team tracks the total number of units sold each month. Which formula will calculate the average number of units sold per month?

Question 18 of 50

A student wants to calculate the percentage of total points they scored in a course. Which formula will return the correct percentage if their score is in cell A2 and the total points possible is in B2?

Question 19 of 50

Which Excel function returns the number of days between two dates?

Question 20 of 50

A manager wants to calculate the gross profit for a product, which is the sales amount minus the cost of goods sold (COGS). Which formula will calculate this if sales are in C15 and COGS are in C16?

Question 21 of 50

A student tracks their daily study hours and grades in Excel. Which function calculates the correlation coefficient between these two variables?

Question 22 of 50

A business wants to track sales performance for different products over time. Which Excel feature allows them to summarize sales data by product in a report?

Question 23 of 50

A business wants to protect certain cells in a worksheet from being modified by other users. Which feature should they use?

Question 24 of 50

A manager wants to calculate the payment required for a $10,000 loan over five years with monthly payments of $200. Which formula will return the correct result?

Question 25 of 50

A sales team wants to calculate the average sales for employees who met or exceeded their monthly sales target of $5,000. Which formula will accomplish this?

Question 26 of 50

A store wants to display the total sales for items that sold at least 300 units. Which formula should they use?

Question 27 of 50

A client wants to calculate the maximum amount they can borrow with $200 monthly payments for 3 years at a 5% interest rate. Which function will help them determine this?

Question 28 of 50

Which function will calculate the number of payments required to pay off a loan if the loan amount is $8,000 with monthly payments of $250 and an interest rate of 6%?

Question 29 of 50

A sales manager wants to calculate the percentage of sales attributed to each salesperson. Which formula will calculate this if the product’s sales are in A1 and the total sales are in B1?

Question 30 of 50

A team tracks their performance against monthly targets. Which Excel feature would help display whether each employee met their target in a visual way?

Question 31 of 50

A user wants to display the number of unique entries in a dataset. Which function should they use?

Question 32 of 50

Which formula will return the current date in Excel?

Question 33 of 50

A doctor wants to calculate the percentage of patients diagnosed with a specific illness. Which formula should they use if the total number of patients is in A1 and the number diagnosed with the illness is in B1?

Question 34 of 50

Which feature in Excel allows users to prevent specific cells from being modified?

Question 35 of 50

A manager wants to calculate the gross profit for a product if the sales amount is in C5 and the cost of goods sold is in C6. Which formula will return the correct result?

Question 36 of 50

A doctor wants to track the percentage of patients diagnosed with a specific illness. Which formula should they use if the total number of patients is in A1 and the number diagnosed with the illness is in B1?

Question 37 of 50

Which feature in Excel allows users to highlight cells that contain values meeting specific criteria, such as sales below a certain threshold?

Question 38 of 50

A manager wants to calculate the total commission for a salesperson if the sales amount is in C5 and the commission rate is in C6. Which formula will return the correct result?

Question 39 of 50

Which function calculates the number of products sold based on the sales data in cells A1 through A10?

Question 40 of 50

A client wants to calculate the monthly payment for a loan. Which Excel function should they use?

Question 41 of 50

A store wants to count the number of items sold that cost more than $50. Which function should they use?

Question 42 of 50

A user wants to calculate the number of months it will take to pay off a loan of $20,000 with monthly payments of $500. Which function will return the correct result?

Question 43 of 50

Which Excel function calculates the total value of sales based on specific criteria, such as sales greater than $1,000?

Question 44 of 50

A manager wants to calculate the total commissions paid to sales representatives if the commission percentage is stored in cell B5 and the sales amount is in B6. Which formula will return the correct result?

Question 45 of 50

A user wants to calculate the difference between two dates in terms of days. Which function should they use?

Question 46 of 50

A manager wants to calculate the total salary expenses for a project based on the number of employees required and the salary per employee. Which formula will return the correct result?

Question 47 of 50

In a spreadsheet formula, which reference stays fixed when the formula is copied to other cells?

Question 48 of 50

Which function returns the average of the values in cells B2 through B10?

Question 49 of 50

Which feature summarizes large amounts of data by grouping and aggregating it interactively?

Question 50 of 50

What does the formula =IF(C2>=70,"Pass","Fail") return when C2 contains 65?

Set 4 complete

You scored 0%

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

Next: Set 5

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