WGU C268 Exam Study Questions | Questions with 100% Correct Answers | Verified | Latest Update

Match the way information can be displayed in a spreadsheet with the type of information to be displayed. - In rows: 5,6 and 7 In columns: AA, BB, CA 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. Match the category with its type of function. - 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? - They can be a negative number. What two options are possible under "review" on the Excel ribbon? - Track Changes Protect SheetAn administer wishes to display the number $3.10 in Cell A4. How can this goal be met? - 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.