WGU C268 Spreadsheets -| 84 REAL EXAM QUESTIONS WITH 100%
RATED CORRECT ANSWERS | 100% VERIFIED | 2025 LATEST
UPDATED | GET A+
IN Columns - (Correct Answer)AA, BB, CA
In Rows - (Correct Answer)5, 6, 7
In clip art - (Correct Answer)Images
What is a possible outcome using Boolean logic - (Correct Answer)Only the numbers 0 and 1
What is possible in freeze panes - (Correct Answer)Freezing the row above where a person is
working
Auto sum - (Correct Answer)Count, Number, Max
Logical - (Correct Answer)And, Not, OR
Financial - (Correct Answer)Duration, Coupdays, Effect
Date and Time - (Correct Answer)Weeknum, Weekday
What is true about correlation coefficients when using the Correl function in Excel? - (Correct
Answer)They must be a whole number
Which two options are possible under "Review" on the Excel riboon? - (Correct Answer)Protect
sheet and Track Changes
还是指某个特定的词或概念
？
, An administrator wishes to display the number $3.10 in cell A4. How can this goal be met? -
(Correct 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? - (Correct 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? - (Correct 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? - (Correct 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? - (Correct 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? - (Correct Answer)Click in the report, click the filter icon, click the
down arrow for the diagnosis column,
Cell B3 contains a formula that multiply cells B1 and B2. Which formula is in cell B3? -
(Correct Answer)=B1*B2
还是指某个特定的词或概念
？
RATED CORRECT ANSWERS | 100% VERIFIED | 2025 LATEST
UPDATED | GET A+
IN Columns - (Correct Answer)AA, BB, CA
In Rows - (Correct Answer)5, 6, 7
In clip art - (Correct Answer)Images
What is a possible outcome using Boolean logic - (Correct Answer)Only the numbers 0 and 1
What is possible in freeze panes - (Correct Answer)Freezing the row above where a person is
working
Auto sum - (Correct Answer)Count, Number, Max
Logical - (Correct Answer)And, Not, OR
Financial - (Correct Answer)Duration, Coupdays, Effect
Date and Time - (Correct Answer)Weeknum, Weekday
What is true about correlation coefficients when using the Correl function in Excel? - (Correct
Answer)They must be a whole number
Which two options are possible under "Review" on the Excel riboon? - (Correct Answer)Protect
sheet and Track Changes
还是指某个特定的词或概念
？
, An administrator wishes to display the number $3.10 in cell A4. How can this goal be met? -
(Correct 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? - (Correct 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? - (Correct 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? - (Correct 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? - (Correct 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? - (Correct Answer)Click in the report, click the filter icon, click the
down arrow for the diagnosis column,
Cell B3 contains a formula that multiply cells B1 and B2. Which formula is in cell B3? -
(Correct Answer)=B1*B2
还是指某个特定的词或概念
？
