People are still using “123456” in droves as their password for online accounts despite constant warnings about their vulnerability to hacking, fraud, and identity theft.

It marks the fourth year “123456” has sat at the top of the list of the 100 most insecure passwords, according to SplashData.

The numerical phrase took over “password” as the world’s most commonly used online password in 2013 and has remained in the top spot since.

Here’s the full list for 2017’s worst passwords:

123456

Password

12345678

qwerty

12345

123456789

letmein

1234567

football

iloveyou

admin

welcome

monkey

login

abc123

starwars

123123

dragon

passw0rd

maste

hello

freedom

whatever

qazwsx

trustno1

Avoid using these  passwords and similar one for your safety including your name, other family members names and birthdays. Those will be easy for hackers to hack in and use your online identity for theft and crimes.

A computer virus, much like a flu virus, is designed to spread from host to host and has the ability to replicate itself. Similarly, in the same way that viruses cannot reproduce without a host cell, computer viruses cannot reproduce and spread without programming such as a file or document.
In more technical terms, a computer virus is a type of malicious code or program written to alter the way a computer operates and that is designed to spread from one computer to another. A virus operates by inserting or attaching itself to a legitimate program or document that supports macros in order to execute its code. In the process a virus has the potential to cause unexpected or damaging effects, such as harming the system software by corrupting or destroying data.
How does a computer virus attack?

Once a virus has successfully attached to a program, file, or document, the virus will lie dormant until circumstances cause the computer or device to execute its code. In order for a virus to infect your computer, you have to run the infected program, which in turn causes the virus code to be executed. This means that a virus can remain dormant on your computer, without showing major sings or symptoms. However, once the virus infects your computer, the virus can infect other computers on the same network. Stealing passwords or data, logging keystrokes, corrupting files, spamming your email contacts, and even taking over your machine are just some of the devastating and irritating things a virus can do.
While some viruses can be playful in intent and effect, others can have profound and damaging effects, such as erasing data or causing permanent damage to your hard disk, and worst yet, some are even design with financial gains in mind.
How do computer viruses spread?

In today’s constantly connected world you can contract a computer virus in many ways, some more obvious than others. Viruses can be spread through email and text message attachments, Internet file downloads, social media scam links, and even your mobile devices and smartphones can become infected with mobile viruses through shady App downloads. Viruses can hide disguised as attachments of socially shareable content such as funny images, greeting cards, or audio and video files.

To avoid contact with a virus it’s important to exercise caution when surfing the web, downloading files, and opening links or attachments. As a best practice, never download text or email attachments that you’re not expecting, or files from websites you don’t trust.

How to protect against computer viruses?
As you can see, just like a vicious flu virus, a computer virus is something that you want to avoid. The terms virus and malware are often used interchangeably; however, a virus is one of many types of malware, and only one aspect of the overall threat landscape. As a result, traditional antivirus software alone will not fully protect you from all threats.

Instead, look into comprehensive security software like Norton Security. With patented technologies that work together to outsmart online threats, scanning your system for viruses, and running continuous automatic silent updates, Norton Security keeps you protected from existing, new, and even yet-to-be-invented threats. And if a virus slips through on our watch during your subscription period, Norton support experts will do everything they can to help fix problem at no additional cost. That’s the assurance and peace of mind you only get with our Norton Virus Protection Promise. No other free or paid security software service offers this kind of guarantee.

What do computer viruses do?
Through the course of using the Internet and your computer, you may have come in to contact with computer viruses. Many computer viruses are stopped before they can start, but there is still an ever growing concern as to what do computer viruses do and the list of common computer virus symptoms. A computer virus might corrupt or delete data on your computer, use your email program to spread itself to other computers, or even erase everything on your hard disk.

Computer viruses are often spread by attachments in email messages or instant messaging messages. That is why it is essential that you never open email attachments unless you know who it’s from and you are expecting it.

Viruses can be disguised as attachments of funny images, greeting cards, or audio and video files.

Computer viruses also spread through downloads on the Internet. They can be hidden in illicit software or other files or programs you might download.

To help avoid computer viruses, it’s essential that you keep your computer current with the latest updates and antivirus tools, stay informed about recent threats, run your computer as a standard user (not as administrator), and that you follow a few basic rules when you surf the Internet, download files, and open attachments.

Once a virus is on your computer, its type or the method it used to get there is not as important as removing it and preventing further infection.

• Change your password regularly and keep it in a safe place.
• Don’t share your password with anyone.
• Don’t open attachments from anyone you don’t know.
• Log out or sign off from your account when you’ve finished looking at/sending your email.
• Don’t reply to spam or forward chain emails.
• Keep your personal information personal – don’t share bank or credit card information by email.
• Your bank will not discuss your private financial situation by email. If you receive any correspondence that claims to come from your bank, telephone your branch to verify it and discuss the matter over the telephone instead.
• Make sure that you have antivirus software installed and keep it up to date.
• Be skeptical of attachments. Even when you know the person sending you the message, if you are not expecting an attachment, don’t open it without confirming with the sender that it is legitimate.
• Watch out for links to websites included in an email. Sometimes the link that shows in the message is different from the underlying URL coded into the email message. If you click on the link, you will go to a phony site, rather than to a legitimate one. Instead of clicking on a link within your email message, copy the URL and paste it into your web browser. That way, you will know that you are going to the real thing.
• Never transmit financial, account, or any other information you consider private via email. Sending an email message is like sending a postcard: it is easily read by people other than those for whom it was intended. For example, someone forwarding your message to others could inadvertently expose information you intended for the original recipient alone.
• Be suspicious when you receive an email asking you to enter personal information. This is called “phishing.” Con artists try to trick you into providing personal information through email or onto a web page by pretending to be a legitimate business or organization. Don’t click on a URL in an email (see the second item above), and don’t reply to the email. If you are unsure, contact the business or organization by phone.
• Never reply to spam. Unscrupulous spammers will test their lists of email by sending out millions of messages–it doesn’t cost any more to send a million than it does to send one. If you reply, for example, by following the instructions for the “unsubscribe” option, you are just verifying that they have found a good address. Once they know they have a real address, you will be inundated with more spam.
• Don’t panic if you receive an email from someone you either don’t know, or didn’t send a message to, stating that you sent them a virus. There are a number of computer viruses that grab the email addresses from the address book of a computer they infect. Such a virus then begins sending out email messages that appear to come from the email addresses stolen from the infected computer. If this occurs with a computer outside UCSB, as it often does, there’s nothing that can be done about this, because we can’t control those computers. Simply delete the message.
• Handle attachments with care. Email attachments should be detached, then scanned with anti-virus software before they are opened.

1. To access the menu options you can use the ALT key followed by the relevant underlined letter. To access a menu option once the menu is open, press the relevant underlined letter. Alternatively, after pressing the ALT key, use the arrow keys followed by enter to choose alternative menus and menu options.
2. To access the toolbar buttons hit ALT followed by CTRL + TAB. Then use the arrow keys to move from one button to another. Use enter to select.
3. To zoom in and out of a page, use CTRL + PLUS or CTRL + MINUS respectively.
4. To fit to page for easier viewing, use CTRL + 0.
5. To view in presentation mode use CTRL + L. Press ESC to return to normal view.
6. To rotate view (often done by accident, here is how to fix it!)
   Clockwise: CTRL + SHIFT + PLUS
   Anti-clockwise: CTRL + SHIFT + MINUS
7. To find a word press control + F to activate the find box, type the key word(s) and hit return. Hit return to move from one occurrence of the search item to another.

Note:

• Keys that should be pressed at the same time are joined with a plus sign (+). Keys that you should press in sequence are joined by a comma (,). Thus, the keyboard shortcut Alt+H, M+R means press Alt and H together to open the Home tab on the ribbon, and then press letters M and R together to open a new Meeting Request.

Frequently used shortcuts

The following shortcuts are the most frequently used in Outlook 2013 and 2016.

Work in Outlook

Move around in Inbox and between Outlook views

Switch to a different Outlook view (Mail, Calendar, Contacts, and so on)

Search in any Outlook view (Mail, Calendar, etc)

Format text

Print

Add or edit links

Create an item or file

Mail

Frequently used mail shortcuts

Other mail shortcuts

Calendar

Frequently used calendar shortcuts

Other calendar shortcuts

See also under Views: Calendar Day/Week/Month view, and Date Navigator.

Contacts

Electronic Business Cards

Frequently used shortcuts for Electronic Business Cards

Select items in Business Cards view

Move between fields in an open card

To use the following keys, make sure a field in a card is selected. To select a field when a card is selected, click the field.

Move between characters in a field

To use the following keys, make sure a field in a card is selected. To select a field when a card is selected, click the field.

Tasks

Frequently used shortcuts for Tasks

Work with Task items in Timeline view

When an item is selected

When a group is selected

When a unit of time on the time scale for days is selected

Groups

Work with groups

Send/Receive folders and groups

Views in Outlook

Table view

Calendar views

Day view

Week view

Month view

Date Navigator

Providing you’re using Outlook with an Exchange account, you might be able to retract your email. But you need to be quick and you need to hope some factors are on your side. We’ll explore how to recall an email, the requirements that need to be met, along with some alternative approaches.

Please head into the comments section afterwards to share your own stories of email recall and any tips you can share on the topic.

How to Recall a Message in Outlook

It’s very easy to try and recall a message in Outlook. First, navigate to your Sent Items folder and then open the message that you want to recall. From the ribbon, ensure that the Message tab is selected. Then, in the Move group, click Actions (which may have collapsed into an icon, depending on your window size). From the dropdown that appears, select Recall This Message….

A new window will open, which will let you select how you want to handle the recall. You can Delete unread copies of this message to remove the email from the recipient’s inbox entirely. Alternatively, you can Delete unread copies and replace with a new message if you want to send a different email in place of the original.

You can also choose to tick Tell me if recall succeeds or fails for each recipient. This will send you an email that’ll let you know the result of every recall attempt. Once you receive these, you’ll then see a Tracking icon in the ribbon which can be clicked to give a summary of the results.

When complete, click OK to recall the message. This will then send a request to the recipient’s address, asking the email client to delete the original email.

Follow this tutorial to see how it can be done.

Step 1. Have 2 Word Documents (.doc, .docx).

Step2. Goto Review –> Compare ( Select “Compare”, Compare 2 versions of document. )

provide the path to both the documents and press “OK”.

You will show the difference between the documents alongside with the original documents in small panes.The differences will be shown as striked of lines, in the middle pane, making it easy for viewing the difference.

See below Image for example.

Alt + Tab
Switch between open applications in all versions of Windows. Reverse the direction by pressing Alt + Shift + Tab at the same time.
Ctrl + Tab
Switches between program groups, tabs, or document windows in applications that support this feature. Reverse the direction by pressing Ctrl + Shift + Tab at the same time.
Alt + double-click
Display the properties of the object you double-click on in Windows 95 and later. For example, doing this on a file would display its properties.
Alt + Print Screen
Create a screenshot only for the active program window in all versions of Windows. For example, if you opened the calculator and pressed these shortcut keys, only the calculator window would be created as a screenshot. If just the Print Screen key is pressed the whole screen will be made into a screenshot.
Ctrl + Alt + Del
Open the Windows option screen for locking computer, switching user, Task Manager, etc. in later versions of Windows. Pressing Ctrl+Alt+Del multiple times will reboot the computer.
Ctrl + Shift + Esc
Immediately bring up the Windows Task Manager in Windows 2000 and later.
Ctrl + Esc
Open the Windows Start menu in most versions of Windows. In Windows 8 this opens the Start screen and in Windows 3.x this would bring up the Task Manager.
Alt + Esc
Switch between open applications on Taskbar in Windows 95 and later.
Alt + Spacebar
Drops down the window control menu for the currently open Windows program in Windows 95 and later.
Alt + Enter
Opens properties window of selected icon or program in Windows 95 and later.
Shift + Del
Will delete any file or other object without throwing it into the Recycle Bin in Windows 95 and later.
Hold down the Shift key
When putting in an audio or data CD that uses Autoplay, holding down the Shift key will prevent that CD from playing.
Windows function key shortcuts

Below is a listing of keyboard shortcuts that use the keyboard function keys. See our what are F1 through F12 keys page for a full listing of what function keys do with all other programs.
F1
Activates help for current open application. If you’re at the Windows Desktop, this will activate the help for Windows.
F2
Renames a highlighted icon, file, or folder in all versions of Windows.
F3
Starts find or search when at the Windows Desktop in all versions of Windows.
F4
In Windows 95 and later, this opens the drive selection or address bar when browsing files in Windows Explorer.
Pressing Alt + F4 closes the current open program window without a prompt in all versions of Windows.
Pressing Ctrl + F4 closes the open window within the current active window in Microsoft Windows. This only works in programs that support multiple windows or tabs in the same program window.
F6
While in Windows Explorer, this will move the cursor to different Windows Explorer pane or in Windows 7 browse available drives.
F8
Pressing F8 over and over as the computer is booting will start the computer in Safe Mode.
F10
Activates the File menu bar in all versions of Windows.
Simulates a right-click on selected item. This is useful if right-click is difficult or impossible using the mouse.
Windows keyboard key shortcuts

Below is a listing of Windows keys that can be used on computers running a Microsoft Windows 95 or later and using a keyboard with a Windows key. In the below list of shortcuts, the Windows key is represented by “WINKEY.” Because not all these shortcuts will work in every version of Windows, we’ve mentioned which versions of Windows support each shortcut key combination.
All versions of Windows
Windows XP only
Windows 7 and 8 only
Windows 8 only
All versions of Windows
WINKEY
Pressing the Windows key alone opens or hides the Windows Start menu. In Windows 8, this opens or hides the Start screen.
WINKEY + F1
Open the Microsoft Windows help and support center.
WINKEY + Pause / Break key
Open the System Properties window.
WINKEY + D
Opens the Desktop to the top of all other windows.
WINKEY + E
Open Microsoft Windows Explorer.
WINKEY + F
Display the Windows Search or Find feature.
WINKEY + Ctrl + F
Display the search for computers window.
WINKEY + L
Lock the computer and switch users if needed (Windows XP and above only).
WINKEY + M
Minimizes all windows.
WINKEY + Shift + M
Undo the minimize done by WINKEY + M and WINKEY + D.
WINKEY + R
Open the run window.
WINKEY + U
Open Utility Manager or the Ease of Access Center.
Windows XP only
WINKEY + Tab
Cycle through open programs through the Taskbar.
Windows 7 and 8 only
WINKEY + 1-0
Pressing the Windows key and any of the top row number keys from 1 to 0 opens the program corresponding to the number of icon on the Taskbar. For example, if the first icon on the Taskbar was Internet Explorer, pressing WINKEY + 1 would open that program or switch to it if already open.
WINKEY + (Plus (+) or Minus (-))
Open Windows Magnifier and zoom in with the plus symbol (+) and zoom out with the minus symbol (-).
Press the WINKEY + ESC to close the Magnifier
WINKEY + Home
Minimize all windows except the active window.
WINKEY + P
Change between the monitor and projection display types or how second screen displays computer screen.
WINKEY + T
Set the focus on the Taskbar icons
WINKEY + Left arrow
Shrinks the window to 1/2 screen on the left side for side by side viewing.
WINKEY + Right arrow
Shrinks the window to 1/2 screen on the right side for side by side viewing.
WINKEY + Up arrow
When in the side by side viewing mode, this shortcut takes the screen back to full size.
WINKEY + Down arrow
Minimizes the screen. Also, when in the side by side viewing mode, this shortcut takes the screen back to a minimized size.
Windows 8 only
WINKEY + ,
Peek at the Windows Desktop.
WINKEY + .
Snap a Windows App to the sides of the screen. Pressing it multiple times will switch between the right and left-hand side of the screen or unsnap the app.
WINKEY + Enter
Open Windows Narrator
WINKEY + C
Open the Charms.
WINKEY + G
Cycle through Desktop gadgets.
WINKEY + H
Open Share in Charms.
WINKEY + I
Open the Settings in Charms.
WINKEY + J
Switch between snapped apps.
WINKEY + K
Open Devices in Charms.
WINKEY + O
Lock the screen orientation.
WINKEY + X
Open the power user menu, which gives you access to many of the features most power users would want to use such as Device Manager, Control Panel, Event Viewer, Command Prompt, and much more.

All spreadsheet formulas begin with and equal sign (=) symbol.
After the equal symbol either a cell or formula function is entered. The function tells the spreadsheet the type of formula.
If a math function is being performed the math formula is surrounded in parentheses.
Using the colon (:) allows you to get a range of cells for a formula. For example, A1:A10 is cells A1 through A10.
Entering a spreadsheet formula

Below is an animated visual example of how an excel formula can be inserted into a spreadsheet. In our first formula entered into the cell “D1,” we manually enter a =sum formula to add 1+2 (in cells A1 and B2) to get the total of “3.” With the next example, we use the mouse to highlight cells A2 to D2 and then instead of typing the formula use the formula button in Excel to automatically create the formula. Next, we show how you can manually enter a formula and then with the help of a mouse get the cell values (you can also highlight multiple cells to create a range). Finally, we manually enter a times ( * ) formula using sum function to find the value of 5 * 100.

Formula examples

Note: The functions listed below may not be the same in all languages of Microsoft Excel. All these examples are done in the English version of Microsoft Excel.
Tip: All of the examples below are listed in alphabetical order, if you want to start with the most common formula, we suggest starting with the =SUM formula.
=
AVERAGE
COUNT
COUNTA
COUNTIF
IF
INDIRECT
MEDIAN
MIN AND MAX
PRODUCT
RAND
RANDBETWEEN
SUM
SUMIF
TODAY
TREND
VLOOKUP
=

=

= will create a cell equal to another. For example, if you were to put =A1 in B1 what ever was in A1 would automatically be put in B1. You could also create a formula that would make one cell equal to more than one value. For example, if you have a first name in cell A1 and a last name in cell B1, you could put in cell A2 =A1&” “&B1 which would put cell A1 in with B1 with a space between. You can also use a concatenate formula to combine cell values.
AVERAGE

=AVERAGE(X:X)

Display the average amount between cells. For example, if you wanted to get the average for cells A1 to A30, you would type: =AVERAGE(A1:A30).

COUNT

=COUNT(X:X)

Count the number of cells in a range that contain only numbers. For example, you could find how many cells between A1 and A15 contain a numeric value by using the =COUNT(A1:A15). If cell A1 and A5 only contained numbers the value of the cell that contains this function would be equal to “2.”

COUNTA

=COUNTA(X:X)

Count the number of cells in a range that contain text and are not empty. For example, you could count the number of cells containing text in cells A1 through A20 by using the =COUNTA(A1:A20). If seven cells were empty the number “13” would be returned.

COUNTIF

=COUNTIF(X:X,”*”)

Count the cells that have a certain value. For example, if you have =COUNTIF(A1:A10,”TEST”) in cell A11, then any cell between A1 through A10 that has the word test will be counted as 1. So if you have 5 cells in that range that contain the word test, A11 would say 5.

IF

=IF(*)

The syntax of the IF statement are =IF(CELL=”VALUE” ,”PRINT OR DO THIS”,”ELSE PRINT OR DO THIS”). So a good example of the syntax would be =IF(A1=””,”BLANK”,”NOT BLANK”), this would make any cell besides cell A1 say “BLANK” if a1 had nothing within it, and “NOT BLANK” if any information was within it. The if statement can, of course, become a lot more complicated but can be reduced if following the above structure.

INDIRECT

=INDIRECT(“A”&”2”)

Returns a reference specified by a text string. In the above example, the formula would return the value of the cell contained in A2.
=INDIRECT(“A”&RANDBETWEEN(1,10))

Returns the value of a random cell between A1 and A2 using the indirect and randbetween (explained below) functions.

MEDIAN

=MEDIAN(A1:A7)

MIN AND MAX

Find the median of the values of cells A1 through A7. For example, four is the median for 1, 2, 3, 4, 5, 6, 7.
=MIN/MAX(X:X)

Min and Max represent the minimum or maximum amount in the cells. For example, if you wanted to get the minimum value between cells A1 and A30 you would put =MIN(A1:A30) or if you wanted to get the Maximum about =MAX(A1:A30).

PRODUCT

=PRODUCT(X:X)

Multiples multiple cells together. For example =Product(A1:A30) would multiple all cells together, so A1 * A2 * A3, etc.

RAND

=RAND()

Generates a random number greater than zero but less than one, For example, “0.681359187” could be a randomly generated number placed into the cell of the formula.

RANDBETWEEN

=RANDBETWEEN(1,100)

Generate a random number between two values. In the above example, the formula would create a random whole number between 1 and 100.

SUM

=SUM(X:X)

The most commonly used function to add, subtract, multiple, or divide values in cells. Below are some examples.
=SUM(A1+A2)

Add the cells A1 and A2.
=SUM(A1:A5)

Add cells A1 through A5.
=SUM(A1,A2,A5)

Adds cells A1, A2, and A5.
=SUM(A2-A1)

Subtract cell A1 from A2.
=SUM(A1*A2)

Multiply cells A1 and A2.
=SUM(A1/A2)

Divide cell A1 by A2.
SUMIF

=SUMIF(X:X,”*”X:X)

Perform the SUM function only if there is a specified value in the first selected cells. An example of this would be =SUMIF(A1:A6,”TEST”,B1:B6) which only adds the values B1:B6 if the word “test” was put somewhere in between A1:A6. So if you put TEST (not case sensitive) in A1, but had numbers in B1 through B6, it would only add the value in B1 because TEST is in A1.
See our SUMIF definition for additional information.

TODAY

=TODAY()

Would print out the current date in the cell entered. This value will change to reflect the current date each time you open your spreadsheet. If you want to enter a date that doesn’t change hold down CTRL and ; to enter the date.

TREND

=TREND(X:X)

To find the common value of cell. For example, if cells A1 through A6 had 2,4,6,8,10,12 and you entered formula =TREND(A1:A6) in a different cell, you would get the value of 2 because each number is going up by 2.

VLOOKUP

=VLOOKUP(X,X:X,X,X)

The lookup, hlookup, or vlookup formula allows you to search and find related values for returned results. See our lookup definition for a complete definition and full details on this formula.