USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
Labels should be used when you need to enter text only.
|
|
|
Labels are entered for report titles or column headings only.
|
|
|
Labels identify the values and help outline the mathematical relationships.
|
|
|
d.Labels identify where and how the values should appear.
|
Detailed explanation-1: -Why would you enter labels into the worksheet? Labels should be used when you need to enter text only. Labels are entered for report titles or column headings only. Labels identify the values and help outline the mathematical relationships.
Detailed explanation-2: -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.
Detailed explanation-3: -To quickly identify a data series in a chart, you can add data labels to the data points of the chart.
Detailed explanation-4: -Entering data into a spreadsheet is just like typing in a word processing program, but you have to first click the cell in which you want the data to be placed before typing the data. All words describing the values (numbers) are called labels. The numbers, which can later be used in formulas, are called values.
Detailed explanation-5: -Labels: Labels refer to text that is typed into the cells of a spreadsheet. Labels have no numeric value and cannot be used in a formula or function.. Name Box: The name box appears to the left of the formula bar and displays the name of the current cell.