For Expert help and assignment handling,
1
C268 WGU Questions and Answers (100%
Correct Answers) Already Graded A+
Match the way information can be displayed in a spreadsheet with the
type of information to be displayed.Ans: In rows: 5,6 and 7
In columns: AA, BB, CA
© 2026 Assignment Expert
In clip art: Images
What is a possible outcome using Boolean Logic?Ans: Only the numbers
Guru01 - Stuvia
0 and 1.
What is possible in freeze panes?Ans: Freezing the row above where a
person is working.
Match the category with its type of function.Ans: 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?Ans: They can be a negative number.
What two options are possible under "review" on the Excel ribbon?Ans:
Track Changes
, For Expert help and assignment handling,
2
Protect Sheet
An administer wishes to display the number $3.10 in Cell A4. How can this
goal be met?Ans: 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.
© 2026 Assignment Expert
How should this be set up?Ans: By setting up hours in array A and grades
in array B, and the using the CORREL function.
Guru01 - Stuvia
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?Ans: 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?Ans: 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
1
C268 WGU Questions and Answers (100%
Correct Answers) Already Graded A+
Match the way information can be displayed in a spreadsheet with the
type of information to be displayed.Ans: In rows: 5,6 and 7
In columns: AA, BB, CA
© 2026 Assignment Expert
In clip art: Images
What is a possible outcome using Boolean Logic?Ans: Only the numbers
Guru01 - Stuvia
0 and 1.
What is possible in freeze panes?Ans: Freezing the row above where a
person is working.
Match the category with its type of function.Ans: 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?Ans: They can be a negative number.
What two options are possible under "review" on the Excel ribbon?Ans:
Track Changes
, For Expert help and assignment handling,
2
Protect Sheet
An administer wishes to display the number $3.10 in Cell A4. How can this
goal be met?Ans: 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.
© 2026 Assignment Expert
How should this be set up?Ans: By setting up hours in array A and grades
in array B, and the using the CORREL function.
Guru01 - Stuvia
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?Ans: 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?Ans: 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
