Answered step by step
Verified Expert Solution
Question
1 Approved Answer
excel exam Using MS - Excel, Design the following sheet table [ [ Emp _ No , Emp _ Name,Gender, table [ [
excel exam
Using MSExcel, Design the following sheet
tableEmpNoEmpName,Gender,tableCompanyNametableBasicSalaryBonus,Tax,tableNetSalaryAli,MCSSSoso,FCIS,Meme,CSSJaber,MCIS,Nana,ATS,
Answer the following Questions:
Change the name of your sheet to your name.
Find the tax for each employee, the tax depends on the basic salary of the employee, if the basic salary Stax is of the basic salary, if the basic salary between and the tax is of the basic salary and if the basic salary the tax is of the basic salary.
Bonus calculated as follows: if the gender is Male the bonus else the bonus pt
Find the net salary for each employee net salary basic salary Bonus Tax
Find the sum of Net salary for all female employees.
pt
Find the number of employees Works in CSS Company.
pt
Highlight all basic salaries less than $ with blue color and greater than with red color. pt
If the basic salary is less than s an error message appear "error message must contains your name"
Draw a chart between the Emp.name and the net salary
pt
pt
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started