WGU C268 Spreadsheets |OA| Objective
Assessment | Actual Questions and
Answers Latest Updated
(Graded A+)
Correct 74
Incorrect 0
C268 Spreadsheets | Objective Assessment
Term
column in table 4. Reference the appropriate field in table 1 as your
range and the "Difficulty" rating in table 4 as your criteria.
=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$15:$e =averageif($g$16:$g$35,g46,$e$16:$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!
=correl('past events'!d4:d103,'past
=sumif($d$16:$d$35,g39,$e$16:$e$35)
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,
=vlookup(b40,$b$16:$o$35,3,true)
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.
Assessment | Actual Questions and
Answers Latest Updated
(Graded A+)
Correct 74
Incorrect 0
C268 Spreadsheets | Objective Assessment
Term
column in table 4. Reference the appropriate field in table 1 as your
range and the "Difficulty" rating in table 4 as your criteria.
=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$15:$e =averageif($g$16:$g$35,g46,$e$16:$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!
=correl('past events'!d4:d103,'past
=sumif($d$16:$d$35,g39,$e$16:$e$35)
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,
=vlookup(b40,$b$16:$o$35,3,true)
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.
