Ms Excel

What is a cryptographic hash function?

Example of the Rainbow table plain text SHA-1 checksum 12345 8cb2237d0679ca88db6464eac60da96345513964 password1 e38ad214943daad1d64c102faec29de4afe9da3d I love my dog a25fb3505406c9ac761c8428692fbf5d5ddf1316 Jenny400 7d5eb0173008fe55275d12e9629eef8bdb408c1f Dallas1984 c1ebe6d80f4c7c087ad29d2c0dc3e059fc919da2 A hacker needs to know which cryptographic hash algorithm was used to generate the checksums in order to determine the values. For added protection, some websites that store user passwords perform additional functions …

What is a cryptographic hash function? Read More »

Use Excel’s MEDIAN function to find the average value

Microsoft Excel has several functions that calculate commonly used averages. The MEDIAN function finds the median or average value in a list of numbers. These instructions apply to Excel 2019, 2016, 2013, and 2010, as well as Excel 2019 for Mac, Excel 2016 for Mac, Excel for Mac 2011, Excel for Microsoft 365, and Excel …

Use Excel’s MEDIAN function to find the average value Read More »

Everything about the status bar in Excel and how to use it

That status bar which stretches horizontally across the bottom of the Excel screen, can be customized to display a range of options, most of which give the user information about the current worksheet, worksheet data, and the on/off status of various user keyboard keys , such as sealing caps, scroll lock etc number lock. These …

Everything about the status bar in Excel and how to use it Read More »

Insertion point in Excel and its use with data

In spreadsheets and other programs such as word processors, the insertion point is represented by a flashing vertical line which shows where keyboard or mouse input appears in certain situations. The insertion point is often referred to as cursor. note: These instructions apply to versions of Excel 2019, 2016, 2013, 2010 and Excel for Microsoft …

Insertion point in Excel and its use with data Read More »