FUNDAMENTALS OF COMPUTER

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

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]

Which of the following is NOT a form of cell referencing?

A	Direct referencing
B	Relative referencing
C	Absolute referencing
D	Mixed referencing

Explanation:

Detailed explanation-1: -Answer: Combined Reference is not a type of cell references in MS Excel.

Detailed explanation-2: -Absolute is not type of referencing .

Detailed explanation-3: -Direct cell referencing is a method of passing the value of one cell as an argument in a linkage function of another cell. By directly referencing an Excel cell number, you can streamline the link creation process and avoid manually building or modifying each link.

Detailed explanation-4: -Relative: This refers to the cell relative to the given position. Absolute: This refers to the specific cell irrespective of the position of the formula. The ‘$’ sign is used to denote an absolute reference. Mixed: It is a combination of both relative and mixed references.

There is 1 question to complete.