You have two columns, say Age group in column A and purchase in column B. If either Age group is kid or senior citizen and purchase is more that INR 15000 the purchaser gets 10% discount otherwise only 2% discount shall be given. Which of the following formula is correct? a. if(AND((A1="Kid" OR A1="Senior Citizen"),B1>15000), "12%", "2%") b. if((A1="Kid" AND A1="Senior Citizen") OR B1>15000, 12%, 2%) c. if(AND(OR(A1="Kid",A1="Senior Citizen"),B1>15000), "12%", "2%") d. None of these

You have two columns, say Age group in column A and purchase in column B. If either Age group is kid or senior citizen and purchase is more that INR 15000 the purchaser gets 10% discount otherwise only 2% discount shall be given. Which of the following formula is correct? a. if(AND((A1="Kid" OR A1="Senior Citizen"),B1>15000), "12%", "2%") b. if((A1="Kid" AND A1="Senior Citizen") OR B1>15000, 12%, 2%) c. if(AND(OR(A1="Kid",A1="Senior Citizen"),B1>15000), "12%", "2%") d. None of these

Np Ms Office 365/Excel 2016 I Ntermed

1st Edition

ISBN:9781337508841

Author:Carey

Publisher:Carey

Chapter3: Performing Calculations With Formulas And Functions

Section: Chapter Questions

Problem 20RA

See similar textbooks

Similar questions

Lael is always on the lookout for students who might be interested in running for office in student groups.In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future: If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text. Otherwise, the formula should determine if the value in the Finance Certified column is equal to the text "Yes" and return the text Yes if true And No if false. what is the formula to enter into excel?
Lael is always on the lookout for students who might be interested in running for office in student groups.In cell M2, enter a formula using a nested IF function and structured references as follows to determine first if a student has already been elected to office in a student group, and if not, whether that student meets the qualifications to run in the future:a. If the value in the Elected column is equal to the text "Yes", the formula should display Elected as the text.
Use the IF function to calculate the down payment starting in H11. If type = Finance, then the down payment is 10% of the amount. Else, it is equal to the amount.
I need the program to print the line "Meal options:" only when there is enough money. def get_possible_meals(budget, num_persons): tacos_cost = 4 empanandas_cost = 3 max_tacos = budget // tacos_cost max_empanadas = budget // empanandas_cost feasible = False print("\nMeal options:") for num_tacos in range (max_empanadas + 1): num_empanadas = (budget - num_tacos * tacos_cost) // empanandas_cost if num_empanadas > 0andnot (num_empanadas + num_tacos) % num_persons: feasible = True total_cost = num_tacos * tacos_cost + num_empanadas * empanandas_cost change = budget - total_cost print(f'${total_cost} buys {num_empanadas} empanadas and {num_tacos} tacos with ${change} change. {(num_empanadas + num_tacos) // num_persons} items per person.') ifnot feasible: print(f'You cannot buy a meal with these options.') def main(): budget = int(input('Enter budget for meal: $')) num_people = int(input('How many people are eating: ')) get_possible_meals(budget, num_people) if __name__ == '__main__':…
Write a simple interest function that calculates simple interest with VBA. (can be try at excel.)
In cell L16, enter a formula using the AVERAGEIF function that averages the budget amounts for Action movie projects.
Brittany wants to identify employees who are eligible to take a CPR course at the clubs' expense. Employees who can work as camp counselors are eligible for the course. In cell M3, enter a formula using a nested IF function as follows to determine first if an employee has already been trained in CPR, and if not, whether that employee meets the qualifications to take the course: If the value in the CPR Trained column is equal to the text "Yes", the formula should display Trained as the text. Otherwise, the formula should determine if the value in the Camp Counselor column is equal to the text "Yes" and return the text Yes if true and No if false.
Write collection of production rules to calculate electricity bill as per following rules: •If the units consumed are less than and equal to 300, then the cost is Rs 10/- per unit. •If the units consumed are more than 300 and less than and equal to 500, then the cost is Rs 12/- per unit. •If the units consumed are more than 500 and less than 1000, then the cost is Rs 15/- per unit and surcharge of 15% of bill is added. •If the units consumed are more than 1000, then the cost is Rs 15/- per unit and surcharge of 25% of bill is added. Trace the production rules for the sample execution of the system given below;Write collection of production rules to calculate electricity bill as per following rules: •If the units consumed are less than and equal to 300, then the cost is Rs 10/- per unit. •If the units consumed are more than 300 and less than and equal to 500, then the cost is Rs 12/- per unit. •If the units consumed are more than 500 and less than 1000, then the cost is Rs 15/- per unit…
please do the following in c++ A school has 100 lockers and 100 students. All lockers are closed on the first day of school. As the students enter, the first student, denoted S1, opens every locker. Then the second student, S2, begins with the second locker, denoted L2, and closes every other locker. Student S3 begins with the third locker and changes every third locker (closes it if it was open, and opens it if it was closed). Student S4 begins with locker L4 and changes every fourth locker. Student S5 starts with L5 and changes every fifth locker, and so on, until student S100 changes L100.After all the students have passed through the building and changed the lockers, which lockers are open? Write a program to find your answer and display all open locker numbers separated by exactly one space.(Hint: Use an array of 100 bool elements, each of which indicates whether a locker is open (true) or closed (false). Initially, all lockers are closed.)
To be eligible for the leadership training program offered by the office, a student must have at least 2 years of post-secondary education or have gone through the organization finance training. In cell K2 enter a formula using the IF and OR functions and structured references as follows to determine if Kay Colbert can join the leadership training program: The IF function should determine if the student's Post-Secondary Years is greater than or equal to 2 OR if the student's finance certified status is "Yes", returning the text Yes if a student meets one or both of those criteria or the text No if a student meets neither of those criteria. Fill the formula into the range K3:K31, if necessary. What should my IF(OR statement look like?
To be eligible for the leadership training program offered by the office, a student must have at least 2 years of post-secondary education or have gone through the organization finance training.In cell K2 enter a formula using the IF and OR functions and structured references as follows to determine if Kay Colbert can join the leadership training program: The IF function should determine if the student's Post-Secondary Years is greater than or equal to 2 OR if the student's finance certified status is "Yes", returning the text Yes if a student meets one or both of those criteria or the text No if a student meets neither of those criteria. What is the formula to perform this in Excel?
Please note that on the last line of the code, we need to print out the 'and" with the smallest and the largest number for min and max functions in order to maximize our credit with the zyBooks lab assignment for 3.9. Code Hints: smallestnum = min(usernumbers) #The smallest number is printed out - for example 5, 10, 15 - 5 would be printed out largestnum = max(usernumbers) #The largest number is printed out - for example 5, 10, 15 - 15 would be printed out Write a program that reads a list of integers into a list as long as the integers are greater than zero, then outputs the list values and the smallest and largest integers in the list using min and max built-in functions . This code runs in zyBooks..... Ex: If the input is: 10 5 3 21 2 -6 the output is: [10, 5, 3, 21, 2] 2 and 21 user_numbers = [] user_input = int(input())while user_input > 0: user_numbers.append(user_input) user_input = int(input())print(user_numbers) ''' Complete code here.…