Answer:
Following are the code to this question:
code:
=IF(EXACT(I2,"Yes"),"Elected",IF(EXACT(K2,"Yes"),"Yes","No"))
Explanation:
In the given the data is not defined so we explain only the above code, but before that, we briefly define working of if the function that can be defined as follows:
-
The If() function, is used only when one of the logical functions and its value must return the value true. or we can say it only return a true value.
- In the above function, a column "Elected" is used that uses other column values to check this column value is equal if this condition is true it will return "yes" value.
Umm
I’m in 10th grade so.....what is a spreadsheet and statistical function
The best possible solution for the technician to do is to go into the disk management and find out what exactly is going on. The technician should check whether there is partition that has unallocated space. It is 100% the case that the rest of the 500 GB is in the unallocated space.
The techie need to grow his partition. Possible option for a scenario like this is delete the unallocated 500 GB space using NTFS. He can then recreate the available 500 GB free space as 1TB partition.
