Need an Excel Formula

Create an Excel formula to count correct quiz answers using COUNTIF to tally responses, then hyperlink between PowerPoint and Excel to display scores. Use conditional formatting to highlight results before returning to your presentation.
default-16x9

I have written a multiple choice quiz in PowerPoint. I would like PPT to hyperlink to Excel and compute the number of correct answers. At the end of the quiz, hyperlink to PPT and print the score or the number correct. How do I write a formula or formulas to do this?
Connie Brown

I have written a multiple choice quiz in PowerPoint. I would like PPT to hyperlink to Excel and compute the number of correct answers. At the end of the quiz, hyperlink to PPT and print the score or the number correct. How do I write a formula or formulas to do this?
Connie Brown

One Response

  1. workshop
    Connie,
    Tomorrow TrainingZONE is running an online workshop on Powerpoint. The workshop runs from 13:00 GMT for 1 hour.
    you can log on free of charge at
    https://www.trainingzone.co.uk/workshop

    If you would like to subscribe to the workshop newswire informing you of up and coming training workshops follow the instructions below

    To subscribe to this mailing list, send a message with SUBSCRIBE
    TRAININGZONE-ONLINE-DEBATE in the body of the text to
    mailto:subscribe@trainingzone.co.uk

Newsletter Subscription

Elevate your L&D expertise by subscribing to TrainingZone’s newsletter.

"*" indicates required fields

This field is for validation purposes and should be left unchanged.
Name*
Email*
Privacy*
Additional Options