Problem: Write an article based on this summary: The Total of The Students’ Grades  The average of the gradesTo find the average of the grades for each student, we will divide the total found in the "total" column by the maximum total possible. Translate The Calculated Average Grades to Final Letter GradesExcel allows us to add a function that automatically calculates a grade based their averages in column J. Type The Formula.

Answer: Select cell I 6 (the cell directly below the "Total" cell) Under the Formulas menu, select Auto Sum Click and drag cells D6 through H6 across the row. Press Enter  To copy the formula to the entire Total column, Click and drag the fill handle until you reach cell I15. (this will copy the function to each row, calculating the total grades for each student) (in this example, we will assume the maximum total possible of the grades is 500)  Select cell J6 (the cell directly below the "average" cell) Click on the Formula bar to type Type =16/500  Press Enter  From cell J6, click and drag the fill handle to the entire average column, until cell J15 To format the average in a percentage form, select the column J6 to J15 Right click on the selected column Choose Format Cells, a dialog box will appear From the Number tab, click on the Percentage category  Change the number of decimal places as you prefer Click Ok. To perform this function we will need a key, which is simply table of letter grades and corresponding numbers. We will use a sample table from Excel.  Create The Key Table Select cell M7, we will start typing the table here  Type "Average", this will be the first column Press the tab key Type "Grades" Under "Average" type your grading scale scores Under the "Grades" column, type the corresponding letter grade to each score The function required to return a letter grade is the VLOOKUP function, and is called a nested function. It follows the formula:VLOOKUPlookup_value,table_array,column_index_number,[range_lookup])  Select cell K6 Start typing the formula =VLOOKUP(J6,$M$18:$N$22,2,TRUE) Explanation: after the brackets, type the cell that contains the final score of the student which is in this example cell J6. The second part of the formula is automatically included by selecting the key table; press F4 from the keyboard to insert the dollar signs that will lock the range selected. The third part is the column number from the table that contains the letter grades. True stands for approximate match with the values of the column, false will result in exact matches.  Press Enter Copy the formula down to the entire column until cell K15 by clicking and dragging the fill handle from cell K6. Repeating this process will allow you to calculate grades for other classes in the future.


Problem: Write an article based on this summary: Think about the connotations of the words you use. Make sure it's searchable and pronounceable. Choose something that you can at least pretend you have a story for. Test your name out.

Answer: All words have connotations, and you want the ones you use in your stage name to relate to the style, culture, and genre you're trying to fit in. People are more likely to be drawn to a name that relates to the genre they are interested in. Cliche or not, there's a reason so many surf rock bands use the word "beach." If you want people to be able to find you online, having a stage name like "Pencil" is going to hinder you. Your stage name should be something that can be put into google just as it is, and comes up with your online presence. And if people can't hear what you're saying when you tell them your name, or they can't spell it after hearing it, that's one more roadblock to being remembered. If you've picked a good stage name that's memorable and stands out, people are going to ask you about it. You want to have more to say other than it sounded good. The best way to do this is to think about choosing a stage name that actually means something to you, at least in some small way.  Bono got his stage name from a childhood nickname, "bono vox," which is Latin for "good voice."  Slash claims he was called his stage name as a kid because he was always running all around. Try to get as much feedback as you can from friends and people you know about your new stage name. Maybe your name makes a reference that is too obscure, or it isn't as easy to hear when spoken in a crowded bar as you thought. Getting second and third opinions is essential, because your stage name is all about how you want people to see you.


Problem: Write an article based on this summary: Clean non-machine washable items with hot water and detergent. Try using a commercial product on leather. Wash tools and gear with rubbing alcohol or detergent. Take your clothing to a dry cleaner if necessary.

Answer:
Wear long rubber gloves when hand-washing an item that can’t go in the washer, like a leather jacket or shoes. Mix two tablespoons of laundry or dish detergent with two cups (480 mL) of hot water. Soak a sponge with the cleaning solution, wash the item’s surface, then wipe away soapy residue with a wet cloth.  You can use a toothbrush to scrub hard to reach places. Just remember to throw out the toothbrush and sponge when you’re finished. To clean shoelaces, remove them and soak them in the cleaning solution, then rinse them under hot water. Check your item’s care instructions and test any cleaning solution on an inconspicuous area before washing the entire item. If you’re concerned about using detergent on leather garments or shoes, you can try applying a commercial urushiol removal product. Saturate a dry cloth with the product, rub it onto the item, then wipe it away with a wet cloth. Check your product’s label or website to verify it’s safe for leather, and test it on an inconspicuous area first. Don’t forget to wash garden tools, golf clubs, jewelry, and any other exposed items. Rinsing them with rubbing alcohol will do the trick. If you don’t have any handy, or are concerned about how alcohol might effect an object, wash it with dish or laundry detergent and hot water. If you have any doubts about hand-washing a delicate item, it’s best to leave it to the professionals. Dry cleaners use chemicals that aren’t water-based, so if your garment can’t handle any water exposure, a professional can remove urushiol without damaging it. Be sure to keep your clothing in a plastic bag, and let your dry cleaner know that the items were exposed to poison ivy.