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

Attachments:

Related Questions

. Introgramming & Unix Fall 2018, CRN 44882, Oakland University Homework Assignment 6 - Using Arrays and Functions in C

DescriptionIn this final assignment, the students will demonstrate their ability to apply two ma

. The standard path finding involves finding the (shortest) path from an origin to a destination, typically on a map. This is an

Path finding involves finding a path from A to B. Typically we want the path to have certain properties,such as being the shortest or to avoid going t

. 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. The LineItem class will represent an individual

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

. SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 1 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of

. Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of Sea Ports. Here are the classes and their instance variables we wish to define:

1 Project 2 Introduction - the SeaPort Project series For this set of projects for the course, we wish to simulate some of the aspects of a number of