The following message arrived in one of my Inboxes (I have 8):
And there was an attached file, Auth_Form.html. I assume I was supposed to double-click it; I further assume it contained a harmful script. This email wasn't really from PayPal; note the extra letter "i" in the return address: paypail.com. I don't freakin' think so! I could easily have been fooled by this one; I recently started using PayPal again, after a few years of letting the account sit idle, and I tried several times to log on before I finally remembered ny username and password. But...
Tips.Net
We have a new contributor joining us this month. Sharon Parq Associates owns the popular Tips.Net website, and they've generously offered to share two free tips a month on this page, usually one Word and one Excel tip. Their tips seem to be for intermediate Windows users, the level I perceive the majority of our readers to be. Thousands of additional tips are available at Tips.Net .
There may be times when you need to derive the smallest (or largest) value from a range, unless the smallest (or largest) value is zero. For instance, you might have a range of values such as {0, 3, 1, 4, 2}. In this case, the lowest value is zero, but the value you really want returned is 1.
There is no intrinsic function within Excel to return a value as stipulated here. However, you can create a formula that will do the trick. Assuming that the range of values you want to analyze are in C4:C8, the following formula will return the lowest non-zero value:
This formula uses the MIN function to determine if the lowest value in the range is zero. If it is, then the SMALL function is used to derive the lowest value, excluding the zeros. (The COUNTIF function returns the number of zeros in the range, and therefore tells SMALL which item from the range to pick.)
A small change to the formula allows it to be used to return the largest non-zero number in a range:
These formulas will work for any range, unless the range is made up entirely of zeros. In that instance, a #NUM! error is returned.
Copyright © 2009 by Sharon Parq Associates, Inc. Reprinted by permission.
Word provides a powerful table editor that allows you to create and modify data in tabular format. If you are working with large tables, there may be times when you need to split a table in half. To do this, follow these steps if you are using Word 2007:
Copyright © 2009 by Sharon Parq Associates, Inc. Reprinted by permission. Avast! Did a Boo-Boo!
Yeah I know, I've been pushing Avast! like they were the only anti-virus package out there. And as far as I'm concerned, they are. But even the best can screw up once in a while; heck, I made a mistake myself, 'way back in '97. But enough about my love life, let's stick to computer stuff.
The initial release of Avast!'s Dec 3rd virus definition file contained an error, causing it to identify nearly ALL programs that check files on the Internet as being infected with the Delf-MZG Trojan. As I've said so many times, I trust Avast! implicitly, so when it said I should run a boot-time scan, I did. It found 165 'infected' files, and when the Virus Chest was full, I let Avast! delete the rest of the files it found.
I was disappointed that so many programs seemed to be damaged, especially since so many of the 'infected' files had come from GiveAwayoftheDay.com, and can't be reinstalled. (I've been meaning to do another full backup, but there just never seems to be enough time!) I was even more disappointed after I did a Google check and found out thousands of people were posting comments saying the 'Delf' detections were 'false positives': harmless files that shouldn't have been moved or deleted.
I filed a 'false positive' report with Avast!, really too late to matter; they had released a new Dec 3rd virus definition file by 1:00AM. So, only night owls like me were likely to get bitten by this mistake; you had to have your computer on and opening files between midnite and 1:00 to get caught.
Once I realized the files weren't really infected, I opened the Avast! program, went to Tools » Virus Chest, highlighted all the files, and clicked on File » Restore to put them all back where they came from.
What I SHOULD have done: When files that had gotten past Avast!'s Resident Shield as they were initially installed suddenly checked out as infected when I tried to open them, it would have made a lot of sense to check for an even newer update before running a boot-time scan. The folks at Avast! are very sharp; in the extraordinarily rare event they make a mistake like this, it only takes a few minutes and one or two thousand 'false positive' reports for them to realize and rectify the error.
Bottom line: Be Skeptical, take practically nothing on faith, even from trusted sources. Excepting myself, of course.
Till next month... |
I send these guys a few dollars every month... sure wish you would join me.
And 100% of your labor charges go to this rescue, too.