Knowledge Varsity

Quiz 4 - Ch 5, Question 8

Welcome to KnowledgeVarsity Forum! This Forum is to answer your queries regarding question text and its instructions for this specific question. Please take a minute before posting a question and see if you can find an answer to your question. If not, please post your question. The Forum moderator will respond very soon!

Chapter 5, Question name: Refer to the cell ra 2

Refer to the cell range A16:D19 in the worksheet LE5.1. There are two sums computed - one in cell C19 and D19. Which one of the following statements is accurate?

(correct) The function in cell C19 sums values in cells C16, C17, D17 & D19 because its argument has an intersection operator between the two range operators.

** The function in cell C19 is disregarding the first cell range argument due to a missing operator.
**** Is this answer correct also?**

The function in cell C19 sums values in cells C16, C17, D17 & D19 because its argument has a union operator between the two range operators.

The function in cell C19 is disregarding the second cell range argument due to a missing operator.