Posts

Showing posts from August, 2022

Basic Excel Functions Everybody Should Know

Image
   Microsoft Excel contains many functions that allow you to perform tasks without a calculator or extra work. But if you’re unfamiliar with formulas, it can feel intimidating. Here, we’ve listed 12 simple but useful Excel functions to get you started.   Table of Contents 1. Add Numbers in Cells: SUM 2. Average Numbers in Cells: AVERAGE 3. Find the High or Low Value: MIN and MAX 4. Find the Middle Value: MEDIAN 5. Count Cells Containing Numbers: COUNT 6. Insert the Current Date and Time: NOW 7. Round to a Certain Number of Digits: ROUND 8. Truncate a Number by Removing the Fraction: TRUNC 9. Find the Product by Multiplying Cells: PRODUCT 10. Use the Reference Number of a Given Cell: COLUMN and ROW 11. Eliminate White Space: TRIM 12. Count the Number of Characters in a String: LEN 1. Add Numbers in Cells: SUM One of the most basic things you can do with numbers is add them. Using the SUM function in Excel you can add numbers in cells. The syntax is SUM(value1, value2...

5 Ways to Remove the Administrator Password in Windows 10

Image
Do you want to clear the administrator password and let Windows boot directly into the desktop? How to remove Windows 10 password if you’ve forgotten it? In this tutorial we’ll show you 5 ways to remove the administrator password in Windows 10. Option 1: Remove Windows 10 Administrator Password from Control Panel Open the Control Panel in Large icons view. Click on User Accounts . Under the “ Make changes to your user account ” section, click Manage another account . You’ll see all the accounts on your computer. Click the account you’d like to remove the password for. Click the “ Change the password ” link. Enter your original password and leave the new password boxes blank, click on Change password button. It will remove your administrator password immediately. Option 2: Remove Windows 10 Administrator Password from Settings Open the Settings app by clicking its shortcut from the Start Menu, or pressing Windows key + I shortcut on your keyboard. Click on Accounts . Sele...

Reset Windows 7 password with command prompt on login screen

Image
Windows 7 computer is locked, can command prompt be run to reset Windows 7 forgotten password? The answer is yes, but the operation will be a little complicated. Now this way will walk you through how to reset forgotten password with command prompt on locked Windows 7 computer step by step. Step 1: Force power off your computer. Start your computer and when you see it saying Starting Windows . Hold down the Power button for at least 5 seconds to force power off your computer. Step 2: Restart computer and choose "Launch Startup Repair (Recommended)". Next time, when you power on your computer, two options will be available, launch startup repair and start normally. If you have no admin password to access computer, please choose the recommended option. Note: Startup Repair will boot up and when it asks if you want to restore computer, click "Cancel" button. Step 3: Click on "View problem details" while Star...

Windows S Mode - how to disable it and switched to windows 10 pro

Image
Windows S Mode is a security feature found on select freshly sold computers, such as Samsung laptops and Microsoft Surface tablets. It effectively prevents the user from installing anything other than what is available in the Windows 10 Store, and they can only use Edge as their browser and Bing as their search engine. This inhibits the installation of Chrome, classwork applets, and Zoho Assist. If you are unsure whether it is activated, go to the About area of your Windows 10 pro version. Open the Start Menu . This is the button in the lower-left corner of your screen shaped like the Windows logo. Then click Settings . This is the button with the gear icon just above the power options. In the Settings window, click System . Then click About in the left sidebar . You will find what mode of Windows you have under the Windows Specification section. Disabling is fairly easy to do, and ensure them that nothing will explode on their device if they do.  Windows throws messages at them ...

How to Create a Bootable USB for Mac? (BigSur) or any MacOs

Image
  How to Succeed as a Computer Technician: Tips and Strategies To create a bootable USB drive of macOS Big Sur, you will need a USB drive with at least 16 GB of storage space and a computer running macOS Big Sur or later. Here are the steps to create the bootable USB drive: Connect the USB drive to your computer. Open the "Terminal" application, which can be found in the "Utilities" folder within the "Applications" folder. In the Terminal, type the following command and press Enter: sudo /Applications/Install\ macOS\ Big\ Sur.app/Contents/Resources/createinstallmedia --volume /Volumes/MyVolume Note: Replace "MyVolume" with the name of your USB drive. Press Enter when prompted for your administrator password. The Terminal will display a series of messages as it creates the bootable USB drive. Once the process is complete, type the following command and press Enter: diskutil list This will list all connected drives and their disk iden...

Diagnostic method for laptop power supply circuit failure

 The motherboard power supply circuit of the laptop computer is an indispensable part of the laptop and its problems usually lead to various failure phenomena such as failure to boot, automatic restart, and crash etc. To learn the diagnosis and elimination of the fault of the power supply circuit of the laptop motherboard: Firstly, the basic working principle should be mastered. Secondly, the common fault phenomena caused by the problem of the power supply circuit of the motherboard should be understood. Finally, the maintenance experience of the power supply circuit of the motherboard should be continuously summarized and learned. method. 1- Laptop motherboard power supply circuit basics There are two ways to supply power to the laptop motherboard. One is the dedicated rechargeable battery for laptop computers and the other is to convert 220V mains to 19,5 or 20 volts. Powered by the power adapter. The laptop's dedicated rechargeable battery typically provides a lower supply volta...

INTEGRETED CIRCUITS

Image
    Letter that symbolizes the Integrated circuits (IC) on the motherboard is U and may have another letters PU. EEPROM An EEPROM short for (electrically erasable programmable ROM) it is an integrated circuit (IC). In terms of applications, stores information that can only be read. Modifying it is either very difficult, EEPROM is also a type of non-volatile storage, which means that the information is maintained even if the component loses power. In the picture below, is an example of what a EEPROM chip may look like on your laptop motherboard. It contains the basic instructions for what needs to happen when a laptop is powered on. This is typically referred to as the firmware of a laptop. The firmware represents the basic code to get the laptop started. Firmware is also referred to as BIOS or basic input/output system. The BIOS also includes a test referred to as a POST (Power on Self-Test) which will ensure that the laptop meets requirements to boot up properly. If the lapto...