Excel quiz pptx
Download as PPTX, PDF
0 likes511 views
This document provides instructions and content for an Excel quiz. It includes cells that check answers and count correct responses, using formulas like =IF() and =COUNTIF(). Conditional formatting is also used to color cells green for right answers and red for wrong answers. Photos are included to help answer questions on the quiz.
Excel quiz pptx
- 1. EXCEL QUIZ By Xavier Juhala
- 2. This cell tells you if you are wrong or right This cell counts how many =IF(A17=jolly ranchers,correct,wrong) answers you got right =COUNTIF(A5:P65,correct) This is conditional formatting, when you get a correct answer the cell turns green if you get it wrong the cell turns red. = specific test, containing, correct, wrong
- 3. This is the title and the instructions Photos to help you answer the questions