FUNDAMENTALS OF COMPUTER

DATABASE FUNDAMENTALS

HOW TO USE THE CONCATENATE FUNCTION IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
Suppose you want to copy a formula while keeping one of the cell references locked on the same cell. Which of the following would you use?
A
Absolute reference
B
ReferenceLock
C
PivotTable
D
Relative reference
Explanation: 

Detailed explanation-1: -Answer: To copy a formula while keeping one of the cell references locked on the same cell, you would use an Absolute Reference. Explanation: An absolute reference is denoted by a “$” symbol placed before the column and/or row reference in the formula.

Detailed explanation-2: -If you want to maintain the original cell reference when you copy it, you “lock” it by putting a dollar sign ($) before the cell and column references. For example, when you copy the formula =$A$2+$B$2 from C2 to D2, the formula stays exactly the same. This is an absolute reference.

Detailed explanation-3: -If you want to maintain the original cell reference in this example when you copy it, you make the cell reference absolute by preceding the columns (B and C) and row (2) with a dollar sign ($). Then, when you copy the formula =$B$4*$C$4 from D4 to D5, the formula stays exactly the same.

Detailed explanation-4: -Relative Cell References This is the most widely used type of cell reference in formulas. Relative cell references are basic cell references that adjust and change when copied or when using AutoFill. Example: =SUM(B5:B8), as shown below, changes to =SUM(C5:C8) when copied across to the next cell.

Detailed explanation-5: -If you want cell references to remain fixed when you copy a formula, then place a “$” before the column letter if you want that to always stay the same. Place a “$” before a row number if you want that to always stay the same. The $ sign makes that reference absolute.

There is 1 question to complete.