# FUNDAMENTALS OF COMPUTER

## DATABASE FUNDAMENTALS

### HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

 Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
A cell reference that uses an absolute column or row reference, but not both
 A absolute cell reference B relative cell reference C named range D mixed cell reference
Explanation:

Detailed explanation-1: -An absolute reference is designated in a formula by the addition of a dollar sign (\$) before the column and row. If it precedes the column or row (but not both), itâ€™s known as a mixed reference. You will use the relative (A2) and absolute (\$A\$2) formats in most formulas. Mixed references are used less frequently.

Detailed explanation-2: -Relative cell references contain no dollar signs (i.e., A1). Mixed cell references have dollar signs attached to either the letter or the number in a reference but not both (i.e., \$A1 or A\$1). Absolute cell references have dollar signs attached to each letter or number in a reference (i.e., \$A\$1).

Detailed explanation-3: -What Are Mixed Cell References? 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.

There is 1 question to complete.