C268 WGU 2024/2025 Exam
Comprehensive Questions and Verified
Answers | Accurate Solutions | Get it
100% Correct!! | Already Graded A+
Match the way information can be displayed in a spreadsheet with the type
of information to be displayed. - 🧠ANSWER ✔✔In rows: 5,6 and 7
In columns: AA, BB, CA
In clip art: Images
What is a possible outcome using Boolean Logic? - 🧠ANSWER ✔✔Only
the numbers 0 and 1.
What is possible in freeze panes? - 🧠ANSWER ✔✔Freezing the row above
where a person is working.
Match the category with its type of function. - 🧠ANSWER ✔✔Logical: AND,
NOR, OR
Auto Sum: COUNT, NUMBER, MAX
Date and Time: WEEKNUM, WEEKDAY
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY 1
STATEMENT. ALL RIGHTS RESERVED
, Financial: DURATION, COUPDAYS, EFFECT
What is true about correlation coefficients when using the CORREL
function in Excel? - 🧠ANSWER ✔✔They can be a negative number.
What two options are possible under "review" on the Excel ribbon? -
🧠ANSWER ✔✔Track Changes
Protect Sheet
An administer wishes to display the number $3.10 in Cell A4. How can this
goal be met? - 🧠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? - 🧠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.
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY 2
STATEMENT. ALL RIGHTS RESERVED
Comprehensive Questions and Verified
Answers | Accurate Solutions | Get it
100% Correct!! | Already Graded A+
Match the way information can be displayed in a spreadsheet with the type
of information to be displayed. - 🧠ANSWER ✔✔In rows: 5,6 and 7
In columns: AA, BB, CA
In clip art: Images
What is a possible outcome using Boolean Logic? - 🧠ANSWER ✔✔Only
the numbers 0 and 1.
What is possible in freeze panes? - 🧠ANSWER ✔✔Freezing the row above
where a person is working.
Match the category with its type of function. - 🧠ANSWER ✔✔Logical: AND,
NOR, OR
Auto Sum: COUNT, NUMBER, MAX
Date and Time: WEEKNUM, WEEKDAY
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY 1
STATEMENT. ALL RIGHTS RESERVED
, Financial: DURATION, COUPDAYS, EFFECT
What is true about correlation coefficients when using the CORREL
function in Excel? - 🧠ANSWER ✔✔They can be a negative number.
What two options are possible under "review" on the Excel ribbon? -
🧠ANSWER ✔✔Track Changes
Protect Sheet
An administer wishes to display the number $3.10 in Cell A4. How can this
goal be met? - 🧠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? - 🧠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.
COPYRIGHT©NINJANERD 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY 2
STATEMENT. ALL RIGHTS RESERVED
