INPUT ARTICLE: Article: Use a meaningful name such as "Personal Budget," "Personal Expense Tracking," or something similar. (Exclude the quotes when entering the name; they're used here only to show that the names are examples.) Suggested titles and order are "Date," "Payee Category" (or "Pay To"), "Memo," "Expense," "Revenue" (or "Income" or "Deposit"), and "Balance." Enter these titles in Cells A2 through G2; you may need to adjust the column widths to accommodate long column titles or entries. Once you've set up the spreadsheet title and column headings, use the "Freeze Panes" feature to keep these headings at the top of the display while scrolling through your entries. Freeze Panes is located on the "View" menu in Excel 2003 and earlier and in the "Window" group of the "View" menu ribbon in Excel 2007 and 2010.  Because this is the first balance entry, the balance will be determined by taking the difference between the expense and the revenue. How you set this up depends on the whether you want to look at expenses or cash on hand.  If you're setting the spreadsheet up to look primarily at your expenses, the balance formula would be =E3-F3, where E3 is the cell representing the expense and F3 is the cell representing the revenue. Setting up the formula this way will make the total of your expenses a positive number, which will be easier to understand. If you're setting the spreadsheet up to keep a running tab on your cash on hand, the balance formula would be =F3-E3. Setting the spreadsheet up this way will show the balance as positive when your cash flow exceeds your expenses and negative when you have more expenses than revenue.  Because the second and subsequent entries will keep a running balance, you need to add the result of the difference between the expense and revenue to the value of the balance for the previous entry.  If you're setting the spreadsheet up to look primarily at your expenses, the balance formula would be =G3+(E4-F4), where G3 is the cell representing the previous balance, E4 is the cell representing the expense and F4 is the cell representing the revenue. If you're setting the spreadsheet up to keep a running tab on your cash on hand, the balance formula would be =G3+(F4-E4). The parentheses around the cells representing the difference between expenses and revenue aren't necessary; they're included just to make the formula concept a bit clearer. If you want to keep the cell with the balance empty until a complete entry has been made, you can use an IF statement in the formula so that if a date hasn't been entered, the balance cell won't display a value. The formula for this, for the second entry, reads =IF(A4="","",G3+(E4-F4)) if you're setting the spreadsheet up to track expenses, and it reads =IF(A4="","", G3+(F4-E4)) if you're setting the spreadsheet up to show cash on hand. (You may omit the parentheses around the cells representing the expenses and revenue, but not the outer set of parentheses.) Right-click Cell G3 and select "Copy" from the popup menu; then drag to select the cells below it in the column. Right-click the selected cells, and select "Paste" from the popup menu to paste the formula into the selected cells. (In Excel 2010, choose either the "Paste" or "Paste Formulas" option on the popup menu.) The formula will automatically update the cell references to indicate the expense, revenue, and date (if used) references from the current row and the balance reference from the row above the current row. Give the spreadsheet a meaningful name, such as "Expense Tracking.xls" or "Personal Budget.xls." As with a template-based budget spreadsheet, you may want to include your name and the year in the file name. (Again, note that the quote marks are used only to show the example names and shouldn't be typed in. You also don't type in the file suffix; Excel provides it for you.) Excel 2003 and older save spreadsheet files in the older ".xls" format, while Excel 2007 and 2010 save spreadsheets in the newer XML-based ".xlsx" format but can read and save spreadsheets in the older ".xls" format as well. If you have several computers and plan to keep this spreadsheet on all of them, use the older format if any of your computers have Excel 2003 or older on them and the newer format if all your computers have at least Excel 2007.

SUMMARY: Open Excel. Enter a name for the spreadsheet in Cell A1. Enter column titles in Row 2. Enter your first expense item in the cells of Row 3. Enter the balance formula in Cell G3. Enter your second expense item in the cells of Row 4. Enter the balance formula in Cell G4. Copy the balance formula into the other cells in Column G (the Balance column). Save the spreadsheet.

In one sentence, describe what the following article is about: In between using a tobacco pipe, the pipe should be allowed to cool thoroughly, and the stem should be cleaned out by running a pipe cleaner through it several times. It's ok, and in fact it's a good thing if the bowl of the pipe is dark and ashy. That's called the "cake" and it helps the tobacco burn in a uniform way. Never empty a tobacco pipe and immediately repack it. The stem will likely be full of wet condensation, which will give you a hot and rattling smoke that won't taste very good. The best and most simple way to pack a pipe is to fill the bowl completely, then use the pipe tamper–a small metal rod with a flat end made for the purpose–to push the tobacco down until it's reduced by about half. If you don't have a tamper, it's perfectly fine to use your thumb, your forefinger, or the blunt end of a lighter. The tamper is nice, but not necessary. Refill the pipe to full and compress the tobacco again by half. The pipe should be roughly 3/4 of the way full, depending on the variety of the tobacco and the springiness of it. If you've got a larger bowl, you might want to add more, but that's probably enough to get started. After packing it in, you're ready to heat up the pipe and get smoking. Draw gently and rhythmically to avoid overheating the pipe or flustering the tobacco. Packing a pipe is an art form that will take some practice, but it also doesn't need to be any more complicated than you want it to be. You don't need fancy equipment or expensive tobacco to pack a good pipe. If your pipes are going out frequently, though, you might have a malfunction in your pipe stem, or you might be packing the pipe too loosely. Experiment some, and ask a tobacconist for help if you're struggling.
Summary: Only pack a clean, well-maintained tobacco pipe. Fill the bowl with the tobacco of your choice and push it down by half. Add another few pinches to fill the bowl. Light the tobacco and draw gently. Ask a tobacconist to demonstrate, if your pipes go out frequently.

INPUT ARTICLE: Article: Once you're in the worksheet, click on any cell on the worksheet to ensure that the window is active. Hit the key combination Ctrl + F on your keyboard. A new window will appear with two fields: “Find” and “Replace with.” Enter the exact word or phrase you want to search for, and click on the “Find” button in the lower right of the Find window. Excel will begin searching for matches of the word, or words, you entered in the search field. All words in the document that matches those you entered will be highlighted to help you better locate them.

SUMMARY:
Click a cell. Open the Find/Replace With window. Type in the words you want to find.