Spreadsheets WGU - C268, Exam Questions and answers, 100% Accurate. VERIFIED.

Spreadsheets WGU - C268, Exam Questions and answers, 100% Accurate. VERIFIED. IN Columns - -AA, BB, CA In Rows - -5, 6, 7 In clip art - -Images What is a possible outcome using Boolean logic - -Only the numbers 0 and 1 What is possible in freeze panes - -Freezing the row above where a person is working Auto sum - -Count, Number, Max Logical - -And, Not, OR Financial - -Duration, Coupdays, Effect Date and Time - -Weeknum, Weekday What is true about correlation coefficients when using the Correl function in Excel? - -They must be a whole number Which two options are possible under "Review" on the Excel riboon? - -Protect sheet and Track Changes An administrator wishes to display the number $3.10 in cell A4. How can this goal be met? - -Select cell 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 coefficient in Excel. How should this be set up? - -By setting up hours in array A and grades in arrow B, then 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? - -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? - -Clink anywhere in the table, click the sort icon, click the name in the sort by dropbox, 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 will display only the information for the manufacturing industry? - -Click anywhere in the table, click the filter button, click the down arrow next to "Industry", and then select "Manufactur