DATABASE FUNDAMENTALS
BASICS OF BIG DATA
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
The Undo button on the Quick Access toolbar
|
|
|
The Cancel button on the Formula bar
|
|
|
The Enter button on the Formula bar
|
|
|
The Save button on the Quick Access toolbar
|
Detailed explanation-1: -ISERROR is a logical function that is used to identify whether the cells being referred to have an error or not. This function identifies all the mistakes. If any error is found in the cell, it returns “TRUE” as a result, and if the cell has no errors, it gives “FALSE” as a result.
Detailed explanation-2: -You can start Excel using the Start button on the Windows taskbar of a shortcut on your desktop. You can use the DELETE key to clear cell contents. You can use the I-beam pointer to copy cell contents into adjacent cells.
Detailed explanation-3: -If a formula cannot correctly evaluate a result, Excel displays an error value, such as #####, #DIV/0!, #N/A, #NAME?, #NULL!, #NUM!, #REF!, and #VALUE!. Each error type has different causes, and different solutions.