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.
A strong password obeys some password rules, such as:
- minimum length
- using characters from different classes (uppercase, lowercase, numbers, typographic characters)
Your safest bet these days is to use a password manager and have it generate one for you, so that hackers can not guess it by understanding humans' predictable mind. ;-)
Answer:
The debugged program is as follows:
A=2
B=2
For I=1 to 10
PRINT A
TEMP = A
A=B
B=TEMP+A
NEXT I
END
Explanation:
First, the value of B should be changed to 4 (because the second term of the sequence is 2
Next, change Display to Print because Q-basic uses the print keyword to display output
The sequence is not properly generated. So, I update that part of the program to:
<em>For I=1 to 10
</em>
<em>PRINT A
</em>
<em>TEMP = A
</em>
<em>A=B
</em>
<em>B=TEMP+A
</em>
<em>NEXT I
</em>
<em />
Lastly, the loop is controlled by variable I (not X).
So change NEXT X to NEXT I
