QB(AVERAGE)

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?

• 
• 
• 
•