BA 352 Knowledge Check in 2
¡Supera tus tareas y exámenes ahora con Quizwiz!
What do you need to include when you are entering text into your formula?
quotes
If the cell B2 is 60, what will this IF function give you as a result? =IF (B2>55, ''yes'', ''no'')
yes
Which of the following is an operator for inserting a not equal to condition in an IFS, COUNTIFS or SUMIFS function?
<>
""
It joins two or more text strings in a single string
* (asterisk)
It represents any number of characters. For example, Ex* could mean excel, excels, example, expert, etc.
? (Question mark)
It represents one single character. For example, Ex?el could mean Excel or Excel
& (ampersand)
This sign matches blank cells
