{"interactiveVideo":{"video":{"startScreenOptions":{"title":"Interactive Video","hideStartTitle":false},"textTracks":{"videoTrack":[{"label":"Subtitles","kind":"subtitles","srcLang":"en"}]},"files":[{"path":"https:\/\/youtu.be\/3ROTxQRnJQQ","mime":"video\/YouTube","copyright":{"license":"CC BY-NC-SA","title":"Conditional Formatting using Highlight Duplicates","author":"Pamela LeBrun","year":"2019","version":"4.0"}}]},"assets":{"interactions":[{"x":41.85022026431718,"y":29.354207436399214,"width":10,"height":10,"duration":{"from":9,"to":13},"libraryTitle":"Multiple Choice","action":{"library":"H5P.MultiChoice 1.16","params":{"media":{"disableImageZooming":false},"answers":[{"correct":false,"tipsAndFeedback":{"tip":"","chosenFeedback":"

Nice try, but not quite right! Choose again<\/div>\n","notChosenFeedback":""},"text":"

Insert Tab<\/div>\n"},{"correct":true,"tipsAndFeedback":{"chosenFeedback":"

Good Job! It is found on the Home tab in the styles group.<\/div>\n","tip":"","notChosenFeedback":""},"text":"

Home Tab<\/div>\n"},{"correct":false,"tipsAndFeedback":{"tip":"","chosenFeedback":"

Nice try, but not quite right! Choose again<\/div>\n","notChosenFeedback":""},"text":"

Data Tab<\/div>\n"}],"overallFeedback":[{"from":0,"to":100}],"behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"type":"auto","singlePoint":false,"randomAnswers":true,"showSolutionsRequiresInput":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false,"passPercentage":100,"showScorePoints":true},"UI":{"checkAnswerButton":"Check","showSolutionButton":"Show solution","tryAgainButton":"Retry","tipsLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","tipAvailable":"Tip available","feedbackAvailable":"Feedback available","readFeedback":"Read feedback","wrongAnswer":"Wrong answer","correctAnswer":"Correct answer","shouldCheck":"Should have been checked","shouldNotCheck":"Should not have been checked","noInput":"Please answer before viewing the solution","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"question":"

I can find the Conditional Formatting feature on:<\/p>\n"},"subContentId":"e16103f6-980f-44e5-81f3-bff29b17783b","metadata":{"contentType":"Multiple Choice","license":"U","title":"Untitled Multiple Choice"}},"pause":true,"displayType":"button","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":"

Test your knowledge!<\/p>\n"},{"x":47.797356828193834,"y":46.08610567514677,"width":10,"height":10,"duration":{"from":115.382,"to":117},"libraryTitle":"Single Choice Set","action":{"library":"H5P.SingleChoiceSet 1.11","params":{"choices":[{"subContentId":"c189eced-d37a-4062-9914-34f16bd197f9","question":"

What will happen when we fix the Employee ID in the scenario?<\/p>\n","answers":["

The conditional formatting rule will clear.<\/p>\n","

The color will change on the conditional formatting rule to show the change.<\/p>\n"]}],"overallFeedback":[{"from":0,"to":100,"feedback":"Nice Job! This clears the rule."}],"behaviour":{"autoContinue":true,"timeoutCorrect":2000,"timeoutWrong":3000,"soundEffectsEnabled":true,"enableRetry":true,"enableSolutionsButton":true,"passPercentage":100},"l10n":{"nextButtonLabel":"Next question","showSolutionButtonLabel":"Show solution","retryButtonLabel":"Retry","solutionViewTitle":"Solution list","correctText":"Correct!","incorrectText":"Incorrect!","muteButtonLabel":"Mute feedback sound","closeButtonLabel":"Close","slideOfTotal":"Slide :num of :total","scoreBarLabel":"You got :num out of :total points","solutionListQuestionNumber":"Question :num","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."}},"subContentId":"91c67d1f-4771-4565-9779-34c369c86571","metadata":{"contentType":"Single Choice Set","license":"U","title":"Untitled Single Choice Set"}},"pause":true,"displayType":"button","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":"

Take your best guess!<\/p>\n"},{"x":47.797356828193834,"y":46.08610567514677,"width":10,"height":10,"duration":{"from":148.675,"to":150},"libraryTitle":"Statements","action":{"library":"H5P.Summary 1.10","params":{"intro":"Choose the correct statement.","summaries":[{"subContentId":"53b1b1a5-b52d-4717-a00e-83a00dc68f78","summary":["

I should check the employee list before deleting or overwriting values from the database.<\/p>\n","

You don't need to check if it's a duplicate or a mistake in data entry before deleting or overwriting the data.<\/p>\n"],"tip":"

It's always a good idea to verify information before deleting it.<\/p>\n"}],"overallFeedback":[{"from":0,"to":100}],"solvedLabel":"Progress:","scoreLabel":"Wrong answers:","resultLabel":"Your result","labelCorrect":"Correct.","labelIncorrect":"Incorrect! Please try again.","alternativeIncorrectLabel":"Incorrect","labelCorrectAnswers":"Correct answers.","tipButtonLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","progressText":"Progress :num of :total"},"subContentId":"61249e76-0147-4bda-ad76-c4e8d71e54f9","metadata":{"contentType":"Summary","license":"U","title":"Untitled Summary"}},"pause":true,"displayType":"button","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""}},"label":"

What do you think?<\/p>\n"},{"x":47.797356828193834,"y":46.08610567514677,"width":10,"height":10,"duration":{"from":197.626,"to":200},"libraryTitle":"Fill in the Blanks","action":{"library":"H5P.Blanks 1.14","params":{"media":{"disableImageZooming":false},"text":"Fill in the missing words","overallFeedback":[{"from":0,"to":100}],"showSolutions":"Show solution","tryAgain":"Retry","checkAnswer":"Check","notFilledOut":"Please fill in all blanks to view solution","answerIsCorrect":"':ans' is correct","answerIsWrong":"':ans' is wrong","answeredCorrectly":"Answered correctly","answeredIncorrectly":"Answered incorrectly","solutionLabel":"Correct answer:","inputLabel":"Blank input @num of @total","inputHasTipLabel":"Tip available","tipLabel":"Tip","behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"autoCheck":false,"caseSensitive":true,"showSolutionsRequiresInput":true,"separateLines":false,"confirmCheckDialog":false,"confirmRetryDialog":false,"acceptSpellingErrors":false},"scoreBarLabel":"You got :num out of :total points","confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"questions":["

Conditional Formatting is a great feature to help *find\/locate\/highlight:discover through highlighting rules * values that are repeated in a dataset.<\/p>\n"],"a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again.","a11yCheckingModeHeader":"Checking mode"},"subContentId":"da951f3d-54ee-4375-9f6a-1611aa397031","metadata":{"contentType":"Fill in the Blanks","license":"U","title":"Untitled Fill in the Blanks"}},"pause":true,"displayType":"button","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":"

Final Test!<\/p>\n"},{"x":47.797356828193834,"y":46.08610567514677,"width":10,"height":10,"duration":{"from":64.343,"to":66},"libraryTitle":"Multiple Choice","action":{"library":"H5P.MultiChoice 1.16","params":{"media":{"disableImageZooming":false},"answers":[{"correct":true,"tipsAndFeedback":{"tip":"","chosenFeedback":"","notChosenFeedback":""},"text":"

Duplicate Values<\/div>\n"},{"correct":false,"tipsAndFeedback":{"chosenFeedback":"

Try again!<\/div>\n","tip":"","notChosenFeedback":""},"text":"

Greater Than<\/div>\n"},{"correct":false,"tipsAndFeedback":{"chosenFeedback":"

Try again!<\/div>\n","tip":"","notChosenFeedback":""},"text":"

Before<\/div>\n"}],"overallFeedback":[{"from":0,"to":100}],"behaviour":{"enableRetry":true,"enableSolutionsButton":true,"enableCheckButton":true,"type":"auto","singlePoint":false,"randomAnswers":true,"showSolutionsRequiresInput":true,"confirmCheckDialog":false,"confirmRetryDialog":false,"autoCheck":false,"passPercentage":100,"showScorePoints":true},"UI":{"checkAnswerButton":"Check","showSolutionButton":"Show solution","tryAgainButton":"Retry","tipsLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","tipAvailable":"Tip available","feedbackAvailable":"Feedback available","readFeedback":"Read feedback","wrongAnswer":"Wrong answer","correctAnswer":"Correct answer","shouldCheck":"Should have been checked","shouldNotCheck":"Should not have been checked","noInput":"Please answer before viewing the solution","a11yCheck":"Check the answers. The responses will be marked as correct, incorrect, or unanswered.","a11yShowSolution":"Show the solution. The task will be marked with its correct solution.","a11yRetry":"Retry the task. Reset all responses and start the task over again."},"confirmCheck":{"header":"Finish ?","body":"Are you sure you wish to finish ?","cancelLabel":"Cancel","confirmLabel":"Finish"},"confirmRetry":{"header":"Retry ?","body":"Are you sure you wish to retry ?","cancelLabel":"Cancel","confirmLabel":"Confirm"},"question":"

After choosing Highlight Cell Rules, what would you choose next?<\/p>\n"},"subContentId":"f33eaf8e-c973-4fdd-a5f6-6e6335df3f72","metadata":{"contentType":"Multiple Choice","license":"U","title":"Untitled Multiple Choice"}},"pause":true,"displayType":"button","buttonOnMobile":false,"adaptivity":{"correct":{"allowOptOut":false,"message":""},"wrong":{"allowOptOut":false,"message":""},"requireCompletion":false},"label":"

What do you think?<\/p>\n"}]},"summary":{"task":{"library":"H5P.Summary 1.10","params":{"intro":"Choose the correct statement.","summaries":[{"subContentId":"5723b2b0-dc36-4c97-b311-87d4f4b191b4","tip":"","summary":["

Now try it on your own! Go to the activity in MindTap and complete the training and Module for Conditional formatting.<\/p>\n"]}],"overallFeedback":[{"from":0,"to":100}],"solvedLabel":"Progress:","scoreLabel":"Wrong answers:","resultLabel":"Your result","labelCorrect":"Correct.","labelIncorrect":"Incorrect! Please try again.","alternativeIncorrectLabel":"Incorrect","labelCorrectAnswers":"Correct answers.","tipButtonLabel":"Show tip","scoreBarLabel":"You got :num out of :total points","progressText":"Progress :num of :total"},"subContentId":"6b5eaaf1-1d4d-4ccb-bdb1-556bffea54bd","metadata":{"contentType":"Summary","license":"U","title":"Untitled Summary"}},"displayAt":3}},"override":{"autoplay":false,"loop":false,"showBookmarksmenuOnLoad":false,"showRewind10":false,"deactivateSound":false,"preventSkippingMode":"none"},"l10n":{"interaction":"Interaction","play":"Play","pause":"Pause","mute":"Mute","unmute":"Unmute","quality":"Video Quality","captions":"Captions","close":"Close","fullscreen":"Fullscreen","exitFullscreen":"Exit Fullscreen","summary":"Summary","bookmarks":"Bookmarks","endscreen":"Submit screen","defaultAdaptivitySeekLabel":"Continue","continueWithVideo":"Continue with video","playbackRate":"Playback Rate","rewind10":"Rewind 10 Seconds","navDisabled":"Navigation is disabled","sndDisabled":"Sound is disabled","requiresCompletionWarning":"You need to answer all the questions correctly before continuing.","back":"Back","hours":"Hours","minutes":"Minutes","seconds":"Seconds","currentTime":"Current time:","totalTime":"Total time:","singleInteractionAnnouncement":"Interaction appeared:","multipleInteractionsAnnouncement":"Multiple interactions appeared.","videoPausedAnnouncement":"Video is paused","content":"Content","answered":"@answered answered","endcardTitle":"@answered Question(s) answered","endcardInformation":"You have answered @answered questions, click below to submit your answers.","endcardInformationNoAnswers":"You have not answered any questions.","endcardInformationMustHaveAnswer":"You have to answer at least one question before you can submit your answers.","endcardSubmitButton":"Submit Answers","endcardSubmitMessage":"Your answers have been submitted!","endcardTableRowAnswered":"Answered questions","endcardTableRowScore":"Score","endcardAnsweredScore":"answered","endCardTableRowSummaryWithScore":"You got @score out of @total points for the @question that appeared after @minutes minutes and @seconds seconds.","endCardTableRowSummaryWithoutScore":"You have answered the @question that appeared after @minutes minutes and @seconds seconds."}}

Excel- Conditional Formatting

Pamela LeBrun