Windows XP Hidden Utilities

 
1) Character Map = charmap.exe
2) Disk Cleanup = cleanmgr.exe
3) Clipboard Viewer = clipbrd.exe (view contents of Windows clipboard)
4) Dr Watson = drwtsn32.exe (Troubleshooting tool)
5) DirectX diagnosis = dxdiag.exe (Diagnose & test DirectX, video & sound cards)
6) Private character editor = eudcedit.exe ( creation or modification of characters)
7) IExpress Wizard = iexpress.exe (Create self-extracting / self-installing package)
8) Microsoft Synchronization Manager = mobsync.exe ( allows synchronization of files on the network for working offline. UNDOCUMENTED).
9) Windows Media Player 5.1 = mplay32.exe (Retro version of Media Player, very basic).
10) ODBC Data Source Administrator = odbcad32.exe
11) Object Packager = packager.exe ( packaging objects for insertion in files, has comprehensive help files).
12) System Monitor = perfmon.exe ( Everything you ever wanted to know about any aspect of PC performance )
13) Program Manager = progman.exe (Legacy Windows 3.x desktop shell, I use this when I don’t want other people messing with my machine…).
14) Remote Access phone book = rasphone.exe
15) Registry Editor = regedt32.exe [also regedit.exe] (for hacking the Windows Registry).
16) Network shared folder wizard = shrpubw.exe (creates shared folders on network).
17) File siganture verification tool = sigverif.exe
18) Volume Contro = sndvol32.exe (Just in case you’ve lost it from your tray).
19) System Configuration Editor = sysedit.exe (modify System.ini & Win.ini just like in Win98! ).
20) Syskey = syskey.exe (Secures XP Account database – BE CAREFUL.. appears to encrypt all passwords…UNDOCUMENTED).
21) Microsoft Telnet Client = telnet.exe
22) Driver Verifier Manager = verifier.exe ( utility for monitoring the actions of drivers ?( useful if having driver problems? UNDOCUMENTED).
23) Windows for Workgroups Chat = winchat.exe ( old NT utility to allow chat sessions over a LAN, some help files available).
24) "Microsoft System Configuration Utility" or simply "MSCONFIG." Designed to help you troubleshoot problems with your computer, MSCONFIG can also be used to ensure that your computer boots faster and crashes less.

Register for Pilot Exam 70-113: TS: Windows® Server 2008 Active Directory, Configuring and get 3 (three!) free exam vouchers

 

Some online sources told that this pilot is extended to October 25, 2008.

 


Registration Information

You must register at least 7 days prior to taking the exam.
Please use the following promotional code when registering for the exam: H640
Receiving this invitation does not guarantee you a seat in the pilot; we recommend that you register immediately.


To register for this pilot:

Go to the Prometric Website: http://www.register.prometric.com/ClientInformation.asp

Find Microsoft exam 70-113: TS: Windows® Server 2008 Active Directory, Configuring

Use Promo Code H640

 

 


Test Information and Support

You are invited to take this pilot exam at no charge.
You will be given four hours to complete the pilot exam. Please plan accordingly.

Though not all of the exam will be presented to the pilot candidates, we would appreciate it if you were familiar with the exams objectives. This will help us better evaluate the data from this pilot.

Find exam preparation information: http://www.microsoft.com/learning/en/us/exams/70-640.aspx


 

Update December 9, I’ve got three vouchers from Prometric "Congratulations! You are receiving 3 free exam vouchers for taking the pilot exam 70-113 and supporting the trial of the new Microsoft virtual lab-based performance testing. Vouchers are valid for any Microsoft technical certification exam and should be redeemed before 06/30/2009. "  It’s coming earlier than expected, someone on the Internet said the vouchers would be distributered in February 2009.

 

Time Calculations in Excel

Question

I have a column of cells in an Excel spreadsheet containing times like, 3:15, relating to the time spent on a task. At the bottom of the column I’ve used AutoSum to add up the times, but the result appears as either a date or funny number. What do I do to get a total in hours and minutes?

Answer

The formula you created with AutoSum is fine.

All you need do is apply an appropriate format to its result:

  • Select the cell containing the total
  • From the Format menu, choose the Cells command
  • From the Category list, select Custom
  • In the Type box, input this format [h]:mm (note the use of square brackets).
    If you want to show seconds in your total, input [h]:mm:ss (this format is listed in Excel’s Custom formats)
  • Click OK.
 

It sounds like your *times* are really text.  Try this on a Copy of you data:
Copy an unused cell then highlight the *times* and select Past Special > Add

I got:

20.41326
12.98186
6.893646

with your sample data.

Then reformat the cells as [H]:mm:ss (even if they were that format to start with)

It worked for me. 

http://www.eggheadcafe.com/software/aspnet/29923507/sum-time–strange-result.aspx

You can make a =SUM(YourRange) and then change the format to custom – [h]:mm:ss

If the times are stored as text, you can use: =SUMPRODUCT(–A1:A20) formatted as jpaulino suggested, but just note that it won’t break the minutes out into hours. (I assume from your question, you have no hours indicated)

>>What means "–" ? It’s a convertion to numeric ?
>>
>>I think I’m learning something new today 🙂 I love this!

As Rory indicates, that’s exactly what it is.  It’s sometimes referred to as "double unary".  Having just the one minus sign can force a type conversion and multiply the converted numeric value by -1.  The second minus sign multiplies again by -1, so the overall effect is to force a type conversion to a number and multiply be one (thus yielding itself).

http://www.experts-exchange.com/Software/Office_Productivity/Office_Suites/MS_Office/Excel/Q_23014415.html

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=670

新版微软入门证书——MCTS第一课: Microsoft Certified Technology Specialists in SQL Server 2005

Get Ready for SQL Server 2005 with Free* Microsoft E-Learning Courses.

Whether you are interested in database administration, database development, or business intelligence, you can access the E-Learning topic you want, when you want it, and learn at your own pace. Each lesson includes hands-on virtual labs and offline functionality. These courses, valued at $99 each won’t be free forever, so sign on today.

In addition, you may consider taking a free Microsoft Skills Assessment to help you meet your Microsoft SQL Server 2005 training goals. You’ll receive a learning roadmap with additional skills resources including instructor-led classroom training and books. Take a skills assessment today.

For more information visit the SQL Server 2005 Learning Resource page.

* Microsoft E-Learning for SQL Server 2005 is free until November 1, 2006.

链接: https://www.microsoftelearning.com/sqlserver2005/