1|Page
WGU C268 SPREADSHEETS EXAM PRE-ASSESSMENT AND OBJECTIVE LATEST
2025 ACTUAL EXAM WITH COMPLETE QUESTIONS AND CORRECT DETAILED
ANSWERS (100% VERIFIED ANSWERS) |ALREADY GRADED A+| ||PROFESSOR
VERIFIED||
Use the SEARCH function in cell D11 to determine the position of
the "#" character in the statement template (cell D9). - ANSWER-
=SEARCH("#",D9)
Use the SEARCH function in cell D12 to determine the position of
the "$" character in the statement template (cell D9). - ANSWER-
=SEARCH("$",D9)
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. - ANSWER-=LEFT(D9,D12)
Use the MID function in cell D14 to return the text "at merchant #"
from the statement template in cell D9. Refer to the location of the
"$" (in cell D12)—adjusted by adding 1—as the "start_num"
argument. Use the difference between the location of the "#"
,2|Page
character (in cell D11) and the "$" character (in cell D12) as the
"num_char" argument. - ANSWER-=MID(D9,D12+1,D11-D12)
Use the RIGHT function in cell D15 to return the text "on:" from
the statement template in cell D9. Use the difference between the
length of the statement template (in cell D10) and the location of
the "#" character (in cell D11) as the "num_char" argument. -
ANSWER-=RIGHT(D9,D10-D11)
Use the MONTH function in cell E18 to calculate the month
portion of the "Time Stamp" in cell B18. Copy and paste your
function down to complete the "Month" column of the table. -
ANSWER-=MONTH(B18)
Use the DAY function in cell F18 to calculate the day portion of
the "Time Stamp" in cell B18. Copy and paste your function down
to complete the "Day" column of the table. - ANSWER-
=DAY(B18)
Use the HOUR function in cell G18 to calculate the hour portion of
the "Time Stamp" in cell B18. Copy and paste your function down
, 3|Page
to complete the "Hour" column of the table. - ANSWER-
=HOUR(B18)
Use the MINUTE function in cell H18 to calculate the minute
portion of the "Time Stamp" in cell B18. Copy and paste your
function down to complete the "Minute" column of the table. -
ANSWER-=MINUTE(B18)
Use the SECOND function in cell I18 to calculate the second
portion of the "Time Stamp" in cell B18. Copy and paste your
function down to complete the "Second" column of the table. -
ANSWER-=SECOND(B18)
Use the CONCAT function (or the CONCATENATE function if you
are using Excel 2013 or earlier) in cell J18 to create the "Date" by
combining the "Month" in cell E18 with the "Day" in cell F18.
"Date" should use this syntax: "Month/Day." Your function should,
therefore, also insert the "/" character between the "Month" and
"Day." Copy and paste your formula down to complete the "Date"
column of the table. - ANSWER-=CONCAT(E18,"/",F18)
WGU C268 SPREADSHEETS EXAM PRE-ASSESSMENT AND OBJECTIVE LATEST
2025 ACTUAL EXAM WITH COMPLETE QUESTIONS AND CORRECT DETAILED
ANSWERS (100% VERIFIED ANSWERS) |ALREADY GRADED A+| ||PROFESSOR
VERIFIED||
Use the SEARCH function in cell D11 to determine the position of
the "#" character in the statement template (cell D9). - ANSWER-
=SEARCH("#",D9)
Use the SEARCH function in cell D12 to determine the position of
the "$" character in the statement template (cell D9). - ANSWER-
=SEARCH("$",D9)
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. - ANSWER-=LEFT(D9,D12)
Use the MID function in cell D14 to return the text "at merchant #"
from the statement template in cell D9. Refer to the location of the
"$" (in cell D12)—adjusted by adding 1—as the "start_num"
argument. Use the difference between the location of the "#"
,2|Page
character (in cell D11) and the "$" character (in cell D12) as the
"num_char" argument. - ANSWER-=MID(D9,D12+1,D11-D12)
Use the RIGHT function in cell D15 to return the text "on:" from
the statement template in cell D9. Use the difference between the
length of the statement template (in cell D10) and the location of
the "#" character (in cell D11) as the "num_char" argument. -
ANSWER-=RIGHT(D9,D10-D11)
Use the MONTH function in cell E18 to calculate the month
portion of the "Time Stamp" in cell B18. Copy and paste your
function down to complete the "Month" column of the table. -
ANSWER-=MONTH(B18)
Use the DAY function in cell F18 to calculate the day portion of
the "Time Stamp" in cell B18. Copy and paste your function down
to complete the "Day" column of the table. - ANSWER-
=DAY(B18)
Use the HOUR function in cell G18 to calculate the hour portion of
the "Time Stamp" in cell B18. Copy and paste your function down
, 3|Page
to complete the "Hour" column of the table. - ANSWER-
=HOUR(B18)
Use the MINUTE function in cell H18 to calculate the minute
portion of the "Time Stamp" in cell B18. Copy and paste your
function down to complete the "Minute" column of the table. -
ANSWER-=MINUTE(B18)
Use the SECOND function in cell I18 to calculate the second
portion of the "Time Stamp" in cell B18. Copy and paste your
function down to complete the "Second" column of the table. -
ANSWER-=SECOND(B18)
Use the CONCAT function (or the CONCATENATE function if you
are using Excel 2013 or earlier) in cell J18 to create the "Date" by
combining the "Month" in cell E18 with the "Day" in cell F18.
"Date" should use this syntax: "Month/Day." Your function should,
therefore, also insert the "/" character between the "Month" and
"Day." Copy and paste your formula down to complete the "Date"
column of the table. - ANSWER-=CONCAT(E18,"/",F18)
