In cell C4, use data validation to warn the user when entering an ID number not equals to 9 digits number. Display the input message as “Fill in your Student ID” when the cell C4 selected by user. Display the error message “Please make sure that you enter

computer science

Description

1.      Inside Information worksheet, write your name in cell C3, your ID in cell C4, today's date in cell C5.

 

a.       In cell C4, use data validation to warn the user when entering an ID number not equals to 9 digits number. Display the input message as “Fill in your Student ID” when the cell C4 selected by user. Display the error message “Please make sure that you enter correct ID equals to 9 digits number” in case of wrong value entered by user.

 

b.      In cell C5, use data validation to warn the user when entering a date that is not equal to today’s date. Display the input message as “Please enter today’s date” when the cell C5 selected by user. Display the error message “Please enter a correct date. You must enter today’s date” in case of wrong value entered by user.

 

 

c.       Select the range from B3 to C5 and create defined names from selection using the left column. And then Paste the list of defined names below your information table in Information worksheet.

2.      Statistics worksheet provides data for citizens from different states with their years of education and yearly earnings, state, race, gender. From this data make the following:

 

a.       In cell I5 enter Number of Females and in cell J5 use the appropriate function to find the number of all Female citizens.

 

b.      In column G add title Bonus and calculate the bonus which is 10% of the citizens’ Yearly Earnings for the ones that have years of education greater than 12.

 

 

3.      Jay Company is a European logistics company based in London and has branches all over Europe, in Jay Company worksheet do following:

 

a.       All full time employees are eligible for a salary increase. Use logical function in the column Salary Increase to display the required values as follows. Employees living in Italy will receive $1000 and the rest will receive $4000. For employees not eligible display NA.

 

b.      Using the lookup table on the right side of the worksheet, in the column Insurance Cost use a lookup function to return the cost of Medical Insurance Packages for each employee.


Related Questions in computer science category