How to calculate Average in Microsoft Excel

There are four AVERAGE functions and each has different uses:

  • AVERAGE: This produces the arithmetic mean (the sum of all numbers divided by the number of values) of a set of data, ignoring anything that isn’t a number.
  • AVERAGEA: This returns the mean of a set of numbers, text, and logical arguments.
  • AVERAGEIF: This calculates the arithmetic mean of a set of numerical data that fulfill a single criterion.
  • AVERAGEIFS: This tells you the arithmetic mean of a set of numerical data that fulfill several criteria.
[mai mult...]

Fix “Cursor Dissapeared” on your Windows PC

If the cursor doesn’t appear on the screen as you move the mouse, it could be due to a faulty mouse not registering its actions properly. So, before proceeding further, ensure your mouse is not defective. A simple way to check is to disconnect the mouse from your PC and connect it to another PC.

If the cursor doesn’t appear on other computers either, it indicates a problem with the mouse itself rather than the operating system. If you have a wired mouse, check that its cable isn’t damaged. If it’s a wireless mouse, try replacing the battery to ensure it hasn’t died. However, if the mouse works fine on other devices but not on yours, proceed with the remaining checks.

[mai mult...]

How to use Relative, Absolute, and Mixed References in Excel

You use a cell reference when you want to capture information that is contained within another cell or range of cells. For example, the following formula references cells A1 and A2, and will add their contents together to produce a result.

=SUM(A1+A2)

You can use the following types of cell references to achieve specific outcomes:

  • By default, references in Excel are relative, which refers to the relative position of the cell. If you are typing a formula in cell A1 that involves cell A2, you are referencing the cell that is one cell below where you are typing. If you were to copy the formula into another cell, the reference would automatically perform the same relative action as in its previous location.
  • You can also use an absolute reference, which does not change if you copy the formula into another cell. If you create a formula that refers to a cell using an absolute reference, that same cell will be referred to wherever the formula is used.
  • Finally, you can use a mixed reference, which is a combination of the two.
    Let’s look into these in more detail.
[mai mult...]

How to install LibreOffice on Ubuntu


Whether you’re an experienced Ubuntu user or a beginner, LibreOffice is an excellent office suite that can significantly enhance your productivity. It provides various useful tools for word processing, presentations, and spreadsheets. This article covers LibreOffice installation on Ubuntu using different methods.

[mai mult...]