DATABASE FUNDAMENTALS
HOW TO USE THE CONCATENATE FUNCTION IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
Which of the following expressions is not an Excel formula?
|
|
=A4*B8
|
|
|
=56*89
|
|
|
aa*cover
|
|
|
=SUM(G5:G34)
|
Explanation:
Detailed explanation-1: -Detailed Solution. The correct answer is “ALT".
Detailed explanation-2: -SUMIF, COUNTIF, AVERAGEIF These functions in Excel are a combination of the SUM, COUNT, AVERAGE functions and IF statements. All of these functions are structured the same way, being =FUNCTION(range, criteria, function range).
There is 1 question to complete.