C268 WGU Exam with verified detailed solutions

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". || || || ||