USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
A value is any data that can be used in calculation while a label is a text entry and is used as an identifier.
|
|
|
A label is any data that can be used in calculation while a value is a text entry and is used as an identifier.
|
|
|
A value and a label can be used in calculation and can also be used as an identifier.
|
|
|
A value and a label can be used in calculation but cannot be used as an identifier.
|
Detailed explanation-1: -All words describing the values (numbers) are called labels. The numbers, which can later be used in formulas, are called values. Notice also that the labels (composed of letters) are all left justified and the values (composed of numbers) are all right justified in their cells.
Detailed explanation-2: -a) Label : Label is the any text entered by using a keyboard. It may combine with letters, numbers, and special symbols. By default the labels are left aligned. b) Values : The numerical data consisting of only numbers are called values.
Detailed explanation-3: -What is the VALUE Function? The VALUE Function[1] is categorized under Excel Text functions. It will convert a text string that represents a number into a number. Thus, the function will convert text that appears in a recognized format (a number, date, or time format) into a numeric value.
Detailed explanation-4: -Labels and names are used to identify cells and ranges using a tag that is more meaningful than ordinary cell references such as B6 or C5:D11. These names and labels can be used in formulas and in links between worksheets and workbooks to make the formulas easier to understand.