IT DIGEST
Go to System > Notifications & actions. Do any of the following: Choose the quick actions you’ll see in action center. Turn notifications, banners, and sounds on or off for some or all notification senders. How do I block unwanted notifications? If you’re seeing annoying notifications from a website, turn off the permission: On your […]
An LCK file is an access control file used to “lock” a database or other file from being opened or changed by more than one user at a time. It prevents users from accidentally overwriting changes and possible data corruption. Can I delete LCK files? You can just delete the LCK files associated with the […]
In early devices, random restarts are also attributed to memory issues like when the device storage is running low. Corrupted system files, software bugs and malwares are also among the possible triggers, especially when the symptom occurs on recently updated and new devices. How do I stop Bootloop on iPad? Question: Q: My ipad stuck […]
Click Start, click All Programs, and then click Windows Defender. Click Tools, and then click Software Explorer. Click the application name in the Name column that you want to disable, and then click Disable. How do you turn off startup programs in Windows XP? To run it, type msconfig at a command prompt and press […]
Sum values by group with using formula Select next cell to the data range, type this =IF(A2=A1,””,SUMIF(A:A,A2,B:B)), (A2 is the relative cell you want to sum based on, A1 is the column header, A:A is the column you want to sum based on, the B:B is the column you want to sum the values.) How […]
Just select an empty cell directly below a column of data. Then on the Formula tab, click AutoSum > Sum. Excel will automatically sense the range to be summed. (AutoSum can also work horizontally if you select an empty cell to the right of the cells to be summed.) How do I sum only certain […]
Option One – simple addition Click on the cell where you want the result of the calculation to appear. Type = (press the equals key to start writing your formula) Click on the first cell to be added (B2 in this example) Type + (that’s the plus sign) Click on the second cell to be […]
Select a cell next to the numbers you want to sum, click AutoSum on the Home tab, press Enter, and you’re done. When you click AutoSum, Excel automatically enters a formula (that uses the SUM function) to sum the numbers. How do I sum only certain cells in Excel? Just select an empty cell directly […]
To approve or decline members: Tap. in the bottom right of Facebook and tap Groups then Your Groups, then select your group. Tap then tap Member Requests. You can then: Approve or Decline each request. To leave feedback for someone you declined, tap. next to their request, then select Decline with feedback. How do I […]
How to reset network adapter using Settings Open Settings. Click on Network & Internet. Click on Status. Under the “Advanced network settings” section, click the Network reset option. Source: Windows Central. Click the Reset now button. Source: Windows Central. Click the Yes button. How do I reset my network adapter Windows 10? Windows 10 – […]