Question: Record a macro, QUESTION1, which will ask the user for the department of an employee (through inputbox function) and then calculate percentage of employees from

Record a macro, QUESTION1, which will ask the user for the

Record a macro, QUESTION1, which will ask the user for the department of an employee (through inputbox function) and then calculate percentage of employees from that department who are earning above $45,000 among all employees in the database? Set up criteria on 308, Individual Project 1

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Law Questions!

Record a macro, QUESTION 1 , which will ask the user for the department of an employee ( through inputbox function ) and then calculate percentage of employees from that department who are earning...

Can you help me please Record a macro, QUESTION16 , which will ask the user for the department of an employee (through inputbox function) and then calculate percentage of employees from that...

Record a macro which will ask the user for the department of an employee (through inputbox function) and then calculate percentage of employees from that department who are earning above $45,000...

1. Go to Queries worksheet . Record a macro, QUESTION1 , which will ask the user for the STATES and GENDER of customers (using InputBox functions) and then calculate percentage of people that meets...

2. Record a macro, QUESTION2 , that will ask the user to input the hiring date (using inputbox function) and then calculate number of employees hired on or after that hiring date (e.g., user will...

Record a macro, QUESTION2, that will ask the user to input the hiring date (using inputbox function) and then calculate number of employees hired on or after that hiring date (e.g., user will input...

I am so confused , can I get some help with this question Record a macro, QUESTION14 , that will ask the user to input the hiring/start date (using inputbox function) and then calculate number of...

2 . Record a macro, QUESTION 2 , that will ask the user to input the hiring date ( using inputbox function ) and then calculate number of employees hired on or after that hiring date ( e . g . , user...

I have attached 2 screen shots , this is an excel file and the three sheets are customers , products and then queries. I need help with this question, can I get a step by step explanation please? I...

How can the binding assay technique be used to assign coding triplets to the corresponding amino acids?

Bliss Company owns an asset with an estimated life of 15 years and an estimated residual value of zero; it uses the straight-line method of depreciation. At the beginning of the sixth year, the...

Q 5 : Find the a b s o l u t e maximum and minimum values o f f ( x , y ) = 2 + 2 x + 2 y - x 2 - y 2 o n the triangular region i n the first quadrant bounded b y the lines x = 0 , y = 0 , y = 9 - x .

Two identical small charged spheres are a certain distance apart, and each initially experiences an electrostatic force of magnitude F because of the other. With time, charge gradually diminishes on...

The mixture that you were provided with was composed of a 1:1 ratio of acetylferrocene and ferrocene by mass. Did you recover a 1:1 ratio of the two compounds? Explain any deviation from the expected...

Acetone, C 3 H 6 ), is the main ingredient of nail polish remover. A solution is made up by adding 35.0 ml of acetone (d=0.790g/ml) to 50.0ml of ethyl alcohol, C 2 H 5 OH (d=0.789 g/ml). Assuming...

Lead is a poisonous metal that especially affects children because they retain a larger fraction of lead than adults do. Lead levels of 0.250 ppm in a child cause delayed cognitive development. How...

(a) In a certain country, the car number plate is formed by 4 digits from the digits 1, 2, 3, 4, 5, 6, 7, 8 and 9 followed by 3 letters from the alphabet. How many number plates can be formed if...

Write a program to wish happy birthday to a student. Firstly, take today month and day as an input and secondly take birthday as an input in the form of month and day. If the input day and month...

2. You are asked to provide information to the board of the company you work for. How would you convey this information if the aim is: a) That they will remember the information for a long time. b)...

7. Give examples of information-overload from your everyday life. Review the six consequences that information-overload can lead to and discuss the examples in relation to all the six points.

6. What does it mean when we say that our interpretation of information is dependent on our prior knowledge and our values?