FUNDAMENTALS OF COMPUTER

Previous
Next

USING MICROSOFT EXCEL

HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Cell reference that combines both absolute and relative cell addressing.
A
Relative
B
Absolute
C
Mixed Reference
D
None of the above
Explanation: 

Detailed explanation-1: -To convert relative cell references to absolute or mixed cell references: Press F4 once to create a cell reference fully absolute, such as $A$6. Press F4 a second time to create a mixed reference where the row number is absolute, such as A$6.

Detailed explanation-2: -Mixed cell references are a combination of relative references and absolute reference. There are two distinct types of mixed reference. Either the column is locked while the row changes when the formula is copied, or the row is locked while the column changes when the formula is copied.

Detailed explanation-3: -So, the combination of two or more cells is called a battery. 1. Cell is a single unit of source of energy while the battery is the combination of the cells.

There is 1 question to complete.
Previous
Next