Completing the input structures 4 MS Excel Workshop 1.Go to Campusnet and download the file
others
Description
Part 1: Completing the input structures 4 MS Excel Workshop 1.Go to Campusnet and download the file “Questionnaire.xlsx” 2. Complete the following missing control structures in the sheet “Questionnaire”: • A drop-down list in L10 with the persons named in the Identification sheet • Three Check Boxes in H18, J18, and L18. When the check boxes are activated, the respective fields H19 J19 and L19 shall become white. • The option buttons in the three last rows of the table with the Hot IT topics 3. Calculate the sum in N19! If no values are provided the field shall be empty. 4. Put a formula to field O5 that indicates the completion state of the whole questionnaire in percent. Add a conditional formatting according to the following rules: • The cell is red, when less than 45% are filled • The cell is yellow, when 45 % to 84% are filled • Above 84% it is green • Hint: You may use an extra column Martin Adam Part 2: Validating and exporting the data 5 MS Excel Workshop 1. Insert a button above the whole questionnaire that triggers a sub validating the data according to the following rules: • The total costs of 2.1, 2.2 (in sum), and 2.3 (separately) must equal the total costs in H58 unless the user has clicked “(complete) statement not possible”. In this case, no validation is performed for the whole cost block. • If an error occurs, the user show receive a message box that indicates where the error is (i.e. in 2.1 and 2.2 or 2.3) • The erroneous cells should be colored using VBA
