Multiple Choice
The score of a student inserted in the B2 cell is 65 and in the C2 cell is 75.Which of the following functions will you insert in the D2 cell so that it returns FALSE if any of the conditions are false for the values in the B2 and C2 cells?
A) =IF(B2>=70,C2>=80)
B) =OR(B2>=70,C2>=80)
C) =AND(B2>=70,C2>=80)
D) =NOT(OR(B2>=70,C2>=80) )
Correct Answer:

Verified
Correct Answer:
Verified
Q6: Warren creates a table listing the height
Q7: A worksheet has the following data in
Q8: The score of a student in two
Q9: Alejandro wants to change the color of
Q10: To add fields to a PivotTable,one can
Q12: Chastity wants to rename her pivot table
Q13: Jin wants to insert a recommended pivot
Q14: Katrin has created a new table with
Q15: Right-click the pivot item,then click Collapse to
Q16: Which of these is the default layout