Answer:
You can edit the existing formula by clicking the cell in which formula is referenced, then edit the formula in the formula bar. (option c is correct)
Explanation:
This question is about how to edit the existing formula. In Excel, you can edit the formula. First, you have to click the cell in which the formula is written. Then you have to edit it in the formula bar. However, if you know and remember the formula, you can edit directly in the cell. But the best practice is to edit the formula in the formula bar.
Why other options are not correct.
- In a cell that is referenced in the formula:
The cell that is referenced in the formula does not affect the formula. Because to edit something in the referenced cell, does not guarantee to affect the formula that you want to edit. To edit the existing formula, you click the cell in which formula is written, then edit it in the formula bar.
- In the first blank cell of the worksheet
It is not necessary, that there would be a formula in the first cell. But, if there is a formula in the first cell, you should edit the formula directly in the formula bar.
You can't edit the existing formula in the status bar because the status bar is used for showing the status of actions you are doing in excel. The status bar is shown at the bottom of the excel sheet.
sequence is the order of arrangement of files and folders.
The answer is c.-architectural talent and an eye for design.
Answer:
D. return str.substring(0, 1) + removeDupChars(str.substring(1));
Explanation:
The logic here is following:
If the there are consecutive duplicate characters, return the removeDupChars method. The parameter of the removeDupChars method is a string, but the duplicate of the first character is removed from the string. The else-if part of the program does this job.
If the consecutive characters are not duplicated, return the first character of the string and the removeDupChars method. The parameter of the removeDupChars method is the rest of the string characters. The else part of the program does this job.
When the length of the str becomes one (or when the str is null), the program reaches its base and returns the str. The if part of the program does this job.
