Question

What formula should be entered in cell A3 to display the results as shown below?​

Answer 1

Viewing Formula Results-

⚫Press F2 to edit the formula in the cell.

⚫Select the portion of the formula whose value you want to see. In this inst.ance, you would select C3/F8.

⚫Press F9. Excel replaces the portion of the formula with its result.

Answer 2

The formula should be entered in cell A3 to display the results as shown below:

Explanation:

• a) ="Income Statement"& A
• b) ="Income Statement "&A1
• c) ="Income Statement "+A1
• d) ="Income Statement "&"A1"
• b) ="Income Statement "&A1 is the correct option.