You will create an input box to ask people about their income and the program will display their taxes in a message box

INSTRUCTIONS TO CANDIDATES

ANSWER ALL QUESTIONS

Custom Functions and Creating IF/Then/Else Macro

1. Assume you want to create a calculator that can help people to calculate their taxes. You will create an input box to ask people about their income and the program will display their taxes in a message box. The same message box or another message box should ask the user if he/she has another income to calculate the tax for. If the user click yes, the program should loop but the user click no, the program should exit. Call the procedure Tax. The macro should keep looping until the user click no for having no more income to calculate the taxes for. The program should calculate the tax for one income per time (3 points)

 

1. 35% on income greater than or equal to $200000
2. 29% on income greater than or equal to $70000 and less that $200000
3. 27% on income greater than or equal to $30000 and less that $70000
4. 17% on income greater than or equal to $10000 and less that $30000
5. 12% on income greater than or equal to $3000 and less that $10000
6. Otherwise it will be 0

 

2. Repeat the above question but by creating a function. Ignore the loop part. (2 points)

 

3. Create a macro that helps students find their status in a course. The status depends on midterm exam score, homework points, and attendance status. You need to create one input Box to ask students to enter their mid-term exam score and another input box to ask them about their homework points. The program will also ask the student to insert the total possible points of the homework, midterm exam total possible points, and attendance status in another three input boxes. Then the macro displays their status in a message box. (3 points)

 

• Super: if the student Score in the midterm exam is higher than 92%, in the homework is higher than 90% and attendance status is
• Good: If students’ midterm is higher than 89%, their homework is higher than 80%, and attendance status is good.
• Average: if student’s midterm is higher than 80%, their homework score is above 75% and attendance status is
• Below average: if student’s midterm is higher than 73 %,their homework is higher than 70% and status is
• Poor: for the rest of the

4. Repeat question 3 again by creating a function. There is no need to create inputbox and message box (3 points)

 

5. Assume that you are working as a personal trainer in the ABI Health club. Part of your job responsibilities is to calculate the BMI value for new customers and keep track of their progress. Since Microsoft Excel does not have a built-in function to calculate the BMI value, your task is to create a customized BMI function in order to ease your job responsibilities. Use the BMI worksheet to complete this problem (3 points)

 

1. Use a worksheet called BMI
2. Declare all variables as double
3. Proceed by creating a function to calculate the BMI. The function should be written such as follows:

BMI = weight in Kilo/(height in meter)^2

 

6. Continue working on problem 5, create another function to display the weight status of the customer based on their BMI. Use the following table as a reference for the weight status. (3 points)

 

BMI	Weight Status
Below 18.5	Underweight
18.5 -24.9	Normal
25 - 29.9	Overweight
30 & Above	Obese

 

7. Create a function that multiples value1 by an optional value2(if it exists). Otherwise if there is no value for value 2, check the following conditions: (3 points)

• if value1> 10, multiply value1 by 4
• if value 1>5, then multiply value1 by 3
• if value1>3, then multiply value1 by 2
• otherwise multiply value1 by

Related Questions

. The fundamental operations of create, read, update, and delete (CRUD) in either Python or Java

CS 340 Milestone One Guidelines and Rubric  Overview: For this assignment, you will implement the fundamental operations of create, read, update,

. Develop a program to emulate a purchase transaction at a retail store. This  program will have two classes, a LineItem class and a Transaction class

Retail Transaction Programming Project  Project Requirements:  Develop a program to emulate a purchase transaction at a retail store. This

. The following program contains five errors. Identify the errors and fix them

7COM1028   Secure Systems Programming   Referral Coursework: Secure

. Accepts the following from a user: Item Name Item Quantity Item Price Allows the user to create a file to store the sales receipt contents

Create a GUI program that:Accepts the following from a user:Item NameItem QuantityItem PriceAllows the user to create a file to store the sales receip

. The final project will encompass developing a web service using a software stack and implementing an industry-standard interface. Regardless of whether you choose to pursue application development goals as a pure developer or as a software engineer

CS 340 Final Project Guidelines and Rubric  Overview The final project will encompass developing a web service using a software stack and impleme