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

WGU C268 Practice Questions – Set 5

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

Question 1 of 50

A manager needs to know how many employees worked fewer than 40 hours in a week. Which formula will provide this information?

Question 2 of 50

Which Excel function would you use to return the day of the month from a date stored in cell A2?

Question 3 of 50

A business owner wants to calculate the future value of monthly savings of $200 over 5 years with a 3% interest rate. Which function should they use?

Question 4 of 50

A manager wants to determine the total number of items sold that exceeded 100 units. Which formula should they use?

Question 5 of 50

Which formula will calculate the difference between total sales in cells A1 and B1?

Question 6 of 50

Which Excel function would calculate the number of periods required to pay off a loan with monthly payments of $300 and a 5% annual interest rate?

Question 7 of 50

A client wants to calculate the total value of sales for all products that sold more than 500 units. Which function should they use?

Question 8 of 50

A student wants to calculate the number of days between two dates stored in cells A1 and A2. Which function will provide this result?

Question 9 of 50

Which Excel function will count the number of non-blank cells in a range?

Question 10 of 50

A doctor wants to count the number of patients diagnosed with "Flu" from a dataset. Which Excel feature will help achieve this?

Question 11 of 50

Which Excel function will return the first 3 characters of a text string in cell A2?

Question 12 of 50

Which formula will calculate the total loan payments made if the monthly payment is in C10 and the number of months is in C11?

Question 13 of 50

Which Excel function would be used to calculate the number of months required to pay off a $12,000 loan with monthly payments of $500 and a 4% annual interest rate?

Question 14 of 50

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

Question 15 of 50

Which feature in Excel allows users to highlight cells based on specific conditions, such as highlighting sales over $5,000?

Question 16 of 50

A company wants to summarize sales data for different regions in a report. Which Excel feature would allow them to filter the report by region?

Question 17 of 50

A manager tracks monthly sales in cells A1 through L1. Which formula will return the maximum sales value?

Question 18 of 50

A user needs to calculate the total number of unique entries in a dataset. Which Excel function will help?

Question 19 of 50

A sales manager needs to calculate the commission earned by a salesperson. The sales amount is in cell A5 and the commission rate is in cell B5. Which formula will calculate the total commission?

Question 20 of 50

Which Excel feature allows users to restrict the type of data that can be entered into specific cells?

Question 21 of 50

A business owner wants to track monthly sales performance for multiple products. Which Excel feature allows them to summarize the data in a report?

Question 22 of 50

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

Question 23 of 50

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

Question 24 of 50

Which formula will count the number of times the word "Completed" appears in a range of cells from A1 to A10?

Question 25 of 50

A team wants to track the number of projects completed on time. Which Excel feature will allow them to filter the data by project status?

Question 26 of 50

Which Excel formula will display "Passed" if a student’s score in cell A2 is greater than or equal to 70 and "Failed" otherwise?

Question 27 of 50

A store wants to calculate the total sales for products that sold more than 300 units. Which formula should they use?

Question 28 of 50

A manager needs to calculate the number of employees who worked more than 40 hours in a week. Which function will provide this information?

Question 29 of 50

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

Question 30 of 50

Which formula will calculate the total interest paid on a loan if the monthly interest payments are in cells D1 through D12?

Question 31 of 50

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

Question 32 of 50

A client wants to calculate the number of months required to pay off a $15,000 loan with monthly payments of $500 and an interest rate of 5%. Which function should they use?

Question 33 of 50

A sales manager tracks monthly sales in cells A1 through L1. Which formula will return the minimum sales value?

Question 34 of 50

A business owner tracks the number of customers who visit their store each month. Which formula will calculate the average number of customers per month?

Question 35 of 50

A financial analyst needs to calculate the present value of a series of monthly payments. Which Excel function will provide this information?

Question 36 of 50

Which formula will calculate the total loan amount if the monthly payment is in cell C5 and the number of months is in cell C6?

Question 37 of 50

A team wants to calculate the total number of hours worked on a project. Which Excel function should they use?

Question 38 of 50

Which feature in Excel allows users to visualize data differences in a chart by adding labels to indicate what each color represents?

Question 39 of 50

A student wants to calculate the average test score for students who scored above 80. Which function will help achieve this?

Question 40 of 50

A user wants to extract the last 5 characters from a text string in cell A1. Which function should they use?

Question 41 of 50

A company wants to prevent users from entering incorrect data into a specific cell. Which Excel feature should they use?

Question 42 of 50

A manager needs to calculate the total commissions paid to sales representatives based on the sales amount in column B and the commission rate in column C. Which formula will calculate the total commission for a salesperson?

Question 43 of 50

A business wants to summarize monthly sales data for each product in a report. Which Excel feature allows them to organize and filter this data by product?

Question 44 of 50

A financial analyst needs to forecast future sales based on past performance. Which function should they use?

Question 45 of 50

Which formula will return "Yes" if a value in cell A1 is greater than 50 and "No" if it is less than or equal to 50?

Question 46 of 50

A store owner wants to calculate the total number of items sold for each product. Which Excel feature will allow them to summarize the sales data in a report?

Question 47 of 50

A user needs to calculate the total sales for each region in a report. Which feature in Excel allows them to filter the data by region?

Question 48 of 50

A client wants to calculate how much money they will have after making monthly savings deposits for 10 years with an interest rate of 3%. Which Excel function should they use?

Question 49 of 50

A manager needs to calculate the total number of orders that exceeded $1,000 in value. Which function should they use?

Question 50 of 50

A user wants to calculate the total revenue for each product in a table, based on the product’s price and the number of units sold. Which formula will provide the correct result?

Set 5 complete

You scored 0%

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

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