100% tevredenheidsgarantie Direct beschikbaar na je betaling Lees online óf als PDF Geen vaste maandelijkse kosten
logo-home
Eerder door jou gezocht
Eerder door jou gezocht
logo
WGU C268 SPREADSHEETS EXAM PREASSESSMENT AND OBJECTIVE ASSESSMENT 2024 | ACCURATE AND VERIFIED EXAM VERSION WITH A STUDY GUIDE AND KNOWLEDGE CHECK FLASHCARDS €20,20
In winkelwagen
Snel navigeren naar
Voorbeeld
  2.  
  3. WGU C268 SPREADSHEETS
  4.  
  5. WGU C268 SPREADSHEETS

Tentamen (uitwerkingen)

WGU C268 SPREADSHEETS EXAM PREASSESSMENT AND OBJECTIVE ASSESSMENT 2024 | ACCURATE AND VERIFIED EXAM VERSION WITH A STUDY GUIDE AND KNOWLEDGE CHECK FLASHCARDS
 3 keer verkocht
  • Vak
  • WGU C268 SPREADSHEETS
  • Instelling
  • WGU C268 SPREADSHEETS

WGU C268 SPREADSHEETS EXAM PREASSESSMENT AND OBJECTIVE ASSESSMENT 2024 | ACCURATE AND VERIFIED EXAM VERSION WITH A STUDY GUIDE AND KNOWLEDGE CHECK FLASHCARDS

Voorbeeld 3 van de 27  pagina's

Document informatie

  • 1 mei 2024
  • 27
  • 2023/2024
  • Tentamen (uitwerkingen)
  • Vragen en antwoorden

Onderwerpen

  • wgu c268
  • wgu c268 spreadsheets exam preassessment and obje
  • wgu c268 spreadsheets exam

Geschreven voor

  • WGU C268 SPREADSHEETS
  • WGU C268 SPREADSHEETS

Verkoper

avatar-seller
DrReiss

Ontvangen beoordelingen

Voorbeeld van de inhoud

WGU C268 SPREADSHEETS EXAM PREASSESSMENT AND OBJECTIVE ASSESSMENT 2024 | ACCURATE AND VERIFIED EXAM VERSION WITH A STUDY GUIDE AND KNOWLEDGE CHECK FLASHCARDS Use the AND function to complete the "Time Bonus?" column of table 1. An employee earns a time bonus if the project's "Hours Worked" are fewer than the "Estimated Hours" and if the work "Quality" is greater than 1. - CORRECT ANSWER =AND(E1 6<C16,H16>1) Use the OR function to complete the "Outcome Bonus?" column of table 1. An employee earns an outcome bonus if the difficulty of a job is greater than 3 or if the quality of their work is equal to 3. - CORRECT ANSWER =OR(G16>3,H16=3) Use the IF function to complete the "Time Bonus $" column of table 1. If an employee earns a time bonus (i.e., the corresponding cell in the "Time Bonus?" column is TRUE), then "Time Bonus $" is the "Job Pay" for that project times the bonus percentage in cell M1 1. Otherwise "Time Bonus $" is 0. - CORRECT ANSWER =IF(I16,K16*$M$11,0) Use the IF function to complete the "Outcome Bonus $" column of table 1. If an employee earns an outcome bonus (i.e., the corresponding cell in the "Outcome Bonus?" column is TRUE), then "Outcome Bonus $" is the "Job Pay" for that project times the outcome bonus percentage in cell M12; otherwise, "Outcome Bonus $" is 0. - CORRECT ANSWER =IF(J16,K16*$M$12,0) Use the IF function to complete the "Comments" column of table 1. Display "G ood Job" if both the "Hours Worked" are less than or equal to the "Estimated Hours" for a project and the assessed "Quality" of that project is greater than 1. Display "Too Much Time" if the "Hours Worked" on a project exceed the "Estimated Hours" for that project; otherwise, display "Poor Quality." - CORRECT ANSWER =IF(AND(E16<=C16,H16>1),"Good Job",IF(E16>C16,"Too Much time","Poor Quality")) Use the VLOOKUP function to complete the "Employee" column of table 2. Use "Job ID" from table 2 as your lookup_v alue(s) and table 1 as the reference table. - CORRECT ANSWER =VLOOKUP(B40,$B$16:$O$35,3,FALSE) Use the VLOOKUP function to complete the "Difficulty" column of table 2. Again, use "Job ID" from table 2 as the lookup_value(s) and table 1 as the reference t able. - CORRECT ANSWER =VLOOKUP(B40,$B$16:$O$35,6,FALSE) Use the COUNTIF function to complete the "# of Jobs" column in table 3. Reference the appropriate field in table 1 as your range and the "Employee" names in table 3 as your criteria. - CORRECT ANS WER =COUNTIF($D$16:$D$35,G39) Use the SUMIF function to complete the "Total Hours" column in table 3. Reference the appropriate field in table 1 as your range and the "Employee" names in table 3 as your criteria. - CORRECT ANSWER =SUMIF($D$16:$D$35,G39,$ E$16:$E$35) Use the SUMIF function to complete the "Total Pay" column in table 3. Reference the "Employee" field in table 1 as your range, the "Employee" names in table 3 as your criteria, and the "Total Pay" field in table 1 as your sum_range. - CORRECT ANSWER =SUMIF($D$16:$D$35,G39,$N$16:$N$35) Use the COUNTIF function to complete the "# of Touch -ups" column in table 4. Reference the appropriate field in table 2 as your range and the "Difficulty" rating in table 4 as your criteria. - CORRECT AN SWER =COUNTIF($D$40:$D$46,G46) Use the SUMIF function to complete the "Cost Touch -ups" column in table 4. Reference the appropriate field in table 2 as your range and the "Difficulty" rating in table 4 as your criteria. - CORRECT ANSWER =SUMIF($D$40:$D$4 6,G46,$E$40:$E$46) 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. - CORRECT ANSWER =AVERAGEIF($G$16:$G$35 ,G46,$E$16:$E$35) Use the LEN function in cell D10 to determine the number of characters in the statement template in cell D9. - CORRECT ANSWER =LEN(D9) Use the SEARCH function in cell D11 to determine the position of the "#" character in the statement template (cell D9). - CORRECT ANSWER =SEARCH("#",D9) Use the SEARCH function in cell D12 to determine the position of the "$" character in the statement template (cell D9). - CORRECT ANSWER =SEARCH("$",D9) Use the LEFT function in cell D13 to return th e 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. - CORRECT ANSWER =LEFT(D9,D12) Use the MID function in cell D14 to return the t ext "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 "#" character (in cell D11) and the "$" character (i n cell D12) as the "num_char" argument . - CORRECT 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 D 10) and the location of the "#" character (in cell D11) as the "num_char" argument. - CORRECT 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 t o complete the "Month" column of the table. - CORRECT 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. - CORREC T 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 to complete the "Hour" column of the table. - CORRECT 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. - CORRECT 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. - CORRECT 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. - CORRECT ANSWER =CONCAT(E18,"/",F18)

Dit zijn jouw voordelen als je samenvattingen koopt bij Stuvia:

Bewezen kwaliteit door reviews

Bewezen kwaliteit door reviews

Studenten hebben al meer dan 850.000 samenvattingen beoordeeld. Zo weet jij zeker dat je de beste keuze maakt!

In een paar klikken geregeld

In een paar klikken geregeld

Geen gedoe — betaal gewoon eenmalig met iDeal, creditcard of je Stuvia-tegoed en je bent klaar. Geen abonnement nodig.

Direct to-the-point

Direct to-the-point

Studenten maken samenvattingen voor studenten. Dat betekent: actuele inhoud waar jij écht wat aan hebt. Geen overbodige details!

Veelgestelde vragen

Wat krijg ik als ik dit document koop?

Je krijgt een PDF, die direct beschikbaar is na je aankoop. Het gekochte document is altijd, overal en oneindig toegankelijk via je profiel.

Tevredenheidsgarantie: hoe werkt dat?

Onze tevredenheidsgarantie zorgt ervoor dat je altijd een studiedocument vindt dat goed bij je past. Je vult een formulier in en onze klantenservice regelt de rest.

Van wie koop ik deze samenvatting?

Stuvia is een marktplaats, je koop dit document dus niet van ons, maar van verkoper DrReiss. Stuvia faciliteert de betaling aan de verkoper.

Zit ik meteen vast aan een abonnement?

Nee, je koopt alleen deze samenvatting voor €20,20. Je zit daarna nergens aan vast.

Is Stuvia te vertrouwen?

4,6 sterren op Google & Trustpilot (+1000 reviews)

Afgelopen 30 dagen zijn er 69411 samenvattingen verkocht

Opgericht in 2010, al 15 jaar dé plek om samenvattingen te kopen

Begin nu gratis
€20,20  3x  verkocht
  • (0)
In winkelwagen
Toegevoegd