For Expert help and assignment handling,
1
Spreadsheets - C268 Questions and Answers
(100% Correct Answers) Already Graded A+
IN ColumnsAns: AA, BB, CA
In RowsAns: 5, 6, 7
In clip artAns: Images
© 2026 Assignment Expert
What is a possible outcome using Boolean logicAns: Only the numbers 0
and 1
Guru01 - Stuvia
What is possible in freeze panesAns: Freezing the row above where a
person is working
Auto sumAns: Count, Number, Max
LogicalAns: And, Not, OR
FinancialAns: Duration, Coupdays, Effect
Date and TimeAns: Weeknum, Weekday
What is true about correlation coefficients when using the Correl function
in Excel?Ans: They must be a whole number
Which two options are possible under "Review" on the Excel riboon?Ans:
Protect sheet and Track Changes
, For Expert help and assignment handling,
2
An administrator wishes to display the number $3.10 in cell A4. How can
this goal be met?Ans: 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?Ans: 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
© 2026 Assignment Expert
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
Guru01 - Stuvia
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: 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?Ans: 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
1
Spreadsheets - C268 Questions and Answers
(100% Correct Answers) Already Graded A+
IN ColumnsAns: AA, BB, CA
In RowsAns: 5, 6, 7
In clip artAns: Images
© 2026 Assignment Expert
What is a possible outcome using Boolean logicAns: Only the numbers 0
and 1
Guru01 - Stuvia
What is possible in freeze panesAns: Freezing the row above where a
person is working
Auto sumAns: Count, Number, Max
LogicalAns: And, Not, OR
FinancialAns: Duration, Coupdays, Effect
Date and TimeAns: Weeknum, Weekday
What is true about correlation coefficients when using the Correl function
in Excel?Ans: They must be a whole number
Which two options are possible under "Review" on the Excel riboon?Ans:
Protect sheet and Track Changes
, For Expert help and assignment handling,
2
An administrator wishes to display the number $3.10 in cell A4. How can
this goal be met?Ans: 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?Ans: 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
© 2026 Assignment Expert
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
Guru01 - Stuvia
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: 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?Ans: 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
