Post-Lesson Quiz

Refer to the figure, Which of the following will be the output in the RED cell?

Select two answers below

• True

• 1

• False

• 0

Refer to the figure, Which of the following will be the output in the RED cell?

• More Apples

• More Oranges

• Same same

• All the above

Refer to the figure, Which of the following will be the output in the RED cell?

• A

• B

• Fail

• Error in formula

Refer to the figure, Which of the following will be the output in the RED cell?

• 0

• 1

• 2

• 3

The COUNTIFS function counts the number of cells in one or more ranges that meet one or more criteria. What is the maximum number of range/criteria pairs could you specify?

• 125

• 126

• 127

• 128