DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
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: -The four types of data are text, number, logical and error. You may perform different functions with each type, so it’s important to know which ones to use and when to use them. You may also consider that some data types may change when exporting data into a spreadsheet.
Detailed explanation-4: -Cell address The identification of a specific cell by its intersecting column letter and row number. Another name for a cell reference.