An Excel sheet contains two non-empty cells:

A1 = "ALPHA"

A2 = "BET"

Which statement is false?

A: "=CODE(66)&MID(A2,2,2)&MID(A1,5,1)" returns "BETA"

B: "=CONCATENATE(A1,A2)" returns "ALPHABET"

C: "=LOWER(A1&A2)" returns "alphabet"

D: "=SUBSTITUTE(A1,CHAR(COLUMN(CB42)),"O")" returns "ALOHA"

×

Problem Loading...

Note Loading...

Set Loading...