Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

excel exam Using MS - Excel, Design the following sheet table [ [ Emp _ No , Emp _ Name,Gender, table [ [

excel exam
Using MS-Excel, Design the following sheet
\table[[Emp_No,Emp_Name,Gender,\table[[Company],[Name]],\table[[Basic],[Salary]],Bonus,Tax,\table[[Net],[Salary]]],[10,Ali,M,CSS,500,,,],[20,Soso,F,CIS,800,,,],[30,Meme,F,CSS,1200,,,],[40,Jaber,M,CIS,5400,,,],[50,Nana,F,ATS,1500,,,],[,,,,,,,]]
Answer the following Questions:
1- Change the name of your sheet to your name.
2- Find the tax for each employee, the tax depends on the basic salary of the employee, if the basic salary >2000 Stax is 6% of the basic salary, if the basic salary between 2000 and 1000 the tax is 4% of the basic salary and if the basic salary 1000 the tax is 2% of the basic salary.
3- Bonus calculated as follows: if the gender is Male (M) the bonus =1005 else the bonus =505(1pt)
4- Find the net salary for each employee (net salary = basic salary + Bonus - Tax).
5- Find the sum of Net salary for all female employees.
(1pt)
6- Find the number of employees Works in CSS Company.
(1 pt)
7- Highlight all basic salaries less than 1000$ with blue color and greater than 1500 with red color.(1 pt)
8- If the basic salary is less than 300 s an error message appear "error message must contains your name"
9- Draw a chart between the Emp.-name and the net salary
(1 pt)
(1 pt)
image text in transcribed

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Main Memory Database Systems

Authors: Frans Faerber, Alfons Kemper, Per-Åke Alfons

1st Edition

1680833243, 978-1680833249

More Books

Students also viewed these Databases questions

Question

4. Identify cultural variations in communication style.

Answered: 1 week ago