Question

Observe the following spreadsheet in Calc and answer the question given below.
i) Write function to assign 'GOOD' to all those who have scored Total Marks more than or equal to 225. It should also assign 'FAIR'to those who have scored Total Marks less than 225.
ii)Which feature will you use arrange the names of the students in alphabetical order?
iii) Which feature will you use to view the record of students having 'Total Marks' less than 210 and hide the remaining records?​

Answer 1

Answer:

i) IF(AE2>=225,"GOOD",IF(AE2<225,"FAIR"))

ii) Using sort feature

iii) Filter feature

Explanation:

i) To get the grade based on score values, the nested IF function in Excel is used.

SYNTAX:- IF(condition1, value_if_true1, IF (condition2, value_if_true2, value_if_false2))

where, condition1, condition2 are the conditions we want to test.

value_if_true1, value_if_true2 are the values that we want to return if the result of the conditions are TRUE.

value_if_false2: The value that you want to return if the result of the condition is FALSE.

ii) We can use Sort feature to arrange the names of students alphabetically. Select one or several column headers then on the Home tab, in the Editing group, click Sort and Filter > Filter. Small drop-down arrows will appear in each of the column headers. Click the drop-down arrow for the column that you want to put in alphabetical order, and select Sort A to Z.

iii) Simple Filter feature can be used to hide elements.

#SPJ3