Create 50-items Unit Test exam using Spreadsheet

   Create 50- Items Unit Test Exam using Spreadsheet

(Required Function: if answer is correct, font color will turn GREEN. Else, Red)

   Spreadsheet is assigned using computation, documentation and making test exam. In other hand, spreadsheets are design for formulation that help easily computing and tabulation of the data. A good assessment and evaluation to the students in automatically computed their grades, performance and test results. In the required function to the correct and wrong answers they provided of conditional formatting in assigning the respective value and colors to the correct answer and acceptable value in the said command, the wrong answer may take a respective color in the designate command if turned red if the choosing color is red the same as the correct answer.

Steps in Create Unit Test Exam using Spreadsheet:

1. Choose your subject topic making your Unit Test Exam.

2. Type your Headings in your document and attach if logos needed.

3. Type your direction in your Test Exam to make sure to understand the test taker.

4. Continue, let’s proceeding the questions and indicate the choices answer.

5. After the 50 items done, formulated the indicate formulas.

6. Go to conditional formatting to assign the respective colors for the value itself on the test exam.

7. Highlighted each formula to copy paste all the designated formulas each column.

8. Go to print preview to notice the final output. 

Printed: