Information You Should Know About Your Computer so You Don't Have to Pay Expensive Repair Fees

Information You Should Know About Your Computer so You Don’t Have to Pay Expensive Repair Fees

Owning a computer is fantastic. It allows you to work remotely from the comfort of your own home, all while surfing the web and communicating with your friends from around the world. Computers simply make your life a whole lot easier and so there is no wonder why almost every household around the world has a desktop device of some sort.

Though computers are amazing, they are annoyingly drawn to breaking. Sometimes you boot up your computer and for no reason whatsoever, it has broken since your last use of it. Beyond the point of turning it on and off again and hoping for the best, most of us are not equipped to deal with our computers randomly breaking.

For this reason, many of us depend on seeking the help of trained professionals to fix our devices. Though these professionals often do a fantastic job, there is no denying that they don’t overcharge quite a lot for their work. Sometimes the costs are so high that they almost exceed the cost of purchasing your computer to start with, so it is better to just replace the item.

If you go to some really unreliable and even rude workers, they may depend on your lack of knowledge to scam you. There have been many instances of people needing repairs that take only minutes to complete, but they still end up walking out with a large bill.

Something that you can do to overcome all of these annoying care costs is get to know your computer. Some of the repairs that you pay for can be easily fixed at home or prevented entirely and here is how.

Virus Protection

One of the main reasons that people take their computers in for repair is because their computer has become overwhelmed with malware and viruses. If you are someone that is a bit of a novice when it comes to computers, then you may not have realised how easy it is for your computer to become infected by a nasty virus.

The best thing that you can do is purchase a quality anti-virus and firewall protection, to ensure the safety of your computer. There are hundreds of different antivirus software providers out there and even if you are someone that is on a small budget, you are bound to find a perfect provider out there for you. If you are unsure of where to look for an anti-virus provider, we recommend that you take a look at Unslider, as Unslider has plenty of anti-virus protection options for you.

Something that we do recommend is that you avoid free anti-virus software, as these tend not to work as well as paid services. Even if you do not like the idea of paying a fee, imagine how much you will need to pay in repairs if your computer does end up infected.

Memory(RAM)

As a computer gets older, you may start to notice that its performance starts to slow and it becomes much less reliable. A lot of people tend to write this off as the computer just naturally coming to the end of its life, but this is not the case.

When you have a computer for a long time, you usually download a lot of content and a lot of software. Usually, this starts to slow your computer down and can lead to things taking a while to load or not loading up at all. All you need is to sweep your computer and delete a lot of the unnecessary data that you have collected and your computer will be running like new again.

Read More

Paste Special I

In a series of short tips, we introduce the Paste Special feature.

A quick and easy way to multiply an array of numbers by a constant without using a formula…

In the example below, we wish to multiply B5:B20 by 10. Temporarily enter 10 into an empty cell. Select it and then Cut or Copy

Select the target range, then click on Edit – Paste Special . In the Paste Special dialog, unselect Paste All and Formats. Also select Multiply. Now click OK …

We are done! The modified cell range.

Read More

Paste Special II – Removing formulae

The paste special feature is useful for preserving the values in a spreadsheet – but removing the formulae that generated those values. This may be required to preserve proprietary equations.

To remove the formulae for a range of cells, select and copy the desired range. Do not unselect the range. Now click on Edit – Paste Special – see below.

Make sure the Formulas box is unchecked. After you click OK, the formula is removed but the value is preserved.

Read More

Webquery : Importing HTML tables

With the help of the Web Page Query OpenOffice.org Calc import filter, you can insert tables from HTML documents in a OpenOffice.org Calc spreadsheet.

Let us step through the relatively straightforward process of importing data from tables in a HTML document.

The data for this example was obtained from an excellent website with tons of population data from all over the world : citypopulation.de

Here is what the source HTML file looks like : swiss.html

For this example, we will be importing awebpage from the local disk.

The External Data dialog is activated by Insert-External Data.

Once we fill in the path to the local copy of the HTML file and the table inside this file we wish to import – we hit OK and we are done – it is that easy.

Read More

Basic functions : SUMIF

This short tutorial illustrates the two basic ways that SUMIF can be used in a spreadsheet.

The SUMIF function takes two or three arguments.

For the two argument version, the condition is applied to each cell in the range being SUMmed. In the example below, C9 is the sum of all values in C3:C8 that are greater than 5.

In the three argument version, the condition is applied to a separate range of cells. This range can be numerical of textual. In the example below, the values corresponding to Tom are summed in C10

Read More

Freezing row & column headers

For large spreadsheets that do not fit completely in the window, it is useful to be able to freeze the row and/or column headers to better view the data.

Consider the example below, where we have 12 columns and a large number of rows. By selecting the cell below and to the right of A1 and selecting Window – Freeze , you will now be able to scroll down or to the right while keeping the top row and left column frozen in place.

Note that once you close a sheet, the above setting disappears and you will need to refreeze your window when you reopen the sheet.

Read More

Basic functions : SUMIF

This short tutorial illustrates the two basic ways that SUMIF can be used in a spreadsheet.

The SUMIF function takes two or three arguments.

For the two argument version, the condition is applied to each cell in the range being SUMmed. In the example below, C9 is the sum of all values in C3:C8 that are greater than 5.

In the three argument version, the condition is applied to a separate range of cells. This range can be numerical of textual. In the example below, the values corresponding to Tom are summed in C10

Read More

Basic Functions: INDEX, MATCH

We have already seen a table lookup example using the OFFSET function.

Here, we perform a similar operation using INDEX and MATCH

The example below show how well INDEX and MATCH can work together.

MATCH will return the position of a particular value in an array, while INDEX returns the value of a particular position within an array. We see multiple examples of these functions in operation below.

PriceMatrix is C4:E6 Material is C3:E3 Item is B4:B6
Using these names in the formulas below makes for easier readability nad maintenance. For this reason, it is always good practice to take advantage of the ability to name arrays that will be used within formulas.

Read More

Paste Special III: Merging rows

It has been decided to merge the Mungits and Wingdings product lines. We will use Paste Special to merge the sales totals in the spreadsheet below.

Step 1: Select C6:F6 and Edit – Copy

Step 2: Select C5:F5 and Edit – Paste Special

The Paste Special dialog opens. In this situation, we apply the ADD operator to the paste operation which has the effect of adding the pasted data to the existing contents of the selected cells.

Having merged the data, we can safely delete the Wingdings row in the table.

Read More
  • 1
  • 2