Using VBA program and using excel Write a function which takes as input a planet name and returns a message as follows: If the planet is not on the list then return “Pick another planet”. If the temperature is less than -80 or greater than +80, or the oxygen level is less than 10, or the radiation level is Lethal, return “x is not habitable” where x is the name of the planet. If the temperature is between 0 and 30, the oxygen level is at least 20, and the radiation level is None, return “x is ideal” where x is the name of the planet. Otherwise return “x is habitable, but not ideal” where x is the name of the planet.

Using VBA program and using excel Write a function which takes as input a planet name and returns a message as follows: If the planet is not on the list then return “Pick another planet”. If the temperature is less than -80 or greater than +80, or the oxygen level is less than 10, or the radiation level is Lethal, return “x is not habitable” where x is the name of the planet. If the temperature is between 0 and 30, the oxygen level is at least 20, and the radiation level is None, return “x is ideal” where x is the name of the planet. Otherwise return “x is habitable, but not ideal” where x is the name of the planet.

C++ Programming: From Problem Analysis to Program Design

8th Edition

ISBN:9781337102087

Author:D. S. Malik

Publisher:D. S. Malik

Chapter15: Recursion

Section: Chapter Questions

Problem 20PE

See similar textbooks

Similar questions

ATM machines allow 4 or 6 digit PIN codes and PIN codes cannot contain anything but exactly 4 digits or exactly 6 digits. Your task is to create a function that takes a string and returns true if the PIN is valid and false if it's not. Examples validatePIN("1234") ➞ true validatePIN("12345") ➞ false validatePIN("a234") ➞ false validatePIN("") ➞ false Notes ● Some test cases contain special characters. ● Empty strings must return false.
In Python Text-based adventure game: Pretend you are creating a text-based adventure game. At different points in the game, you want the user to select to fight, run, or hide from certain enemies. The selection variable must be sent as an argument into the choice() function. The user should enter 1 to fight, 2 to run, or 3 to hide in the main(). The choice() function should print one of the three options. Add an if statement in the choice() function to make the correct selection.
Domino's Time Function Name: dominosTime() Parameters: N/A Returns: None Description: During the summer, you ordered a lot of food from Domino's. Pizzas are $12, an order of pasta is $6, and chicken wings are $8. Write a function that asks the user how many of each food item they would like, and then print a response telling them what their order to- tal will be. The order total should be an integer. >>> dominosTime() How many pizzas do you want? 3 How many orders of pasta do you want? 2 How many orders of chicken wings do you want? 2 By ordering 3 pizzas, 2 orders of pasta, and 2 orders of chicken wings, your order total comes to $64.
A business law class of 25 students takes a midterm exam that has 100 true- or-false questions. The instructor, who is also a computer fanatic, wants to devise a program to obtain a printout with the student's name, score, and letter grade, according to the following schedule: 50 or below F 51 - 55 D 56 – 60 C- 61 - 65 66 – 70 C+ 71 - 75 B- 76 - 80 81 - 85 86 – 90 B B+ А- 91 - 95 A 96 – 100 A+ In addition, the instructor wants to include the total number of students scoring each of the 11 possible grades. How would you use the FORTRAN language to solve his problem?
In c language Using function strtod(), Create a character string that contains the following string: “78.3% is the average success rate” Divide this string into double and display the rest of the string The output will be: The original string is: 78.3% is the average success rate The extracted double value is: 78.3 The remainder of the string is: % is the average success rate
Where F is the Fahrenheit temperature and C is the Celsius temperature. Write a function named celsius that accepts a Fahrenheit temperature as an Argument. The function should return the temperature to Celsius. Demonstrate the function by calling it in a loop that displays a table of the Fahrenheit temperatures 0 through 20 and their Celsius equivalents python
In C++ please, using basic programming one coding The main menu should show the available options: Show the roster: Displays all the player names and jersey numbers in a numbered list. Ex: 1. Susan Martinez (33), 2. Jake Smith (21), etc. Add a player: Prompts the user to type the player's full name and jersey number. Then adds the player to the roster. Remove a player: Displays the roster and prompts the user to enter the number of the player to remove. Then removes the player from the roster. Quit: Quits the program. The program should display the main menu after the user shows the roster, adds a player, or removes a player. The program only terminates when the user chooses the quit option. Data validation should be used where appropriate. Ex: The user should not be able to choose an option that doesn't exist or delete a player that doesn't exist. The roster should be kept in alphabetic order by the players' full names. Ex: If Alice Chang (9) is added to a roster with Jake Smith and…
On one day a year a programming club at AOU hosts a tournament. Each entrant is recorded in the appropriate tournament category on arrival and is registered a corresponding level. Participants in level one will be entered in the basic training and competition; participant in level two and three will be entered in the intermediate training and competition; those in level 4 will be entered in the junior competition. ⦁ You are required to write an algorithm which is required to decide the appropriate category for the entrant; Display the entrant’s in a list for that category and output the corresponding level. Hint[The tutor will keep registering the students until he pressed -1 to stop and exit from the loop ] ⦁ Build your algorithm by OUbuild and provide screenshots for the output
menu(): Takes no inputs and does not return a value. It prints the two options available to the user and asks them to enter a number corresponding to their desired option. It then asks the user for the required inputs and then calls the appropriate function and prints the return value with an appropriate message (see below). If the user enters a number corresponding to an invalid option, Invalid choice. should be printed and the program should end. When the program ends, Have a nice day! should be printed to the user. If the user asks the program to solve an equation, then the program should ask the user to type in the equation (without spaces). If a solution is found, then print Solution found: followed by the solution as a list. If no solution was found, print No solution found. If the user asks the program to create an equation, then the program should ask the user to enter the number of tries, length of the equation and percentage for a number to have additional digits. If an…
True/False 6. In Python, a function can return only one value.
* Question Completion Status: A Moving to another question will save this response. Question 9 Given the function F(X,Y,Z) =XZ + Z(X'+ XY), the equivalent, most simplified Boolean representation for F is O a. Z+XYZ O b.XZ O c. Z O d.Z+YZ A Moving to another question will save this response. مشمس 36°C
IN PYTHON Write a script which uses the input function to read a string, an int, and a float, as input from keyboard prompts the user to enter his/her name as string, his/her age as integer value, and his/her income as a decimal. For example your output will display as: Mark is 30 years old and his income is 2000 Please show code.