Question: Task 3 4 / 6 points Use the LEFT function in cell C 5 to return the text Employee number from the Text Stamp Phrase

Task 3
4/6 points
Use the LEFT function in cell C5 to return the text "Employee number" from the "Text Stamp Phrase" in cell C2. Notice the space after number.
[-2] The formula in cell C5
does not reference C4
Task 4
4/6 points
Use the SEARCH function in cell
C6 to determine the position of the characters " HH"(notice the space before the first H) in the
"Text Stamp Phrase" in cell C2.
[-2] The value in cell C6 is not
correct
Task 8
2/5 points
Use the MINUTE function in cell
E12 to calculate the "Minute" portion of the "Entry Swipe" found in cell C12. Copy and paste the function down to complete the "Minute" column of the table.
[-1) The formula in cell E12
does not reference C12
(-2)
The value in cell 12 is not correct

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!