FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO MODIFY THE WORKSHEET TAB IN EXCEL

Please wait while the activity loads.
If this activity does not load, try refreshing your browser. Also, this page requires javascript. Please visit using a browser with javascript enabled.

If loading fails, click here to try again

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]

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

A	A1-C3
B	A1-C3=
C	=A1-C3
D	=C3-A1

Explanation:

Detailed explanation-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).

Detailed explanation-2: -A 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.

Detailed explanation-3: -A cell reference in Excel refers to the value of a different cell or cell range on the current worksheet or a different worksheet within the spreadsheet. A cell reference can be used as a variable in a formula.

There is 1 question to complete.