Answer to Question #242846 in Excel for avinash reddy

Question

Create a excel sheet and name it as Student_Attendance sheet with the following columns

a.      S.No , RegId, Name, Gender, Lectures Attended, Lectures Delivered, Attendance percentage.

(Note : Attendance percentage = LecturesAttended/LecturesDelivered * 100)

a.      Highlight Column Headings with background color and a different text color. Also Use text Rotation.

2.      Add data validation on

a.      Lectures Delivered Column to make sure that lectures delivered should be exactly equal to 45 for every student.

b.     Lectures Attended Column to make sure that lectures Attended should be less than or equal to 45

c.      Gender column to make sure user should be able to enter only two values i.e. Male or Female.

Note: For every validation, generate an error message in case of incorrect input.(10)

Answer 1

Dear avinash reddy, your question requires a lot of work, which neither of our experts is ready to perform for free. We advise you to convert it to a fully qualified order and we will try to help you. Please click the link below to proceed: Submit order