C268 WGU QUESTIONS WITH CORRECT
ANSWERS 2025-2026
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
track this correlation using the CORREL function in Excel.
How should this be setEup? CORRECT ANSWER
By setting up hours in array AEand grades in array B, and the using the CORREL function.
A student wants to have text appear in Excel as it would in a business document, with all of the t
ext startingEon the left-hand side.
Which group on the homepage should be used toEaccomplish this goal? - CORRECT ANSWERE-
Alignment
A manager has a spreadsheet table with company name, stock prices and sales dollars. What sho
uld the manager do to sort this table by name and then by sales dollars, from largest to smallest?
CORRECT ANSWER
Click anywhere in the table, click the sort icon, click the name in the sort by drop box, then click "
then by", and choose "sales dollars largest to smallest".
The following data is in an Excel spreadsheet:
Company A - Manufacturing - $22,000,000
Company B - Industrial - $12,000,000
Company C - Manufacturing - $14,000,000
Which steps display only the information for the Manufacturing Industry? CORRECT
ANSWER ClickEanywhere in the table, click the filter button, click the down arrow next to
"industry", and th en select "Manufacturing".
ANSWERS 2025-2026
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
track this correlation using the CORREL function in Excel.
How should this be setEup? CORRECT ANSWER
By setting up hours in array AEand grades in array B, and the using the CORREL function.
A student wants to have text appear in Excel as it would in a business document, with all of the t
ext startingEon the left-hand side.
Which group on the homepage should be used toEaccomplish this goal? - CORRECT ANSWERE-
Alignment
A manager has a spreadsheet table with company name, stock prices and sales dollars. What sho
uld the manager do to sort this table by name and then by sales dollars, from largest to smallest?
CORRECT ANSWER
Click anywhere in the table, click the sort icon, click the name in the sort by drop box, then click "
then by", and choose "sales dollars largest to smallest".
The following data is in an Excel spreadsheet:
Company A - Manufacturing - $22,000,000
Company B - Industrial - $12,000,000
Company C - Manufacturing - $14,000,000
Which steps display only the information for the Manufacturing Industry? CORRECT
ANSWER ClickEanywhere in the table, click the filter button, click the down arrow next to
"industry", and th en select "Manufacturing".
