WGU C268 SPREADSHEETS FINAL OA
COMPREHENSIVE REVIEW PAPER WITH
SOLVED QUESTIONS
◉ In Rows
Answer: 5, 6, 7
◉ In clip art
Answer: 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
◉ Auto sum
Answer: Count, Number, Max
◉ Logical
Answer: And, Not, OR
,◉ Financial
Answer: Duration, Coupdays, Effect
◉ Date and Time
Answer: Weeknum, Weekday
◉ What is true about correlation coefficients when using the
Correl function in Excel?
Answer: They must be a whole number
◉ Which two options are possible under "Review" on the Excel
riboon?
Answer: Protect sheet and Track Changes
◉ An administrator wishes to display the number $3.10 in cell A4.
How can this goal be met?
Answer: 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?
Answer: 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?
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?
Answer: 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?
Answer: Click anywhere in the table, click the filter button, click
the down arrow next to "Industry", and then select
"Manufacturing"
◉ A doctor wants to know how many patients she has seen this
month and their diagnoses. The doctor's assistant puts together a
report showing each patient's name in column A and diagnosis in
column B. Which steps should the assistant take to obtain a list of
patients who have been diagnosed with strep throat?
COMPREHENSIVE REVIEW PAPER WITH
SOLVED QUESTIONS
◉ In Rows
Answer: 5, 6, 7
◉ In clip art
Answer: 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
◉ Auto sum
Answer: Count, Number, Max
◉ Logical
Answer: And, Not, OR
,◉ Financial
Answer: Duration, Coupdays, Effect
◉ Date and Time
Answer: Weeknum, Weekday
◉ What is true about correlation coefficients when using the
Correl function in Excel?
Answer: They must be a whole number
◉ Which two options are possible under "Review" on the Excel
riboon?
Answer: Protect sheet and Track Changes
◉ An administrator wishes to display the number $3.10 in cell A4.
How can this goal be met?
Answer: 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?
Answer: 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?
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?
Answer: 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?
Answer: Click anywhere in the table, click the filter button, click
the down arrow next to "Industry", and then select
"Manufacturing"
◉ A doctor wants to know how many patients she has seen this
month and their diagnoses. The doctor's assistant puts together a
report showing each patient's name in column A and diagnosis in
column B. Which steps should the assistant take to obtain a list of
patients who have been diagnosed with strep throat?
