C268 WGU QUESTIONS WITH CORRECT ANSWERS

C268 WGU QUESTIONS WITH CORRECT
ANSWERS 2026-2027
Match the way information can be displayed in a spreadsheet with the type of information to be
displayed. - CORRECT ANSWER -In rows: 5,6 and 7

In columns: AA, BB, CA

In clip art: Images



What is a possible outcome using Boolean Logic? - CORRECT ANSWER -
Only the numbers 0 and 1.



What is possible in freeze panes? - CORRECT ANSWER -
Freezing the row above where a person is working.



Match the category with its type of function. - CORRECT ANSWER -Logical: AND, NOR, OR

Auto Sum: COUNT, NUMBER, MAX

Date and Time: WEEKNUM, WEEKDAY

Financial: DURATION, COUPDAYS, EFFECT



What is true about correlation coefficients when using the CORREL function in Excel? -
CORRECT ANSWER -They can be a negative number.



What two options are possible under "review" on the Excel ribbon? - CORRECT ANSWER -
Track Changes

Protect Sheet



An administer wishes to display the number $3.10 in Cell A4. How can this goal be met? -
CORRECT ANSWER -Select A4, select the currency category, then enter the number 3.1.

, A student noted a correlation between hours of studying and test grades. The studentEdecides to trac
X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2




k this correlation using the CORREL function in Excel.
X2 X2 X2 X2 X2 X2 X2 X2




How should this be setEup? - CORRECT ANSWER -
X2 X2 X2 X2 X2 X2 X2 X2




By setting up hours in array AEand grades in array B, and the using the CORREL function.
X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2




A student wants to have text appear in Excel as it would in a business document, with all of the t ext st
X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2




artingEon the left-hand side. X2 X2 X2




Which group on the homepage should be used toEaccomplish this goal? - CORRECT ANSWERE-
X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2




Alignment
X2




A manager has a spreadsheet table with company name, stock prices and sales dollars. What sho uld
X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2




the manager do to sort this table by name and then by sales dollars, from largest to smallest?
X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2




- CORRECT ANSWER -
X2 X2 X2




Click anywhere in the table, click the sort icon, click the name in the sort by drop box, then click " then
X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X




by", and choose "sales dollars largest to smallest".
2 X2 X2 X2 X2 X2 X2 X2




The following data is in an Excel spreadsheet:
X2 X2 X2 X2 X2 X2 X2




Company A - Manufacturing - X2 X2 X2 X2




$22,000,000 Company B - Industrial -
X2 X2 X2 X2 X2 X2




X2 $12,000,000

Company C - Manufacturing - $14,000,000 X2 X2 X2 X2 X2




Which steps display only the information for the Manufacturing Industry? - CORRECT ANSWER -
X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2




ClickEanywhere in the table, click the filter button, click the down arrow next to "industry", and th en
X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2 X2




select "Manufacturing". X2