In Excel the IF function is used to return a condition based on both the TRUE and FALSE evaluations of an argument. The syntax for the IF function is: =IF ( logical_test, value_if_true, value_if_false ) logical_test – a value or expression that is tested to see if it is true or false. value_if_true – the value that is displayed if logical_test is true. value_if_false – the value that is displayed if logical_test is false. Before you get into creating an IF function, it is best to write out exactly what you are attempting to accomplish. If you can explain it logically, you can…
Author: Computing Staff
When we start our computer, some programs will automatically start up, which will slow down Windows running speed. Of course, some programs has an option for you to stop it running automatically. But some doesn’t, such as Microsoft’s new utility Snip. So, here is a tip for you to disable these programs from auto starting up in Windows 10. Step 1: Input “msconfig” in the Windows search box. And click the System Configuration, or just hit Enter to open it. Step 2: Click Startup > Open Task Manager, then right-click on the application you want to stop from starting up, choose Disable. Alternatively, you can also…
Initial considerations When an Apple application or the system itself stops working right on your iPod/iPhone/iPad there is nothing you can do to repair that particular part of the software or function. Or it is not mean to be for the average user but Apple provides one solution to fix all Apple software failures. This is the Restore function on iTunes available when you connect your device to your PC or Mac. If the problematic app is not from Apple try to remove the app first and then restore or sync again this app. This is a documented restoring procedure that works with the…
The program that DOS supplies for setting up hard disk partitions is called FDISK, which is believed to stand for “fixed disk”, an older term for hard disk. FDISK is used only for DOS (FAT) partitioning, and allows the user to perform the following functions: Create Partitions: FDISK allows you to create a primary DOS partition or logical DOS volumes. To create a logical DOS volume you must first create an extended DOS partition, since the logicals are contained within the extended partition. Set Active Partition: You can use FDISK to set the primary partition on your boot disk active,…
Microsoft SQL server database can be corrupt or damaged due to any reasons at any times. Here are some possible reasons that are responsible for SQL database corruption: Platform Issue – 95% SQL database corruption occurs due to this SQL server or driver bugs Sudden power failure or virus attack Hardware issue If this happen with you then this How-to is beneficial for you. The best and effective solution to fix any types of SQL server corruption issue is restoring the database from clean and updated backup. If you don’t have backup of the corrupt database then follow below…
Close any programs you may have running – especially your web browser. Go to Start > Control Panel double-click on Add/Remove programs and remove all older versions of Java. Here are a bunch of examples of how older versions may appear. Uninstall all of these if found: IBM 32-bit Runtime Environment for Java 2, v1.4.2 Java Runtime Environment 1.1 Java 2 Runtime Environment Standard Edition v1.3.1_02 Java 2 Runtime Environment Standard Edition v1.3.1_04 Java 2 Runtime Environment, SE v1.4 Java 2 Runtime Environment, SE v1.4.2_01 Java 2 Runtime Environment, SE v1.4.2_03 Java 2 Runtime Environment, SE v1.4.2_05 Java 2 Runtime Environment, SE v1.4.2_06 J2SE Runtime Environment 5.0 J2SE Runtime Environment 5.0 Update 1…
Microsoft has stated they will continue to release signature updates for Microsoft Security Essentials on Windows XP after April 8, 2014, but will remove the download page. I find it odd that they will continue supporting the program but not offer a way to download it. However, there are two ways to access it after this date: The program can be directly downloaded for AMD 64 x64 bit users here and for Intel 32 x86 bit users here. If these links should fail in the future, you can always fall back on the Internet Archive’s Wayback machine: Archived link for AMD 64 x64…
By default Windows 2003 server systems comes with shutdown event tracker enabled. This provides a way for us to consistently track why users restart or shutdown the computers. This information is very much useful for the IT administrators to track the reasons for shutdown the important systems. But it is annoying if we use that system as development platform like i am using. I use windows 2003 system as my development environment because sharepoint services supports in windows 2003. My primary work is with sharepoint services. Usually everyday i shutdown the system while going home from work and sometimes i…
This is my presentation to simplify a considerable amount of information in a way that could be useful for those who just need a basic comprehension of this subject and it could be valuable for those wanting to know more. There is a lot more to know about this. Another consideration I want to clearly explain here is I am not encouraging illegal use of copyrights. I use Handbrake, other software and commercial movies for my personal entertainment and back ups and my intention here is to give you some information about compression for videos and movies, specifically for Apple…
Sometimes, you may don’t like the default font in excel. You change it in an excel file, but when you create another new excel, the font is still not the one you like it to be. So, here are the steps for you to change the default font in Excel 2010. Step 1: Create an excel file, click Home and find Cell Styles. Step 2: Click the upside down triangle besides Cell Styles. Right-click Normal. This is for changing the whole normal words font in the excel. Then hit Modify. Step 3: Hit Format when another small window pops up. Step 4: Choose Font when the format window pops up. And set…
Sometimes, there are necessities for us to change system language. For instance, we may need to take screenshots to help a foreign friend to do some settings or fix a problem. Anyway, here I’m gonna show you how to change the system language in Windows 10. It’s really super easy. Step One: Right-click your mouse, a menu will show up, choose Display settings. Step Two: When the Settings window pop up, click the settings icon on the top left. Step Three: Then, choose Time & language. Step Four: Choose Region & language, and then choose Add a language on the right side. Step Five: Then a window will…
Please note: I have posted this in the Windows XP section because of the huge installed user base; however, these instructions will work for all Microsoft Windows operating systems running Internet Explorer 6. Google Instant Search usually crashes Internet Explorer 6 in Windows 98 NT ME 2000 and XP. Here is the workaround: Step 1. Open IE and go to http://google.com In the upper right hand corner click Settings > Search Settings. If you have Javascript disabled then just go to http://www.google.com/preferences?hl=en Step 2. Scroll down to the section “Autocomplete” and select “Do not provide query predictions in the search box.” Step 3. Then click the…
If dns cache is not flushing with “ipconfig /flushdns” command, you need to: Step 1. Make host file editable a. Find your hosts file (%SystemRoot%\system32\drivers\etc\hosts) b. Uncheck the Read Only attribute Step 2. Edit your hosts file (in this case by using notepad): a. Open notepad (right click and run as administrator) b. Open the hosts file with notepad (make sure to change the type search to All files and not just .txt) c. delete all lines referencing unwanted sites (just leave “127.0.0.1 localhost”) d. save the file & close it Step 3. Make host file Read Only again a. Find your hosts…
So, Your Windows XP Start Menu All Programs Looks Like A Junkyard. Here’s How To Make It Look Clean Like When You First Installed XP. Your start menu all programs may look like this when it is about time to clean it out: So now let’s get to cleaning it out. Choose which way you wish to do this: A) Make a second start menu. (Easier but more time consuming). B) Organize your start menu and clean it out. (Takes more thought and organization skills). For A: Step 1. Create a new folder on your desktop. Call it “Start Menu”…
So you have added a second drive to your 9x/ME system and created/formatted it. Now you can’t boot into the OS. This is the result of the way dos/9x enumerates partitions. It goes first drive primary is c: and second drives first primary is d:. Click to view rules of drive letter assignments. You have two issues here. Msdos.sys file and its pointer. But the biggest issue is your registry has everything on d: so even if you got 9x to boot it wouldn’t load correctly. This is what you have to do to solve this issue. Remove the 2nd…