Instructions
Advanced Excel Retake Instructions
1 - In sheet "Userform" : design a scroll bar, a dropdown list, a button and dynamic picture over the dedicated frames
a - The scrollbar will allow you to choose a number of days from 1 to 15 - This number must be displayed in the white cell "B18"
b- The dropdown list will allow you to select an engineer from the list in sheet "Data" and must display the first name and the last name
c - The picture of the selected engineer (available in sheet "Data" as well) must be displayed in the dedicated frame
2 - Using the daily wage of the selected engineer and the number of booked days, write a formula in the cell "I18" that will calculate the total cost for the booking
3 - Hide the cells outside the userform ( delimited by the colored cells)
4 - Insert any kind of button over the button frame and create a macro that will proceed the following : When clicking on the button, it must record on sheet "Records" the choices you have made on the interface :
Everytime you click on it, it must add a row to the table ( pink cells) with the date of the booking, the number of days, the name of the selected engineer and the total cost
5 - Protect Sheet "Userform" from any change except the one that are made through the controls ( the controls must remain usable)
SousAnneau
6505_resit_exam_2021.xlsm
