USING MICROSOFT EXCEL
HOW TO ADD COPY AND MOVE WORKSHEETS WITHIN EXCEL WORKBOOKS
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
label
|
|
|
clipboard
|
|
|
order of precedence
|
|
|
value
|
Detailed explanation-1: -#N/A is the error value that means “no value is available.” Use NA to mark empty cells. By entering #N/A in cells where you are missing information, you can avoid the problem of unintentionally including empty cells in your calculations.
Detailed explanation-2: -Here’s how you can transpose cell content: Copy the cell range. Select the empty cells where you want to paste the transposed data. On the Home tab, click the Paste icon, and select Paste Transpose.
Detailed explanation-3: -There are Three types of data in cells: labels, values, and formulas. Labels (text) are descriptive pieces of information, such as names, months, or other identifying statistics, and they usually include alphabetic characters.
Detailed explanation-4: -Excel data types are the four different kinds of values in Microsoft Excel. The four types of data are text, number, logical and error.