C268 WGU Exam with verified detailed solutions || || || || || ||
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 student
|| || || || || || || || || || || || || ||
decides to track this correlation using the CORREL function in Excel.
|| || || || || || || || || || ||
How should this be set up? - correct answer✔✔By setting up hours in array A and 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 text starting on the left-hand side.
|| || || || || ||
Which group on the homepage should be used to accomplish this goal? - correct
|| || || || || || || || || || || || || ||
answer✔✔Alignment
A manager has a spreadsheet table with company name, stock prices and sales dollars.
|| || || || || || || || || || || || || ||
What should 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✔✔Click anywhere in the table, click the filter button, click the down arrow next to || || || || || || || || || || || || || || ||
"industry", and then select "Manufacturing". || || || ||
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 student
|| || || || || || || || || || || || || ||
decides to track this correlation using the CORREL function in Excel.
|| || || || || || || || || || ||
How should this be set up? - correct answer✔✔By setting up hours in array A and 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 text starting on the left-hand side.
|| || || || || ||
Which group on the homepage should be used to accomplish this goal? - correct
|| || || || || || || || || || || || || ||
answer✔✔Alignment
A manager has a spreadsheet table with company name, stock prices and sales dollars.
|| || || || || || || || || || || || || ||
What should 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✔✔Click anywhere in the table, click the filter button, click the down arrow next to || || || || || || || || || || || || || || ||
"industry", and then select "Manufacturing". || || || ||
