A+
Spreadsheets - C268 2025/2026 Exam
Questions and Answers 100%
Guaranteed Success | Already Rated A+
IN Columns - 🧠ANSWER ✔✔AA, BB, CA
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
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, A+
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
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, A+
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? -
3
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
Spreadsheets - C268 2025/2026 Exam
Questions and Answers 100%
Guaranteed Success | Already Rated A+
IN Columns - 🧠ANSWER ✔✔AA, BB, CA
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
1
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, A+
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
2
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
, A+
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? -
3
COPYRIGHT©JOSHCLAY 2025/2026. YEAR PUBLISHED 2025. COMPANY REGISTRATION NUMBER: 619652435. TERMS OF USE. PRIVACY
STATEMENT. ALL RIGHTS RESERVED
