To change a social security number in cell A1 from the 506-32-4462 format to 506324462 in cell B1, you would type ________

A) =SWAP(A1,"-","") B) =REPLACE(A1,"-","")
C) =EXCHANGE(A1,"-","") D) =SUBSTITUTE(A1,"-","")


D

Computer Science & Information Technology

You might also like to view...

Explain how to work with effects in InDesign.

What will be an ideal response?

Computer Science & Information Technology

Animation Painter is used to copy animation effects of one object to another object. _________________________

Answer the following statement true (T) or false (F)

Computer Science & Information Technology

Using the Print ________ can help you save paper.

Fill in the blank(s) with the appropriate word(s).

Computer Science & Information Technology

A firewall is set to block inbound connections on port 25. Which of the following protocols would enable the administrator to retrieve email without reconfiguring the firewall?

A. SNMP B. SMTP C. POP3 D. FTP

Computer Science & Information Technology