Problem: Write an article based on this summary: Open the Google Sheets site. Select a Google spreadsheet. Select the data you want to sort. Click the Data tab. Select a sort option. Review the results.

Answer: Go to https://docs.google.com/spreadsheets/ in your browser. This will open a list of your Google spreadsheets if you're logged into your Google account. If you aren't logged into your Google account, you'll be prompted to sign in with your Google email address and password first. Click the Google spreadsheet that you want to edit. You may have to scroll down to find the right one. If you haven't yet created the spreadsheet that you want to alphabetize, first click Blank and then enter your data before continuing. Click the top cell in your data's column, then drag the mouse down to the last full cell in that column. This will highlight the data in this column. You can only sort one column at a time if you don't want to rearrange other parts of the spreadsheet to correlate with your rearranged column. It's near the top of the page. Doing so prompts a drop-down menu. Click one of the following options:   Sort range by column [Letter], A → Z - Sorts your selected data into alphabetical order, but leaves the rest of the spreadsheet as it is.  Sort sheet by column [Letter], A → Z - Sorts your column in alphabetical order and adjusts the rest of the spreadsheet to correlate with the re-sorted data. Your selected data should now be rearranged into alphabetical order. If you don't like the results or you accidentally clicked the wrong option, press Ctrl+Z (Windows) or ⌘ Command+Z (Mac) to undo the sorting.


Problem: Write an article based on this summary: Set clear boundaries. Remain calm. Allow your child to reap what he or she sows. Use time-outs as a consequence. Withdraw privileges.

Answer: Children thrive when they feel secure in their environment and understand what is expected of them. Develop a consistent household structure, clear expectations, and logical consequences if these expectations are not met. Avoid responding to your child's poor attitude with anger.  Instead, calmly deliver your request and then disengage.  If your child is younger or may place him or herself in a dangerous situation, disengaging may mean selectively ignoring your child's poor behavior while continuing to actively supervise.  If your child is older or in safe circumstances, leave the room (always remain within earshot of a young child). While counting to three, five, or ten is often recommended as a tool to redirect a child's behavior, it may provide even greater benefit for a beleaguered parent.  Count in your head before responding to your child's frustrating behavior.  Doing so gives you a few seconds to regroup and calm your own frayed emotions. Let reality be your child's teacher.  Follow through on the consequences you've set for poor behavior.  If your child has been told, for example, that if she responds to your requests with sarcasm she cannot attend Friday's football game, hold firm in your resolve.  She'll learn that poor behavior has real consequences.  Issue reminders -- but hold your child responsible for following through.  Developing brains do sometimes forget what they've been asked to do, so plan on allowing some leeway for a reminder or two.  You might even try a written reminder.  Consider developing a system of "warnings," but follow through with consequences if those warnings aren't heeded.  Remember that to attain the long-term goal of a well-behaved child you may have to deal with short-term personal discomfort.  You may have heard the adage, "punishing the child punishes the parent," and while you're listening to a temper tantrum or dealing with an angry teenager you'll recognize the truth of this saying.  In the end, though, your job as a parent is to struggle through the immediate discomfort of a situation, recognizing the long-term benefits at stake. Children often display poor attitudes and other bad behavior because they feel out of control.  Employing a time-out interrupts the cycle of this behavior, giving the child a moment to regroup and reflect.  Consider targeting the length of a time-out to the age of your child (for a 2-year-old, for example, set a timer for two minutes). Ensure the privilege withdrawn relates in some way to the poor behavior you're trying to correct.  A child who refuses to put down his video game console, for example, may lose the use of this toy for a day. This technique works best as part of a pre-arranged behavior management strategy.  Sit down with your children and decide upon behaviors you expect -- and privileges they'll receive in return.  For example, you might agree that your child will receive the privilege of watching a favorite television program if she completes her homework without fussing.  Creating a system helps children learn that with increased privileges come increased responsibilities.


Problem: Write an article based on this summary: Replace the old flange around the drain opening with a new one. Fit a new wax ring around the bottom of the toilet bowl, just around its drainage hole. Ensure flange is tight to floor. Lift and place the toilet bowl over the anchor bolts protruding from the floor. Once the anchor bolts fit snugly inside the floor bolt openings, rock the bowl from side to side in order to create a seal on the toilet drainage hole. Insert the bolts through the tank and base, then tighten lightly by hand. Insert shims or other spacers underneath the toilet to make it level. Tighten the floor bolts gradually with an adjustable wrench until secure. Install the decorative caps over the floor bolts. Carefully fit the basin over the bowl, making sure the basin bolts fit inside the bowl. Reconnect the water line and turn on the water supply. Caulk around the base of the toilet to ensure a good seal.

Answer:
Unbolt the old flange and place the new flange over the hole. Next, drive in any mounting bolts through the flange and into the floor. Wax rings come either plain or with a funneled inside edge. If the flange is not tight on the floor it may be necessary to remove the wax ring and try again. Tighten or replace the flange screws if necessary This step is tricky and may take several tries. Shimmy the toilet form side to side much like you did to remove the old toilet (see above). Be sure not to over-tighten these bolts too much or tank will crack.  Tighten one side a bit, and then move on to the other side. In other words, tighten simultaneously as much as possible. Over-tightening can result in a cracked bowl. Get the right balance between sealed and too-tight.  Tighten the basin bolts by hand. Do not over-tighten.