Insert Text Functions The uppercase remarks, such as ON TIME, are hard to read.You want the…
Insert Text Functions
The uppercase remarks, such as ON TIME, are hard to read.You want the remarks to be easier to read, such as On Time, in the Arrivals and Departures worksheets. In addition, you want to display flight numbers such as DL 5150 in addition to one column in the Departures worksheet. Text functions are required to accomplish these tasks.
a. Type Remarks in cell H1 on the Arrivals worksheet.
b. Type a function in column H to display the remarks as specified above, and then hide column G.
c. Display the Departures worksheet, type Flight # in cell H1, and then type Remarks in cell I1.
d. Type a function in column I to display the remarks as specified, and then hide column G.
e. Create a nested function in column H that looks up the airline code from the Airlines worksheet and combines the code with the flight number in the Departures worksheet to display the result, such as DL 5150.
f. Save the workbook.
