DATABASE FUNDAMENTALS
USING THE UPPER AND LOWER FUNCTIONS IN EXCEL
|
Question
[CLICK ON ANY CHOICE TO KNOW THE RIGHT ANSWER]
|
A hardware store needs the total hammers sold during the month. The date is in Column A, the item name is in Column B, the number of items sold is in Column C, and the table range is A2:C50. What is the formula?
|
|
=SUMIF(B2:B50, “<>hammer", A2:C50)
|
|
|
=SUMIF(A2:C50, “hammer", C2:C50)
|
|
|
=SUMIF(B2:B50, “hammer", C2:C50)
|
|
|
=SUMIF(C2:C50, “hammer", B2:B50)
|
Explanation:
Detailed explanation-1: -Click the AutoSum button on the Ribbon’s Home tab. A SUM formula will be automatically entered for each Total.
Detailed explanation-2: -What is the name for the type of data stored in a table that is often used to create categories? Dimension data are often used to create categories.
Detailed explanation-3: -The statistical functions AVERAGEIF and AVERAGEIFS are similar to SUMIF and SUMIFS. They calculate the average value where cells meet specified criteria.
There is 1 question to complete.