Question

4. How would you write a cell
reference formula for cell A1
subtracted by Cell C3?​

Answer 1

Answer:

In the cell where you want to output the difference, type the equals sign (=) to begin your formula.

Click on the cell containing a minuend (a number from which another number is to be subtracted). Its reference will be added to the formula automatically (A2).

Type a minus sign (-).

Click on the cell containing a subtrahend (a number to be subtracted) to add its reference to the formula (B2).

Press the Enter key to complete your formula

Answer 2

Answer:

A1-C3

Explanation:

reference is a cell's address. It identifies a cell or range of cells by referring to the column letter and row number of the cell(s). For example, A1 refers to the cell at the intersection of column A and row 1.

The reference tells Formula One for Java to use the contents of the referenced cell(s) in the formula. If a formula requires a number, you can substitute a reference to a cell that contains a number.

FINAL ANSWER- A1-C3

#SPJ2