Radschool Association Magazine - Vol 24 Page 4 |
|
Privacy Policy | Join the Association | List of Members | Print this page |
|
Computers and stuff.
Sam Houliston. |
|
Excel Tip.
When working on a large Excel file with entries in multiple cells, it’s a lot easier to read and understand all those numbers when you colour every second row. There are two ways of doing this, one is to hold down the Ctrl key, highlight every second row and then click FORMAT, then CELLS, then PATTERNS then select a colour. This works well, but, if you delete or insert a row or a cell at any time after doing this, it throws the whole thing out of whack. The other way, which is a heap easier, is to do the following
1. Select and highlight the range of cells you wish to format. 2. Click Format then Conditional Formatting. 3. In the drop-down box, select “Formula Is”. 4. In the box type: =MOD(ROW(),2)=0 5. Click the Format button and then click the Patterns tab. 6. Select a colour for the shaded rows and click OK twice.
|
|
|
|
The real beauty of this method is that even if you delete a row or a cell in your table, the banding will be maintained automatically. If you find you don't like your chosen colour, simply select the range once more, open the Conditional Formatting box and choose another colour. |
|
Web Address Shortcut.
Let’s say you want to log onto the following address www.webaddress.com. Instead of having to type the full address into your browser, all you have to do is type the bit in the middle, ie “webaddress” then press Ctrl+Enter and Voilà, Internet Explorer and/or Firefox will automatically add the “WWW” to the beginning and the “.Com” bit to the end. If you want to go to www.webaddress.net, just press “Shift+Enter” instead. Try it!!
|
|
To DVD or not to DVD.
Are you looking to buy a new DVD burner for your computer but don't know what format to choose, well, you ain’t Robinson Crusoe there…There are burners for DVD-R, DVD+R, DVD-RW, DVD+RW and some that support a combination of the formats. There’s also DVD-RAM and Blu-ray, enough different formats to confuse anybody. SO!! - Which one do you choose??
The best way to tackle this is to have a look at each category separately.
On the player side, about 80% of players (and just about 100% of newer players) will play both types, but, again, you may run into players that play only one format or the other. The bad part that there is no way to tell other than by trying a sample of recorded media, and in a few cases players may also be finicky about the brand of media. So, really, to be absolutely sure, you have to actually try the media that you plan to use. However, most modern computer drives do play both, where you usually see issues is with older “set top box” DVD players.
As a comment here, my own experience, and I know that most experienced DVD users would agree, is that the “-“ media is slightly more compatible than the “+” media, which is interesting because during the design phase, and “on paper”, it was supposed to be the other way around. But the “real world” didn’t read the design specs.
|
|
A picture might be worth a thousand words, but it uses up three thousand times the memory. |
|
New Folder
If you’re like me, and use Windows Explorer a lot, you’ve probably wondered why Microsoft hasn’t equipped it with the “New Folder” facility. When you access the Open or Save dialog box in any application, you know that the toolbar contains the Create New Folder button, however, Microsoft has never put such a handy button on the toolbar in Windows Explorer.
Fortunately, you can add a “Create New Folder” command to Windows XP's context menu. Here's how:
· Launch Windows Explorer and select Tools | Folder Options. · In the Folder Options dialog box, select the File Types tab. · In the Registered File Types list, select Folder, and click the Advanced button. · In the Edit File Type dialog box, click the New button. · In the New Action dialog box, type Create New Folder in the Action text box and type CMD.EXE /C MD "%1\Create New Folder" in the Application Used To Perform Action text box. · Click OK twice and then click Close to close the three dialog boxes.
Now, whenever you want to create a new folder in Windows Explorer, simply right-click on the folder in which you want to create the new folder and select the “Create New Folder” command from the context menu.
|
|
Prefetch.
One of Microsoft's big selling points for Windows XP was that it loads applications much faster than its predecessors. To accomplish this feat, Windows XP uses what is called the "Prefetch technique," in which the operating system gathers information about each program that you launch and stores that information in the \Windows\Prefetch folder. Then on subsequent restarts, Windows XP uses the information in the Prefetch folder to essentially preload parts of those programs at boot time. Thus, when you launch your application, it appears to load really fast.
|
|
Vista RUN.
Where’s the Run entry on Vista’s Start menu gone? If you’re familiar with the Windows XP Start menu, and you've updated to Vista, you've probably realized that “Run” is missing in Vista. On Vista, Microsoft decided to hide this feature. It’s still there, though. Just press the Windows Key and R together and the dialog box will appear. However, if you want it to be on the Start Menu permanently, you can do it. Here’s how:
|
|
Analyse your hard drive.
If you're like most people, your hard drive quickly fills up with all sorts of stuff, music, pictures, data files, programs and other stuff. And even if you're good at archiving content onto DVDs or external drives, no matter how big it is, your PC's hard disk is often just about chockers. To keep your machine running at top speed, you have to perform regular maintenance and sometimes it helps if you know just what you have stored on that drive. Here is a handy little program which allows you do just that.
By default, the files that take up the most space are coloured blue, the second heftiest are red, and the third largest green. After the first 10 colour-labelled file types, the rest appear in gray--but you can change these settings and colours through the Options menu.
Once you've identified where your disk space has gone, you can then more easily decide where you can save space. WinDirStat is loaded with features for managing your files, such as the ability to automatically delete files without even bothering with the Recycle Bin.
|
|
|
|
Morris and his wife Esther went to the state fair every year, and every year Morris would say, 'Esther, I’d like to ride in that helicopter.' Esther always replied, 'I know Morris, but that helicopter ride is fifty dollars, and fifty dollars is fifty dollars' One year Esther and Morris went to the fair, and Morris said, 'Esther, I'm 85 years old. If I don't ride that helicopter, I might never get another chance.' To this, Esther replied, 'Morris that helicopter ride is fifty dollars, and fifty dollars is fifty dollars.' The pilot overheard the couple and said, 'Folks I'll make you a deal. I'll take the both of you for a ride. If you can stay quiet for the entire ride and not say a word, I won't charge you! But if you say one word, it's fifty dollars.' Morris and Esther agreed and up they went. The pilot did all kinds of fancy manoeuvres, but not a word was heard. He did his daredevil tricks over and over again, but still not a word. When they landed, the pilot turned to Morris and said, 'By golly, I did everything I could to get you to yell out, but you didn't. I'm impressed!' Morris replied, 'Well, to tell you the truth, I almost said something when Esther fell out, but you know, fifty dollars is fifty dollars!' |
|
|
|
|