Tutorials Support

For using the Google Drive you are required to have a Google Account. Making an account in Google is absolutely free and signing up is very easy and simple. For creating a Google account you are required to enter some information which includes name, brith place and your location. By creating a Google account, your Gmail email address and Google+ profile will automatically be created.

Creating a Google Account:

• For creating a Google account you need to go to www.google.com. Now you need to locate and select Sign in button in the top right corner of the page.
• Now you need to click on Create an account.
• After this a sign-up form will appear. You need to follow the directions and enter the required information.
• Now you are required to enter your phone number. Google will send verification code to your phone that you will use complete sign up process.
• Now you need to enter the verification code which is sent to your phone and then click Verify.
• Now a personal information page will appear. You are required to follow the irections and enter your information which includes your birth date and gender.
• Now review the Google’s Terms of Service and Privacy Policy and then click I agree.
• Now you account has been created.

Accessing Google Drive:

Once you have set up your Google account, you can access Google Drive by going to http://drive.google.com in your web browser.

You can also access Google Drive from any Google page by selecting grid icon near the top right corner and after that clicking Drive.

Google Drive interface

Your Google Drive will be empty at the start but as you begin to upload and create the files you will require to know how to view, manage as well as organize them in the interface.

In MS Excel one of the most powerful features is the ability to calculate numerical information by using formulas. Excel is capable of adding, subtracting, multiplying and dividing operations. In this tutorial we will learn how to use cell references to create simple formulas.

Mathematical operators:

MS Excel uses the standard operators for the formulas asterick (*) for multiplication, forward slash (/) for division, plus sign (+)for addition, minus sign (-) for subtraction and caret (^) for exponents. All of the excel formulas are required to begin with an equals sign (=).

Cell References:

usually numbers are used for creating an Excel formulas like =2+2 or =4*4. But you can also use cell addresses for creating a formula. This is called making a cell reference. Using the cell reference will ensure that your formulas are accurate because you can modify the value of referenced cells without rewriting the formula.

Creating a Formula:

For creating a formula follow these simple steps.

• First of all you need to select the cell that will contain the formula.
• Now type the equals sign (=). Notice how it is shown in both the cell and formula bar.

• Now type the cell address of the ceel you need to reference first in the formula. You will notice that a blue border will appear around the referenced cell.
• Type the mathematical operator you need to use.
• Now type the cell address of the cell you need to reference second in the formula. A red border will appear around the referenced cell.
• Now press Enter on your keyboard and the formula will be calculated and the value will be displayed in the cell.