DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Suppose a cell contains the formula =(E3*$H$2) * E3. The variable $H$2 is a(n) ____ reference.
|
|
bad
|
|
|
mixed
|
|
|
absolute
|
|
|
relative
|
Explanation:
Detailed explanation-1: -Click the tab for the first worksheet that you want to reference. Hold down the Shift key then click the tab for the last worksheet that you want to reference. Select the cell or range of cells that you want to reference. Complete the formula, and then press Enter.
Detailed explanation-2: -It is possible to undo and redo up to the last 16 consecutive actions. Every time you use the Undo feature, those actions that you undo are placed in the Redo category.
There is 1 question to complete.