Spelling the Alphabet in Excel

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...