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

WGU C268 Practice Questions – Set 1

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

Question 1 of 50

Which Excel tab would you use to insert charts, pictures, or shapes into a worksheet?

Question 2 of 50

Which of the following is a possible outcome when using Boolean logic in Excel?

Question 3 of 50

What does the Freeze Panes feature in Excel allow you to do?

Question 4 of 50

Which of the following functions would you use to sum a range of cells automatically?

Question 5 of 50

Which formula will correctly calculate the commission dollars in cell C2 based on a 2% commission rate in cell A5 and sales value in cell B2?

Question 6 of 50

Which Excel function is best used to calculate the correlation coefficient between hours of studying and test grades?

Question 7 of 50

Which Excel tab includes tools to protect sheets and track changes in a workbook?

Question 8 of 50

Which Excel function returns the present value of future cash flows?

Question 9 of 50

Which function would you use to determine the number of periods needed to pay off a loan of $3,500 with monthly payments of $100 at 3% interest?

Question 10 of 50

A manager wants to sort a table first by company name and then by sales dollars, from largest to smallest. What steps should they follow?

Question 11 of 50

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

Question 12 of 50

Which two options are available under the “Review” tab in the Excel ribbon?

Question 13 of 50

Which Excel function would be used to find the number of jobs completed by a specific employee in a project table?

Question 14 of 50

What is the main use of the CONCAT (or CONCATENATE) function in Excel?

Question 15 of 50

A doctor’s assistant has a table of patient diagnoses and wants to filter the table to show only patients diagnosed with strep throat. What should they do?

Question 16 of 50

Which formula will calculate the markup price in cell D4 for items with costs in cells C4 through C30, where the markup percentage is stored in cell A1?

Question 17 of 50

A local golf course held a charity tournament and collected data on golfers' names, ages, handicaps, and scores. Which function will count the number of scores recorded?

Question 18 of 50

Which formula will show the result of TRUE when the sum of cells A1 through A4 equals 140?

Question 19 of 50

Which Excel function returns the month from a date value?

Question 20 of 50

Which function in Excel provides the present value of an annuity based on periodic, constant payments and a constant interest rate?

Question 21 of 50

Which Excel function returns the total number of children attending an event, where “N” is used to indicate no children?

Question 22 of 50

Which Excel function is used to display only the last 10 digits of an account number stored in cell A2?

Question 23 of 50

A salesperson tracks their appointments per month. Which formula will show if the goal of 10 appointments was met in January?

Question 24 of 50

Which of the following functions would you use to find the commission dollars in cells E5 through E20 if the commission rate is stored in B2?

Question 25 of 50

Which Excel formula will calculate the monthly interest rate on a loan, where F19 contains the loan balance and C13 contains the annual interest rate?

Question 26 of 50

An Excel model contains employee salaries. Which function will calculate the total salary paid annually?

Question 27 of 50

Which formula will result in the sum of sales values in cells B2 through B4?

Question 28 of 50

Which Excel function calculates the future value of monthly payments of $100 over two years with a 5% interest rate?

Question 29 of 50

Which chart type can be used to compare total sales over the last four years?

Question 30 of 50

Which Excel feature can you use to track changes made by other users in a shared workbook?

Question 31 of 50

An analyst wants to know the position of a specific character in a text string. Which Excel function should they use?

Question 32 of 50

Which of the following is a feature of a PivotTable in Excel?

Question 33 of 50

A manager wants to use Solver to maximize profit by changing the number of products produced, but wants to ensure that no more than the demand is met. What should the constraint be?

Question 34 of 50

Which function calculates the upper limit for a sales forecast if expected attendance is 18,000 people and a confidence interval has been set up?

Question 35 of 50

In which situation would you use a circular reference in a spreadsheet model?

Question 36 of 50

An owner wants to summarize all purchase data for Product A from four vendors using named ranges in separate tabs. Which formula should be used?

Question 37 of 50

A mechanic uses the CORREL function to find the correlation coefficient of 0.234 between teenage drivers and car repairs. What can be inferred about the reliability of the forecast based on this correlation?

Question 38 of 50

Which feature of PivotTables allows you to add an additional filter to your data fields?

Question 39 of 50

Which feature of Excel is most useful for comparing investment returns at different points in time using a chart?

Question 40 of 50

Which formula will determine the total sales made by Person B in May, where the data is organized in cells A1 through A5 (names) and B1 through B5 (sales)?

Question 41 of 50

Which formula calculates whether sales met the goal of $800 in cell B2?

Question 42 of 50

A person wants to pay off a loan in five years by making $200 monthly payments. Which function will calculate the maximum annual interest rate?

Question 43 of 50

A data validation rule needs to restrict user inputs to numbers from a specific list. Which setting should be selected?

Question 44 of 50

A person wants to buy a laptop with a maximum budget of $40 per month for 18 months. Which formula will help determine if the laptop priced at $700 is affordable?

Question 45 of 50

Which feature in Excel should you use to combine multiple rows or columns into one line of text?

Question 46 of 50

Which Excel function helps calculate the total operating expenses for a product by summing salaries, commissions, and fixed costs?

Question 47 of 50

An employee has been paid $250 per month for 36 months at an interest rate of 4.99%. Which function provides the present value of these payments?

Question 48 of 50

An Excel model needs to calculate the difference between the total amount paid over a loan period and the original loan amount. Which formula should be used?

Question 49 of 50

A doctor’s assistant tracks patient diagnoses and wants to filter for patients diagnosed with the flu. What Excel feature should they use?

Question 50 of 50

Which formula will provide the total number of products sold that have a quantity greater than or equal to 500 in a dataset?

Set 1 complete

You scored 0%

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

Next: Set 2

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