FUNDAMENTALS OF COMPUTER

Previous
Next

DATABASE FUNDAMENTALS

HOW TO INSERT DELETE COLUMNS ROWS IN EXCEL

Question [CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
The location within which Excel recognizes a named range, which is either a specific worksheet or the entire workbook. If you set the scope of a named range to Workbook, you can reference the named range on any sheet in the workbook.
A
Scope
B
Variable
C
Value
D
Relative Cell Reference
Explanation: 

Detailed explanation-1: -The scope of a name All names have a scope, either to a specific worksheet (also called the local worksheet level) or to the entire workbook (also called the global workbook level). The scope of a name is the location within which the name is recognized without qualification.

Detailed explanation-2: -A named range is one or more cells that have been given a name. Using named ranges can make formulas easier to read and understand. They also provide simple navigation via the Name Box. Note: named ranges are absolute references by default.

Detailed explanation-3: -Excel name types Defined name-a name that refers to a single cell, range of cells, constant value, or formula. For example, when you define a name for a range of cells, it’s called a named range, or defined range.

There is 1 question to complete.
Previous
Next