On the GuestList sheet, check all the formulas. Cells to check are filled with the light purple color. Most of them need to be corrected. Use error checking as needed and$/$or display the formulas on$-$screen for easy viewing.

In the Name Tag column, modify the formula to display the guest name in this format: BILL SMITH Hint: There are multiple errors in this formula. Don't forget the space between the first and last names. Fix the formula in cell D$10$ and then copy it to the other cells in the column.