DATABASE FUNDAMENTALS
WORKBOOK THEMES
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
|
|
True
|
|
|
False
|
|
|
Either A or B
|
|
|
None of the above
|
Detailed explanation-1: -Data filtering, as the name suggests, can help you eliminate unnecessary data. For example, if you want to find out the total number of records in a dataset with two different types of fields such as integers and strings, then you can use data filtering to filter out all records that have either type of field in them.
Detailed explanation-2: -Answer. yes it is true that excel allows you to sort or filter data by cell color.
Detailed explanation-3: -Sorting: It is a feature that lets you arrange data in ascending or descending order. Filtering: It is a feature that allows you to view only selective data that satisfies a given condition.
Detailed explanation-4: -You can prevent these indicators from being displayed by using the following procedure. In Excel 2016, Excel 2013, and Excel 2010: Click File > Options >Formulas. > Excel Options > Formulas. Under Error Checking, clear the Enable background error checking check box.