Chapter 1, Problem 2AYK

In the Media Posts worksheet, in column G of the Facebook table, apply the VLOOKUP function to categorize the size of each post, using the value Characters field for the lookup value, the Character_Lookup table as the lookup table, and the second column of the table as the return value.

Task 5: The marketing team wants to print out branded name tags for the properties with the StayWell logo and resident names. They require the first and last names of the residents combined and converted to uppercase for printing. You need to send them a single-column table with the column name of LABEL.