Q: It's in the green ribbon near the top of the Excel window. This will open a toolbar for your table's design directly below the green ribbon. If you don't see this tab, click your table to prompt it to appear. Click one of the colored boxes in the "Table Styles" section of the Design toolbar to apply the color and design to your table. You can click the downward-facing arrow to the right of the colored boxes to scroll through different design options. In the "Table Style Options" section of the toolbar, check or uncheck any of the following boxes: Header Row - Checking this box places column names in the top cell of the data group. Uncheck this box to remove headers. Total Row - When enabled, this option adds a row at the bottom of the table that displays the total value of the right-most column. Banded Rows - Check this box to color in alternating rows, or uncheck it to leave all rows in your table the same color. First Column and Last Column - When enabled, these options make the headers and data in the first and/or last columns bold. Banded Columns - Check this box to color in alternating columns, or uncheck it to leave all columns in your table the same color. Filter Button - When checked, this box places a drop-down box next to each header in your table that allows you to change the data displayed in that column. This will take you back to the Home toolbar. Your table's changes will remain.
A: Click the Design tab. Select a design scheme. Review the other design options. Click the Home tab again.

Q: You want your perfume to be clinging to you, not oil and dirt that you have picked up throughout the day, which may distort the scent. Scent also lasts longer on skin that has been properly moisturized, and perfumes themselves tend to be drying due to alcohol content. For these reasons you should always be sure to bathe or shower and then properly moisturize your skin before applying it to your body. Rub an occlusive ointment, such as Vaseline, onto the spots you intend to spray after you moisturize in order to help the fragrance last longer. One spritz in each area should be enough, especially if you are spraying multiple areas. You don't want to overwhelm people with your smell. Make sure that you're using an unscented body lotion or one that matches your perfume. Mixing scents can create an unpleasant, overpowering effect. Although some people recommend spraying a cloud of perfume in front of you to walk into, this method results in wasted product and allows it to settle all over you including in unwanted areas. Instead, choose the areas you want to target specifically and give a direct, spritzing spray. Use restraint, especially with perfumes you have grown accustomed to over time. Your application may be stronger than you realize. Make sure that you spritz with the perfume bottle 20-30 centimeters away. If you spritz too close, the perfume will pool and the scent won't apply in a natural way, distorting the scent. You will grow acclimated to scents both in the long-term and short term, so don't think that just because you can't smell your perfume you need to reapply. Smells that are too strong to others can be unappealing and even cause nausea and headaches. Pay attention to the exact kind of perfume you are wearing in order to know when you will need to reapply. Eau de toilettes last from 4-6 hours. Eau de parfum last from 6-8 hours and the scent will change organically over time. Parfum lasts all day; you will not need to reapply. Eau de cologne is particularly lightweight, so you can more generously apply this. Although rollerball applicators are very handy, there is a downside to using them. With every application to your skin, the perfume becomes increasingly contaminated by your skin's oils. This will cause the fragrance to degrade over time. The same thing happens to tiny vials of perfume meant for dabbing, so beware.
A: Apply after showering and moisturizing. Spritz, don't mist. Do not reapply too often. Avoid dabbing or rolling on.

Q: The palm will be hiding the nostrils from onlookers who will be convinced that you are rubbing your cheeks as one does when trying to ease the symptoms of a headache, or of weariness, (simultaneously closing one's eyes makes the tactic even more effective). Use the right index finger to probe, acquire and extract the residual material. After returning the right hand to a secure location execute a flicking maneuver to eject the material.
A: Slightly cup the left hand and position it so that your forefinger is below your right eye and your thumb is below your left eye. Using a natural, confident motion bring the right hand up and under the left hand.

Q: Your Marriage Certificate will only be valid in your home country if you apply to the Foreign Office/State department. Consult a local Mexican registry office to find out the location of the nearest office. A certified copy is called Acta de Matrimonio and will be prepared at the Registo Civil office. The document must be authenticated by the Oficina de Legalizacion de Documentos, Palacio de Gobierno as it gives proof that your marriage certificate is official because of the seal and signature of the Mexican official. You will have to pay a fee determined by the state at which you are getting married. Visit the U.S. Department of State site and print out the Request of Authentications Service (DS-4194) form. Follow the prompts and fill out the form accordingly. You will need to request authentication from the U.S. Department of State via mail, walk-in, or appointment services. Mail your complete packet to Office of Authentications, U.S. Department of State, CA/PPT/S/TO/AUT, 44132 Mercure Cir, P.O. Box 1206, Sterling, VA, 20166-1206 Walk-in to the Authentication Services Counter at the U.S. Department of State from 8am to 9am, Monday through Friday, except on federal holidays, with your complete packet. Call 202-485-8000 between 9am to 12pm and 1pm - 3pm EST, Monday through Friday, to schedule an appointment with the U.S. Department of State. A complete packet should include the completed Request of Authentications Service form, copy of your marriage certificate, related documents as indicated by form DS-4194, fees, and a self-addressed prepaid envelope. You must pay a $30 fee for the first copy and $20 for each additional copy of a Certificate of Witness to Marriage. There is also $8 authentication fee per document. You may pay by cash or check, payable to the U.S. Department of state. Visit the office of Authentications at U.S. Department of State, 600 19th Street, NW, Washington, DC 20006.
A:
Ensure your marriage certificate is certified. Complete a Request of Authentication Service form. Request a Consular Report of marriage abroad. Pay the fees. Consult the US Department of State for any other queries.