Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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.
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 andor display the formulas onscreen 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 and then copy it to the other cells in the column.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started