Question

10/25)
Which of the following Functions is
incorrect?
=SUM(A1,B2+C1,D2)
=MULTI(A1,B2)
=SUM(1,2,3+4)
=MIN(A1,A2,A3,A4)​

Answer 1

Hahahahahahajajahah ha ha ha ha ha ‍♂️ I know you

Answer 2

Answer:

Explanation:

Sum Function:

A straightforward formula can be used to add the values in a range (a collection of cells), however the SUM function is more user-friendly when dealing with larger numbers. In contrast to $=A2+A3+A4+A5+A6$, $=SUM(A2:A6)$ is less likely to have typographical errors.

The following formula utilizes two cell ranges:

$=SUM(A2:A4,C2:C3)$) adds up the figures in the $A2:A4$ and $C2:C3$ ranges. To get the total of $39787$, press Enter.

To formulate the equation:

• In a cell, enter =SUM and then the opening parenthesis ().
• Type$A2:A4$ to input the first formula range, also known as an argument (a piece of information required for the formula to function) (or select cell $A2$ and drag through cell$A6$).
• To distinguish the first argument from the second, type a comma (,).
• $C2:C3$is the second argument to type (or drag to select the cells).
• Enter after typing a closing parenthesis ().

Using commas to separate them, each argument can be a range, a number, or a reference to a single cell:

• $=SUM(A2:A4,2429,10482)$
• $=SUM(4823,A3:A4,C2:C3)$
• $=SUM(4823,12335,9718,C2:C3)$
• $=SUM(A2,A3,A4,2429,10482)$

Multi Function:

When using Excel's functions, especially when trying to clean up data, one function may not always be enough to complete the task. Therefore, using more than one function is frequent. We also make reference to the idea of nesting because we employ functions inside of functions. I have some data in columns $A$ and $B$ of this worksheet. And as you can see, there are a few strange spacings. All of the info is capitalized as well. Although it's not actually incorrect, suppose we just want the initial letters to be capitalized. Therefore, we might begin the process of cleaning this up by entering a function called proper if we were just interested in column $A$. and mentioning cell this time,$A2.$ That is how it would appear. However, we also want to merge that with the information in cell $B2$, so let's think about how to clear up the spaces as well.

Nesting is the process of including a function as one of the arguments in a formula that also includes a function; we'll refer to this function as a nested function. The following formula, for instance, only sums a set of numbers ($G2:G5$) if the average of another set of numbers ($F2:F5$) is larger than $50$. This is achieved by nesting the AVERAGE and SUM functions in the arguments of the IF function. If not, it returns $0$.

Within the IF function are nesting instances of the AVERAGE and SUM functions.

A formula can have up to $64$ layers of function nesting.

The incorrect function is $=MULTI(A1,B2)$

#SPJ2