WGU C268 SPREADSHEETS EXAM WITH 100%
CORRECT AND VERIFIED ANSWERS
Correct 74
100%
Incorrect 00
Your answers
1 of 74
Term
Use the AVERAGEIF function to complete the "Average Hours/Job"
column in table 4. Reference the appropriate field in table 1 as your range
and the "Difficulty" rating in table 4 as your criteria.
Give this one a try later!
=AVERAGEIF($G$16:$G$35,G46, =averageif($g$16:$g$35,g47,$e$16:$e
$E$16:$E$35) $35)
, =averageif($g$16:$g$35,g46,$e$ =averageif($g$16:$g$35,g46,$e$16:$
15:$e e
$35) $34)
Don't know?
2 of 74
Term
Use the CONCAT function (or the CONCATENATE function if you
are using Excel 2013 or earlier) to create the "Transaction
Statement" in cell K18. The statement in cell K18 should read "I
spent $24.06 at merchant #4931 on: 8/1". To make this
statement, combine "Statement P1" in cell D13, the "Amount" in
cell D18, "Statement P2" in cell D14, the "Merchant ID" in cell
C18, "Statement P3" in cell D15, and the "Date" in cell J18.
Copy and paste your function down to complete the
"Transaction Statement" column of the table.
Give this one a try later!
=sumif($d$16:$d$35,g39,$e$16:$e$35) =correl('past events'!d4:d103,'past
events'!c4:c103)
=CONCAT($D$13,D18,$D$14,C18,
=concat(e18,"/",f18) $D$15,J18)
Don't know?
, 3 of 74
Term
Use the VLOOKUP function to complete the "Employee"
column of table 2. Use "Job ID" from table 2 as your
lookup_value(s) and table 1 as the reference table.
Give this one a try later!
=vlookup(b40,$b$16:$o$35,2,false) =vlookup(b40,$b$16:$o$35,4,false)
=vlookup(b40,$b$16:$o$35,3,true)
=VLOOKUP(B40,$B$16:$O$3
5,3,
FALSE)
Don't know?
4 of 74
Term
Complete the "Arena Fee" portion of the "Profit Summary"
section of the model by referencing the arena fee from the
"Model Inputs" section of the worksheet.
Give this one a try later!
=c10 =c8
, =c11 =C9
Don't know?
5 of 74
Term
Use the LEFT function in cell D13 to return the text "I spent $"
from the statement template in cell D9. Refer to the location of
the "$" character you calculated in cell D12 as the "num_char"
argument for your function.
Give this one a try later!
=left(d9,d11) =left(d9,d10)
=LEFT(D9,D12) =left(d10,d12)
Don't know?
6 of 74
Term
Enter the fixed costs in the model. Reference the
appropriate amount for each product type in the "Model
Inputs" section.
CORRECT AND VERIFIED ANSWERS
Correct 74
100%
Incorrect 00
Your answers
1 of 74
Term
Use the AVERAGEIF function to complete the "Average Hours/Job"
column in table 4. Reference the appropriate field in table 1 as your range
and the "Difficulty" rating in table 4 as your criteria.
Give this one a try later!
=AVERAGEIF($G$16:$G$35,G46, =averageif($g$16:$g$35,g47,$e$16:$e
$E$16:$E$35) $35)
, =averageif($g$16:$g$35,g46,$e$ =averageif($g$16:$g$35,g46,$e$16:$
15:$e e
$35) $34)
Don't know?
2 of 74
Term
Use the CONCAT function (or the CONCATENATE function if you
are using Excel 2013 or earlier) to create the "Transaction
Statement" in cell K18. The statement in cell K18 should read "I
spent $24.06 at merchant #4931 on: 8/1". To make this
statement, combine "Statement P1" in cell D13, the "Amount" in
cell D18, "Statement P2" in cell D14, the "Merchant ID" in cell
C18, "Statement P3" in cell D15, and the "Date" in cell J18.
Copy and paste your function down to complete the
"Transaction Statement" column of the table.
Give this one a try later!
=sumif($d$16:$d$35,g39,$e$16:$e$35) =correl('past events'!d4:d103,'past
events'!c4:c103)
=CONCAT($D$13,D18,$D$14,C18,
=concat(e18,"/",f18) $D$15,J18)
Don't know?
, 3 of 74
Term
Use the VLOOKUP function to complete the "Employee"
column of table 2. Use "Job ID" from table 2 as your
lookup_value(s) and table 1 as the reference table.
Give this one a try later!
=vlookup(b40,$b$16:$o$35,2,false) =vlookup(b40,$b$16:$o$35,4,false)
=vlookup(b40,$b$16:$o$35,3,true)
=VLOOKUP(B40,$B$16:$O$3
5,3,
FALSE)
Don't know?
4 of 74
Term
Complete the "Arena Fee" portion of the "Profit Summary"
section of the model by referencing the arena fee from the
"Model Inputs" section of the worksheet.
Give this one a try later!
=c10 =c8
, =c11 =C9
Don't know?
5 of 74
Term
Use the LEFT function in cell D13 to return the text "I spent $"
from the statement template in cell D9. Refer to the location of
the "$" character you calculated in cell D12 as the "num_char"
argument for your function.
Give this one a try later!
=left(d9,d11) =left(d9,d10)
=LEFT(D9,D12) =left(d10,d12)
Don't know?
6 of 74
Term
Enter the fixed costs in the model. Reference the
appropriate amount for each product type in the "Model
Inputs" section.
