(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 2 (starting from cell B2) 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 2 contain numbers. Use a suitable Do While loop and the cells command. Declare all variable types and include appropriate comments in your code. (b) Write a user-defined function called NoSpace which takes a string as input and outputs the same string with all of the spaces removed. For example, given the string The quick brown fox it should return the string Thequickbrownfox Use a a suitable loop, declare all variable types, and include appropriate comments in your code.

(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 2 (starting from cell B2) 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 2 contain numbers. Use a suitable Do While loop and the cells command. Declare all variable types and include appropriate comments in your code. (b) Write a user-defined function called NoSpace which takes a string as input and outputs the same string with all of the spaces removed. For example, given the string The quick brown fox it should return the string Thequickbrownfox Use a a suitable loop, declare all variable types, and include appropriate comments in your code.

Database System Concepts

7th Edition

ISBN:9780078022159

Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan

Chapter1: Introduction

Section: Chapter Questions

Problem 1PE

See similar textbooks

Similar questions

Need help on this question and can you explain how as well?
What the hell is this? You just copied the skeleton code given. Please read the instructions and make sure to produce the example output. Make sure to give the correct code and include screenshots of the example output. I included the instructions again.
Create a new file (in Dev C++) and save it as lab7_XYZ.cpp (replace XYZ with your initials). In Lab 2, you created a menu for a simple calculator program. In Lab 6, you added some functionality based on the user selection. In this lab, you will add some more functionality to the program. Use loops to keep running the program until the user chooses the exit condition (9). When dividing, use a loop to validate user input, making sure the denominator (second number) is not zero. If the user enters a 0 for the second number, display an error message and keep prompting until a non-zero number is entered. 1) Add two numbers2) Subtract two numbers3) Multiply two numbers4) Divide two numbers 9) Exit program The program should: contain header comments as shown in class display a hello message before presenting the menu display the menu prompt user for selection echo the selection back to the user if the selection was invalid, display error message to user and then loop back to menu…
Answer True or False _____ 1. It is possible that the body of a while loop might not execute at all. _____ 2. Control structures alter the normal flow of control. _____ 3. The result of a logical expression cannot be assigned to an int variable. _____ 4. Every if statement must have a corresponding else. _____ 5. The expression ! (x > 0) is true only if x is a negative number. _____ 6. The while loop: j = 0; while (j <= 10) j++; terminates when j > 10. _____ 7. A loop is a control structure that causes certain statements to execute over and over. _____ 8. When a while loop terminates, the control first goes back to the statement just before the while statement, and then the control goes to the statement immediately following the while loop. _____ 9. In a do…while loop, the condition is checked at the bottom of the loop. _____ 10. A do…while loop may never execute.
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>…
9.Code please. In this exercise you will create a program that will be used in a digital library to format and sort journal entries based on the authors last name. Each entry has room to store only the last name of the author. Begin by removing the first name "Isaac" from the string variable journal_entry_1 by using the string function erase. Do not forget to also remove the whitespace so that the string variable journal_entry_1 will then contain the string "Newton" with no whitespaces. The journal entries should be sorted alphabetically based on the authors last name. For example, the last name "Brown" should come before the last name "Davis" Create an if statement so that if the last name contained within journal_entry_2 is alphabetically less than the last name contained within journal_entry_1, then the string values are swapped using the string function swap. You may use either of the comparison operators < > in the if statement but remember that following ASCII, "A" is…
In this lab, you write a while loop that uses a sentinel value to control a loop in a Python program. You also write the statements that make up the body of the loop. The source code file already contains the necessary assignment and output statements. Each theater patron enters a value from 0 to 4 indicating the number of stars that the patron awards to the Guide’s featured movie of the week. The program executes continuously until the theater manager enters a negative number to quit. At the end of the program, you should display the average star rating for the movie.