Multiple Choice
The score of a student in two subjects are inserted in B2 and C2 cell and the passing score for each subject is 60.which of these functions will you insert in D2 cell to get FALSE as the result if the student has passed and TRUE as the result if the student has failed?
A) =IF(B2>=60,C2>=60)
B) =NOT(OR(B2>=60,C2>=60) )
C) =OR(B2>=60,"Pass","Fail")
D) =AND(B2>=60,"Pass","Fail")
Correct Answer:

Verified
Correct Answer:
Verified
Q3: To hide the PivotTable Field list,right click
Q4: Edwin wants to insert a Pivot Chart
Q5: A worksheet has the following data in
Q6: Warren creates a table listing the height
Q7: A worksheet has the following data in
Q9: Alejandro wants to change the color of
Q10: To add fields to a PivotTable,one can
Q11: The score of a student inserted in
Q12: Chastity wants to rename her pivot table
Q13: Jin wants to insert a recommended pivot