Posts

Showing posts from April, 2023

Things to know before admitting your kids to school

Here are few things that you must know or take care of before admitting your kids to school. If you are not taking care of these things, you might be putting you children to wrong school, risking life. Only irresponsible parents do this mistake who all do not love their children or one who are not serious about their children or one who are uneducated. So, let me guide you to few thins that you need to take care of before admitting your children to school. 1. See if school is registered to local registerer (respective government). 2. Check the classroom, bathroom, playground, kitchen, it needs to be clean. 3. Sit in the classroom for 5 to 10 min., see how they lecture children. 4. Check the school fee, other fee, transportation fee, see if you can afford. 5. Check the food they fed to children, how many times, they give food to children. 6. Check the school duration, start and end time, usually for children 4 to 8 hours, see for how long your student can sit in class. 7. Ask for holida...

How to Manage Boot Configuration of Windows using CMD

Image
In CMD (Command Prompt), the "bootcfg" command is used to manage the boot configuration data (BCD) for Windows operating systems. This command is used primarily to configure the boot.ini file for older versions of Windows, as newer versions use the BCD store. The syntax for the "bootcfg" command is: bootcfg [options] The " options " argument is optional and can be used to modify the behavior of the command. For example, the " /add " option can be used to add a new operating system entry to the boot configuration data. For example, if you want to reconfigure boot.ini file to remove any defects, you may use the following command: bootcfg /rebuild The command will scan all drives for any Windows installations, display the results, and step you through building the boot.ini file. Note that the " bootcfg " command is not available in newer versions of Windows, which use the BCD store instead of the boot.ini file. In these version...

How to Delete Files using CMD

Image
In CMD (Command Prompt), the " del " command is used to delete one or more files.   The syntax for the " del " command is: del [options] file_name(s)   The " options " argument is optional and can be used to modify the behavior of the command. For example, the " /p " option will prompt the user to confirm before deleting each file. For example, to force delete a file named "file.txt", you can use the following command: del /f file.txt This will delete the file permanently in the current directory.   Note that the " del " command permanently deletes files and cannot be undone. It is important to be cautious when using this command to avoid accidentally deleting important files. Additionally, the " del " command is not specific to CMD and is also available in other command-line interfaces, such as PowerShell and Linux terminal.

How to Clear Unnecessary Empty Data Blocks from System using CMD

Image
In CMD (Command Prompt), the "defrag" command is used to defragment a hard drive. Defragmentation is the process of reorganizing the files on a hard drive so that they are stored in contiguous blocks. This can improve the performance of the hard drive by reducing the time it takes to read and write data. The syntax for the "defrag" command is: defrag [volume] [/a] [/h] [/m] [/u] [/v] Where " volume " is the drive letter or mount point of the volume you want to defragment, and the optional parameters are: /a: Analyze the volume and display a summary of the fragmentation levels /h : Run the defragmentation operation at a higher priority /m : Defragment multiple volumes simultaneously /u : Print the progress of the operation on the screen /v: Verbose output that displays detailed information about the defragmentation process For example, to defragment the C drive and display progress on the screen, you can use th...

How to Get Inverse of a Matrix in Excel

Image
The MINVERSE function in Excel is used to return the inverse matrix of a given matrix. The inverse of a matrix is a matrix that, when multiplied by the original matrix, results in the identity matrix. The syntax for the MINVERSE function is: =MINVERSE(matrix) Where ‘ matrix’ is the range of cells that contain the matrix you want to invert. For example, you have a 4x4 matrix stored in A1 to C3 cells. To find the inverse of the matrix, you can simply use the formula: Note that the matrix argument must be a square matrix (i.e., the number of rows and columns must be equal). If the matrix is not invertible (i.e., its determinant is zero), the MINVERSE function will return the #VALUE! error.  

How to Enable or Disable Extended Ctrl+C Features using CMD

Image
In CMD (Command Prompt), the "break" command is used to enable or disable the extended CTRL+C checking feature. When the extended CTRL+C checking feature is enabled, pressing CTRL+C will cause the command prompt to prompt the user to confirm that they want to terminate the running command. The syntax for the "break" command is: break [on | off]   The "on" option enables the extended CTRL+C checking feature, and the "off" option disables it. By default, the extended CTRL+C checking feature is turned on in Windows. For example, to turn off the extended CTRL+C checking feature, you can use the following command: break off This will disable the extended CTRL+C checking feature, and pressing CTRL+C will immediately terminate the running command without prompting for confirmation. Note that some commands may override the extended CTRL+C checking feature and terminate immediately when CTRL+C is pressed, regardless of whether the feature is e...

How to Get Determinant of a Matrix in Excel

Image
The MDETERM function in Excel returns the matrix determinant of an array. The syntax for the MDETERM function is: MDETERM(array) where array is the array or range containing the matrix. Here is an example of how to use the MDETERM function in Excel. Suppose you have a 4x4 matrix stored in A1 to C3 cells. To find the determinant, you can simply use the formula:  Note that the MDETERM function can only be used with arrays that have the same number of rows and columns, otherwise it will return the #VALUE! error.

How to Change Command Prompt's Background Color

Image
In CMD (Command Prompt), the "color" command is used to change the color of the command prompt window. This can be useful for differentiating between different types of commands or for personalizing the appearance of the window. The syntax for the "color" command is: color [background][foreground] Where " background " and " foreground " are placeholders for the desired color codes, which can be specified as single digits or combination of digits from 0-9 and letters from A-F. The first digit specifies the background color, and the second digit specifies the foreground color. For example, to set the background and foreground color to blue, you can use the following command: color 1b When you run the " color " command without any arguments, it resets the colors to their default values. Note that not all combinations of colors are readable or visible on all screens, so you may need to experiment to find a combination that ...

How to Get Base-10 Logarithm in Excel

Image
The LOG10 function in Excel is used to find the base-10 logarithm of a number. The syntax for the LOG10 function is: LOG10(number) Where number is the positive real number for which you want to find the base-10 logarithm. For example, if you have some numbers in D column of an excel sheet and want to find base-10 logarithms of those numbers, you can simply use the formula: The results are shown in column E. Note that, LOG10 function only works with base-10. For a base other than 10, you cannot use this function.  

How to Clear Command Prompt Screen

Image
In CMD (Command Prompt), the "cls" command is used to clear the screen of any text or commands that have been previously entered. When the "cls" command is executed, the entire screen is cleared and the command prompt is positioned at the top of the window. This makes it easier to read any output from subsequent commands, and provides a clean slate for entering new commands. The syntax for the "cls" command is: cls When this command is entered into the command prompt and executed, the screen is immediately cleared. Any previous text or commands are removed, and the command prompt is ready to accept new commands.   Note that the "cls" command is not specific to CMD and is also available in other command-line interfaces, such as PowerShell and Linux terminal.  

How to Get Logarithm of a Number in Excel

Image
The LOG function in Excel is used to calculate the logarithm of a given number to a specified base. The syntax for the LOG function is as follows: LOG(number, [base]) Where, number : This is the positive real number for which you want to calculate the logarithm. base : This is the base of the logarithm. If this argument is not specified, then the default base of 10 is used. The LOG function returns the logarithm of the given number to the specified base. For example, to calculate the logarithm of numbers stored in D column to the base numbers stored in E, you would use the following formula: Note that, both numbers and base should be numeric values. If any of the numbers are not numeric, the function will return #VALUE! error.  

How to Display or Modify Audit Policies of Windows using CMD

Image
In CMD (Command Prompt), the auditpol command is used to display or modify audit policies on a Windows system. Audit policies determine which events are logged in the Windows Security log when specific activities occur on the system. The syntax for the auditpol command is as follows:  auditpol /set /subcategory:<subcategory> [/success:<enable|disable>] [/failure:<enable|disable>] [/system:<enable|disable>] Where: /set : Specifies that the audit policy should be modified. /subcategory:<subcategory> : Specifies the subcategory of events for which the audit policy should be modified. A list of available subcategories can be obtained by running the auditpol /list /subcategory:* command. /success:<enable|disable> : Specifies whether successful events in the specified subcategory should be audited or not. /failure:<enable|disable> : Specifies whether failed events in the specified subcategory should be audited or not. /system:<enable|disa...