NEW
Font size
WorksheetsQB(AVERAGE)
Total questions: 10
Worksheet time: 4mins
In the sample worksheet above, what is the correct MS Excel formula to change the name of Tim to John?
=CONCATENATE(A1,"John", "Tim")
=CONCATENATE(A1,"Tim","John")
=SUBSTITUTE(A1,"John", "Tim")
=SUBSTITUTE(A1,"Tim", "John")
In boolean algebra,
NOT T OR F AND T AND F OR T will give us the output:
T1F4
T2F3
T3F2
T4F1
Which of the following DOES NOT belong to the group of String function in MS Excel Formula that uses 2 parameter.
MID()
FIND()
EXACT()
LEFT()
Which of the following is NOT TRUE about Flowcharting?
Flowcharting commonly used in business or economic presentations
It is a graphical representation of a computer program
A way of representing a flow of data through a process or a system
A step-by-step approach to solving a task.
convert 1011 in binary to decimal
10
11
100
110
How many places are involved in NCR Plus Bubble
4
5
6
7
The total number of countries in Asia.
45
46
47
48
Using the sample worksheet above, what is the formula to get the sum of contribution for all BSIT students.
=SUMIF(C3:C12,"=BSIT",D3:D12)
=SUMIFS (c3:c12, “=BSIT”, d3:d12, “>20”)
=SUMIF(C3:C12,"=BSIT",D3:D12,">10")
=SUMIFS(C3:C12,"=BSIT",D3:D12)
In discrete math, this is the equivalent of OR function in boolean operation.
Negation
Conjunction
Disjunction
Implication
Which of the following drinks contains the least sugar content?
