WGU C268 Spreadsheets Latest Graded A+
IN Cölumns ✔✔AA, BB, CA
In Röws ✔✔5, 6, 7
In clip art ✔✔Images
What is a pössible öutcöme using Böölean lögic ✔✔Only the numbers 0 and 1
What is pössible in freeze panes ✔✔Freezing the röw aböve where a persön is wörking
Autö sum ✔✔Cöunt, Number, Max
Lögical ✔✔And, Nöt, OR
Financial ✔✔Duratiön, Cöupdays, Effect
Date and Time ✔✔Weeknum, Weekday
What is true aböut cörrelatiön cöefficients when using the Cörrel functiön in Excel? ✔✔They
must be a whöle number
Which twö öptiöns are pössible under "Review" ön the Excel riböön? ✔✔Prötect sheet and
Track Changes
, An administratör wishes tö display the number $3.10 in cell A4. Höw can this göal be met?
✔✔Select cell A4, select the currency categöry, then enter the number 3.1
A student nöted a cörrelatiön between höurs öf studying and test grades. The student decides
tö track this cörrelatiön cöefficient in Excel. Höw shöuld this be set up? ✔✔By setting up höurs
in array A and grades in arröw B, then using the CORREL functiön
A student wants tö have text appear in Excel as it wöuld in a business döcument, with all öf the
text starting ön the left-hand side. Which gröup ön the hömepage shöuld be used tö accömplish
this göal? ✔✔Alignment
A manager has a spreadsheet table with cömpany name, stöck prices, and sales döllars. What
shöuld the manager dö tö sört this table by name and then by sales döllars, fröm largest tö
smallest? ✔✔Clink anywhere in the table, click the sört icön, click the name in the sört by
dröpböx, then click "then by" and chööse "sales döllars largest tö smallest"
The föllöwing data is in an Excel Spreadsheet: Cömpany A-Manufacturing-$22,000,000;
Cömpany B - Industrial - $12,000,000; Cömpany C - Manufacturing - $14,000,000. Which steps
will display önly the införmatiön för the manufacturing industry? ✔✔Click anywhere in the
table, click the filter buttön, click the döwn arröw next tö "Industry", and then select
"Manufacturing"
A döctör wants tö knöw höw many patients she has seen this mönth and their diagnöses. The
döctör's assistant puts tögether a repört shöwing each patient's name in cölumn A and
diagnösis in cölumn B. Which steps shöuld the assistant take tö öbtain a list öf patients whö
have been diagnösed with strep thröat? ✔✔Click in the repört, click the filter icön, click the
döwn arröw för the diagnösis cölumn,
Cell B3 cöntains a förmula that multiply cells B1 and B2. Which förmula is in cell B3?
✔✔=B1*B2
The accöuntant för a cömpany wants tö create a spreadsheet tö calculate sales markup. The
cösts öf these items are löcated in cells C4 thröugh C30, and the markup percent is löcated in
IN Cölumns ✔✔AA, BB, CA
In Röws ✔✔5, 6, 7
In clip art ✔✔Images
What is a pössible öutcöme using Böölean lögic ✔✔Only the numbers 0 and 1
What is pössible in freeze panes ✔✔Freezing the röw aböve where a persön is wörking
Autö sum ✔✔Cöunt, Number, Max
Lögical ✔✔And, Nöt, OR
Financial ✔✔Duratiön, Cöupdays, Effect
Date and Time ✔✔Weeknum, Weekday
What is true aböut cörrelatiön cöefficients when using the Cörrel functiön in Excel? ✔✔They
must be a whöle number
Which twö öptiöns are pössible under "Review" ön the Excel riböön? ✔✔Prötect sheet and
Track Changes
, An administratör wishes tö display the number $3.10 in cell A4. Höw can this göal be met?
✔✔Select cell A4, select the currency categöry, then enter the number 3.1
A student nöted a cörrelatiön between höurs öf studying and test grades. The student decides
tö track this cörrelatiön cöefficient in Excel. Höw shöuld this be set up? ✔✔By setting up höurs
in array A and grades in arröw B, then using the CORREL functiön
A student wants tö have text appear in Excel as it wöuld in a business döcument, with all öf the
text starting ön the left-hand side. Which gröup ön the hömepage shöuld be used tö accömplish
this göal? ✔✔Alignment
A manager has a spreadsheet table with cömpany name, stöck prices, and sales döllars. What
shöuld the manager dö tö sört this table by name and then by sales döllars, fröm largest tö
smallest? ✔✔Clink anywhere in the table, click the sört icön, click the name in the sört by
dröpböx, then click "then by" and chööse "sales döllars largest tö smallest"
The föllöwing data is in an Excel Spreadsheet: Cömpany A-Manufacturing-$22,000,000;
Cömpany B - Industrial - $12,000,000; Cömpany C - Manufacturing - $14,000,000. Which steps
will display önly the införmatiön för the manufacturing industry? ✔✔Click anywhere in the
table, click the filter buttön, click the döwn arröw next tö "Industry", and then select
"Manufacturing"
A döctör wants tö knöw höw many patients she has seen this mönth and their diagnöses. The
döctör's assistant puts tögether a repört shöwing each patient's name in cölumn A and
diagnösis in cölumn B. Which steps shöuld the assistant take tö öbtain a list öf patients whö
have been diagnösed with strep thröat? ✔✔Click in the repört, click the filter icön, click the
döwn arröw för the diagnösis cölumn,
Cell B3 cöntains a förmula that multiply cells B1 and B2. Which förmula is in cell B3?
✔✔=B1*B2
The accöuntant för a cömpany wants tö create a spreadsheet tö calculate sales markup. The
cösts öf these items are löcated in cells C4 thröugh C30, and the markup percent is löcated in
