Question

Type the following formulae in Microsoft Excel and write the result in the space provided.
=(3+1)^2] in cell A1
2.
=(8-3)*A1 in cell A2
=(1+4)*2-3-16/2] in cell A3
=20-20/(2*10)+3) in cell B1
*2*3*3.9/2+18*2-15) in cell B2​

Answer 1

Answer:

Below is an animated visual example of how an excel formula can be inserted into a spreadsheet. In our first formula entered into the cell "D1," we manually enter a =sum formula to add 1+2 (in cells A1 and B2) to get the total of "3." With the next example, we use the mouse to highlight cells A2 to D2 and then click the formula button in Excel to automatically create the formula. Next, we show how you can manually enter a formula, and then using a mouse, get the cell values (you can also highlight multiple cells to create a range). Finally, we manually enter a times ( * ) formula using the sum function to find the value of 5 * 100.

Answer 2

=(3+1)^2] in cell A1

2. Ans: 16

=(8-3)*A1 in cell A2. Ans: 80

=(1+4)*2-3-16/2] in cell A3. Ans: 14

=20-20/(2*10)+3) in cell B1. Ans: 22

*2*3*3.9/2+18*2-15) in cell B2. Ans: 36.5