(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?
Computers are widely used for survey data analysis to compile and analyze the results of survey and opinion polls. Show in the table below are the 99 response ratings (values from 1 to 9) from reviewets for a beta website: (See attached photo (table)) Write a program that computes the mean, median, and mode of the 99 values. Please refer to the sample run shown below, and follow the display output. (See attached file for sample run)
Python Create a text file named “Books.txt”.Open the text file and add the name of at least two books.In your Python3 code file, create a function that will loop through and display a menuwith options to Display, Add, Exit. It will end once the user selects the option for exit.Create another function that will accept the user’s choice with the outcome for eachoption.Display – read the file and output each lineAdd – prompt the user for a book name and append it to the file. Exit – close the file and exit the loopRun the code to display your output.
Write a program that will perform the following matrix operations:1. Matrix addition2. Matrix subtraction3. Scalar multiplication / Dot product4. Matrix multiplication / Cross productDisplay a menu to the user to choose from the above operations. Depending on thechosen operation, ask the user to input the dimensions of the two matrices to process.Have a loop to repeat the whole process as the user requires. PLEASE add "//" every code wirtten to explain its use in the program. thank you! do the following conditions set and DO IT IN C++
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.
Python
.
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.