Answer:
Click “between” under the equal menu, and then enter 90 in the first field and 100 in the second field
Explanation:
Since the user wants to highlight fields which contains value which are greater than 90 and less than 100, the operation seems to work well with “between” operator or between function. Since there is a start range and the end range it is better to deal with between function.
The other choices will not work because the greater than or less than operator works only on single value. Only the “between operations” works well on range of values. All the other options are invalid.
The predefined formulas in Excel that contain the Boolean functions fall under the Logical Functions category. The Boolean functions consist of "AND", "OR", "XOR", "NOT", "IF", "IFERROR" and "IFNA". When you need to use an Excel Function, you can type the function into the cell. You also need to add the arguments for the function in between brackets. If the function is complex or you are a beginner user, there is a function inputting tool which will help you choose which function you require.
Answer:
B) Database Software
Explanation:
Desktop Publishing software and Multimedia software is not used for storing data, so it can't be that. Spreadsheet software stores data in cells, while Database software stores data in tables.
Answer:
The answer is "Option d'.
Explanation:
The database provides a single graphical view of the data, but it provides the facility to use logical view concept, that uses by view command, that uses the dataset to provide a logical view, that shows data according to user condition, and certain options were incorrect which can be described as follows:
- In option a, In logical viewing data, it is not used.
- In option b, It doesn't represent entry screen it simply shows detail.
- In option c, this command doesn't allow you to create duplicate data.