Computer Science Homework Answers | Computer Science Homework Help

Questions

For VBA: Complete this problem on Sheet1. The user will select a cell on Sheet1 and...

For VBA:

Complete this problem on Sheet1.

The user will select a cell on Sheet1 and input a positive number (you do not know which cell will be selected ahead of time). This cell automatically becomes the active cell. Next, create a macro named problem1 that will perform the following tasks:

• Obtain the value in the active cell and store it in a variable.

• In the cell to the right of the original active cell, output 5 plus the value in the original active cell

• In the cell above the original active cell, output one-half the value in the original active cell

• In the cell below the original active cell, output the square root of the value in the original active cell

Create a run button on Sheet1 that executes problem1.

Your macro must work for any positive number input into any cell. For example, if you type 36 in cell B3 and then click the run button, the number 41 will appear in C3, the number 18 will appear in B2, and the number 6 will appear in B4. Then if you click on cell D5, type 25, and click the run button, the number 30 will appear in E5, the number 12.5 will appear in D4, and the number 5 will appear in D6.

You can assume the user will not input the value in the first or last row, nor the last column (Think about what will happen if the value is input into one of those cells. Or better yet, try doing it and see what happens.).

Assume the user will input a value in the active cell before clicking the run button.

Use the Option Explicit statement for this macro and in all future macros that you create. This will force you to declare your variables.

Hint: When the run button is clicked, whatever cell is selected at that time automatically becomes the active cell. You can move to the right, above, and below the active cell by using relative references in your program. This will require you to use ActiveCell.Offset() three times.

PLEASE take screenshots of VBA code and excel. Thank you

In: Computer Science

NOTE: PLEASE READ THE FIRST 4 GUIDELINES ON DOING THIS ASSIGNMENT IT'S A C++ CLASS, THE...

NOTE: PLEASE READ THE FIRST 4 GUIDELINES ON DOING THIS ASSIGNMENT

IT'S A C++ CLASS, THE FUNCTIONS ARE PROVIDED BELOW

Assignment 7.1 [45 points]

No initial file comment is required for this assignment. Function comments are still required.

Implement the following functions. Each function deals with null terminated C-Style strings. You can assume that any char array passed into the functions will contain null terminated data. Place all of the functions in a single file and then (in the same file) create a main() function that tests the functions thoroughly. You will lose points if you don't show enough examples to convince me that your function works in all cases.

Please note the following:

You can do anything you want to test the functions, as long as the end result is that you demonstrate that they work correctly.

You may not use any variables of type string. This means that you should not #include <string>. Also, you may not use any c-string functions other than strlen(). If you use any other c-string functions, you will not get credit. Note, however, that functions such as toupper(), tolower(), isalpha(), isspace(), and swap() are NOT c-string functions, so you can use them. Also note that this prohibition is only for the functions that you are assigned to write. You can use whatever you want in your main() function that tests the assigned functions.
In most cases it will be better to use a while loop that keeps going until it hits a '\0', rather than using a for loop that uses strlen() as the limit, because calling strlen() requires a traversal of the entire array. You could lose a point or two if you traverse the array unnecessarily.
None of these function specifications say anything at all about input or output. None of these functions should have any input or output statements in them. The output should be done in the calling function, which will probably be main(). The only requirement about main() is that it sufficiently test your functions. So, you can get user input in main() to use as arguments in the function calls, or you can use hard-coded values -- up to you, as long as the functions are tested thoroughly.
Here's a hint about how to work with c-strings in main(). There are several different ways that you could assign values to c-string variables, but I think the easiest is just hardcoding a lot of examples. For example:
```
char str1[] = "Hello World";
char str2[] = "C++ is fun!";
```
Whatever you do, don't try to create and initialize a c-string on one line using pointer notation, like this:
```
char* str1 = "Hello world";
```
This is dangerous (and officially deprecated in the C++ standard) because you haven't allocated memory for str1 to point at.
Since it is just being used for testing, In this case it is fine to have a very long main() function.

Here are the functions:

This function finds the last index where the target char can be found in the string. it returns -1 if the target char does not appear in the string. The function should be case sensitive (so 'b' is not a match for 'B').
```
int lastIndexOf(const char* inString, char target)
```
This function alters any string that is passed in. It should reverse the string. If "flower" gets passed in it should be reversed in place to "rewolf". For efficiency, this must be done "in place", i.e., without creating a second array.
```
void reverse(char* inString)
```
This function finds all instances of the char 'target' in the string and replace them with 'replacementChar'. It returns the number of replacements that it makes. If the target char does not appear in the string it should return 0.
```
int replace(char* inString, char target, char replacementChar)
```
This function returns true if the argument string is a palindrome. It returns false if it is no. A palindrome is a string that is spelled the same as its reverse. For example "abba" is a palindrome. So are "hannah" and "abc cba".

Do not get confused by white space characters, punctuation, or digits. They should not get any special treatment. "abc ba" is not a palindrome. It is not identical to its reverse.

Your function should not be case sensitive. For example, "aBbA" is a palindrome.

You must solve this problem "in place", i.e., without creating a second array. As a result, calling your reverse() function from this function isn't going to help.
```
bool isPalindrome(const char* inString)
```
This function converts the c-string parameter to all uppercase.
```
void toupper(char* inString)
```
This function returns the number of letters in the c-string.
```
int numLetters(const char* inString)
```

In: Computer Science

This basic problem is a practical application of if-statement(s). Write a function called bolt_check that takes...

This basic problem is a practical application of if-statement(s).

Write a function called bolt_check that takes one scalar input argument and returns one scalar output argument. The input represents the measured length of a machine screw during the quality-assurance phase of its manufacturing. The purpose of the function is to categorize the measured length into one of six categories. If the measured length is within two percent of one of its five nominal lengths-- 3/8, 1/2, 5/8, 3/4, or 1 (inch), then the nominal length is returned. Otherwise 0 is returned, signifying that the bolt failed the test. You may find that the built-in function abs for absolute value is useful for this problem.