USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A cell contains a(n) ____ when its first character begins with either a number or one of the following symbols (+, -, =, $).
|
|
VALUE
|
|
|
AUTO-FILL
|
|
|
FILL
|
|
|
THEME
|
Explanation:
Detailed explanation-1: -Excel absolute cell reference (with $ sign) The dollar sign fixes the reference to a given cell, so that it remains unchanged no matter where the formula moves. In other words, using $ in cell references allows you to copy the formula in Excel without changing references.
Detailed explanation-2: -E$2 – In this reference, the dollar sign is right before the row number, and the Column notation has no dollar sign. This means that when you copy the formula down the cells, the reference will not change as the row number is locked.
There is 1 question to complete.