Question

3) Which cell reference is an example if absolute cell reference 1) $A12) $A$1 3) A1$​

Answer 1

Answer:

If you're new to Excel for the web, you'll soon find that it's more than just a grid in which you enter numbers in columns or rows. Yes, you can use Excel for the web to find totals for a column or row of numbers, but you can also calculate a mortgage payment, solve math or engineering problems, or find a best case scenario based on variable numbers that you plug in.

Excel for the web does this by using formulas in cells. A formula performs calculations or other actions on the data in your worksheet. A formula always starts with an equal sign (=), which can be followed by numbers, math operators (such as a plus or minus sign), and functions, which can really expand the power of a formula.

For example, the following formula multiplies 2 by 3 and then adds 5 to that result to come up with the answer, 11.

=2*3+5

This next formula uses the PMT function to calculate a mortgage payment ($1,073.64), which is based on a 5 percent interest rate (5% divided by 12 months equals the monthly interest rate) over a 30-year period (360 months) for a $200,000 loan:

=PMT(0.05/12,360,200000)

Here are some additional examples of formulas that you can enter in a worksheet.

=A1+A2+A3 Adds the values in cells A1, A2, and A3.

=SQRT(A1) Uses the SQRT function to return the square root of the value in A1.

=TODAY() Returns the current date.

=UPPER("hello") Converts the text "hello" to "HELLO" by using the UPPER worksheet function.

=IF(A1>0) Tests the cell A1 to determine if it contains a value greater than 0.