H$4$

A

B

C

D

E

F

G

H

I

Data Tools

What$-$If

Forec:

Analysis

Forecast

$1$

$2$ E Management Data

$\backslash$table$[[,$EmplD,FirstName,LastName,Department,Address,City, State, Postal Code,City,State,Postal Code,Phone,Full Name$],[3,12048,$Elena,Montoya,Customer Service,$1854$ Red Maple Drive,Miami, FI$,33143,$Miami,FI$,,(305)555-0723,],[4,12052,$Margaret,Fitzpatrick,Sales & Retention,$61$ Meadow Lane,Miami, FI$,33145,$Miami,FI$,,(305)555-0199,],[5,12053,$Jerry,Chung,Human Resources,$894$ Lesniak Avenue,Miami, FI$,33174,$Miami,FI$,,(305)555-0144,],[6,12057,$Emily,Rhoades,Administration,$617$ Oliviar Drive,Coral Springs, FI$,33075,$Coral Sprir,FI$,,(305)555-0135,],[7,12060,$Maria,Flores,Administration,$12$ Casa Del Sol,Hialeah, FI$,33013,$Hialeah,FI$,,(305)555-0177,],[8,12065,$Joan,Curtis,Customer Service,$46$ Red Rose Lane,Winter Park, FI$,32790,$Winter Par,FI$,,(305)555-0192,]]$

Employee Data Suppliers Management Data

Ready

Accessibility: Investigate

Type here to search

$1\mathrm{.}00$ Point: XLActivity $10\mathrm{.}07$: Using Text Functions

Use the UPPER function in cell H$3$ to return the upper case of state abbreviation.

Copy the function in cell H $3$ to the range $H4$:$H8.$