Chapter 3, Problem 4.13CP

Rewrite the Loop clause from Question 1 using the Until keyword.

Which of the following comments regarding the reading of a string, using scanf(with optional) and get is true? A. Both can be used interchangeably B. Scanf is delimited by end of line, while gets is not C. Scanf is delimited by blank, while gets is not D. All of above

Add formulas to complete the table of hours used. In cell B17, create a nested formula with the IF and SUM functions that check if the total number of hours worked in week 1 (cells B9:F9) is equal to 0. If it is, the cell should display nothing (indicated with two quote marks: ""). Otherwise, the cell should display the total number of hours worked in week 1. Copy the formula from cell B17 to fill the range B18:B20

Build a list of contacts for New Jersey manufacturers as follows: ContactFirstName, ContactLastName, Phone. HINT: To do this you will need to  split the contact name into two columns.  You will need to embed string functions within string functions. It may be helpful to use Substring and Charindex. For last name, you can use a literal of 20 characters as the length to ensure you pick up all the characters to the end of the field.)

Complete the following function according to its docstring. def more_upper_than_lower(message: str) -> bool:   """Return True if and only if a message contains more uppercase letters than lowercase letters. >>> more_upper_than_lower(‘I LOVE Caps Lock! :D') True >>> more_upper_than_lower('Does THIS Work?')   False   """

The Remove method in the following code will remove which characters from the myString variable?Dim myString as string = "ABCDEFGH"myString = myString.Remove(2, 3)   a. CD     b. BCD     c. CDE     d. DE