XCEL VBA (a) Write a user-defined function called SumStop which takes an integer n as an input and adds up the values of the cells in row 1 (starting from cell A1) until the value of the sum exceeds n, and then outputs the number of cells used. You may assume that all of the cells in row 1 contain numbers. Use a suitable Do While loop and the cells command. Declare all variable types and include appropriate comments in your code.

a) Request the lower bound, lower and the upper bound, upper from the console.b) Request an increment value incVal from the console.c) Use a while loop to increment from lower to upper by increments of incVal such as 0 3 6 9 12 given lower of 0and upper of 12 and increment of 3.d) Use a while loop to vertically print all values in between each increment.e) Use a for loop to vertically print all values in between each increment.

Why did you dismiss my question, If you are unsure about the answer, leave it to others. However, don't give a plagiarized or AI created response. Sure, I'll take serious action.

>> classicVinyls.cpp For the following program, you will use the text file called "vinyls.txt" attached to this assignment. The file stores information about a collection of classic vinyls. The records in the file are like the ones on the following sample: Led_Zeppelin Led_Zeppelin 1969 1000.00 The_Prettiest_Star David_Bowie 1973 2000.00 Speedway Elvis_Presley 1968 5000.00 Spirit_in_the_Night Bruce_Springsteen 1973 5000.00 ... Write a declaration for a structure named vinylRec that is to be used to store the records for the classic collection system. The fields in the record should include a title (string), an artist (string), the yearReleased (int), and an estimatedPrice(double). Create the following...

Provide description on how to use the code. Code is located below: # initialize a flag variable with 0flag = 0 # loop will execute till flag is 0 in the sense loop will execute codewhile flag == 0 : #until amount is greater then costcost = float(input("Enter the cost: ")) # take input cost and convert to floating data typeamount = float(input("Enter the amount given(should be greater than cost): ")) # take inputif amount < cost :print("Amount should be greater than cost.") #print statement saying enter Amount thatelse:flag = 1 # when amount entered by user greater then cost flag is set to 1 and while loop will not execute change = amount-cost #stored difference between amount and cost to change variableprint(f"The change to be given is ${change}") #print the value of change variable twenty=0 #intializing all possible coin/ notes to 0ten=0five=0single=0quarter=0dime=0nickel=0penny=0 while change>=20 : #loop will execute until change become less then 20. this loop execute for...

Create a Raptor flowchart and name the file Software Discountslname where Iname is YOUR last name. Here is the problem to solve: A software company sells a package that retails for 99ドル. Quantity discounts are given according to the following table: Quantity Discount 10-19 20% 20-99 30% 100 or more 40% Use the flowchart on the next page as a guide. You will need to fill in the conditions or Boolean expressions in the selection structures, using the variables that are indicated in the model on the next page. Do not add any variables. Fill in the missing assignment statements in the selection structures. Last, fill in the three assignment boxes to calculate: 1) the amount the customer owes before the discount (quantity times the price of one software package) 2) the amount of the discount (you've already calculated the discountRate in the selection structure) and 3) the amount the customer owes after the discount is applied Output the information to the user. Test your program 4 times,...

display_b bout BOOK Haven". The function should output the following details: Welcome message and store location List of available book genres (Fiction, Mystery, Science Fiction, Fantasy, Non-Fiction) Current promotion ("Buy 2, Get 1 Free on all paperback books!") Customer service information ("For any inquiries, reach out to our customer service at 1-800-987-6543.") Store hours for each day of the week Contact information with a dedicated support email (info@bookhaven.com) Call the function to display the information.

Question 14 papa .Full explain this question and text typing work only We should answer our question within 2 hours takes more time then we will reduce Rating Dont ignore this line

Which is correct option for below question. Options are 0,7,none of these. With proper explanation

LAB ASSIGNMENTS IMPORTANT: you should complete the PDP thinking process for each program. Turn in items: 1) fullname_regex.py - Ask the user to enter the source text to search, such as the name_source variable here: name_source = input('Enter full name in this format - first middle last'). Then, you can adapt the first two code lines from lesson slide 13, to search this new source. Edit the code to match the new situation and change the regex pattern to identify text that could be a full name. Hints: Initially write your regex pattern to check if the user enters three words separated by a space. Then, strive to make the regex adaptable if the person's full name has more than or less than 3 words. Then, think about allowing (not requiring) common characters like a period, hyphen or '. Slides 11-13 should be helpful. 08 For printing, end with a conditional block that provides an appropriate message if there is a match or not. Match Enter your full name: first middle last Betty Lou Who...

Create a function using a "while" loop. The function asks the user to input a number between 10 and 20. If the number is not within the specified limits, the user must change his/her input until he/she enters the correct value.

Again, modify the while loop to utilize tolower() or toupper(). Create two more functions (options #3 and #4 in your menu) by taking the to_kilograms() and to_pounds() functions and modifying them to use reference variables instead of normal pass by value variables. Name them: to_kilograms_ref() to_pounds_ref() Create another two functions (options #5 and #6 in your menu) by taking the to_kilograms() and to_pounds() functions and modifying them to use pointers instead of normal pass by value variables. Name them: to_kilograms_ptr() to_pounds_ptr() Your new Menu should look like this, which includes what type of variables are being used: MENU 1. Kilograms to Pounds (pass by value) 2. Pounds to Kilograms (pass by value) 3. Kilograms to Pounds (pass by reference) 4. Pounds to Kilograms (pass by reference) 5. Kilograms to Pounds (using pointers) 6. Pounds to Kilograms (using pointers) Example: #include <iostream> #include <cmath>...

Cs10-8 A19 3Q2122 FALL BIMT) WEEK 4 Math Expression with Variables (with log, exp and trig functions) My Solutions> Code has aiready been provided to create the four variables a, b, c, and d. Add commands to evaluate the following expressions using these variables and assign the results to the indicated variable names: A,a cosc+d Assign the result for A, to the variable Answeri. Note that the values of b, c, and d defined in the given code are all in radians. 4,=d-In/ Assign the result for Az to the variable Answer2. Note the absolute value of the argument to the logarithm. sin +4)) Assign the result for A, to the variable Answer3. Note that e in this expression is the exponential function. Script e H Save C Reset E MATLAB 1 %Define variables a, b, c, and d 2 a = 2.2; 3b = 5.1; 4 C = -3.13; 5 d = 1.8; 6 7 %Enter commands to evaluate the expressions and assign the results 8%to the variable names given in the problem statement. Note the values of the variables 9 %a, b, c, and d are...