آموزش Google Spreadsheets-En

[A M I R]

Formatting Cells

To Applying Number Formatting:


Select the cell or cells you wish to modify. In our example, we

will change the date formatting of cell A2
Locate and select the Number Formatting button

from the Shortcut Toolbar.

A drop-down menu will appear with various number formatting options.


Select the desired formatting. In our example, we

will select a different type of date formatting

The cell will change to the new formatting style.

​

​

 

[A M I R]

[h=2]Formatting Cells

[h=3]Normal Formatting

Normal is the default setting for every cell in a spreadsheet
.
​

Whenver you enter information into a cell, Google Spreadsheets will

choose a formatting style based on the content
.
​

By default, text wil be left-aligned and numbers will be right-aligned.
​

​

 

[A M I R]

[h=2]Formatting Cells

[h=3]Decimals


Select 2 Decimals to round a decimal to the nearest hundredth (18.16).


Select Rounded to round a decimal to the nearest whole number (18).

These two options are used to simplify decimals in our example below.

Click Custom Decimals... to choose specific rounding for decimals.




​

 

[A M I R]

[h=2]Formatting Cells

[h=3]Financial

Select Financial to format numbers for accounting purposes.


Select this option when working with a large amount of financial information.​

​

​

 

[A M I R]

[h=2]Formatting Cells

[h=3]Scientific

Select Scientific to format numbers in scientific notation. This is especially

helpful when working with very large numbers. In our example, the large numbers

followed by many zeros are changed to the shorter, scientific format: 1.40E+22, 1.90E+23, and so on

By default, Google Spreadsheets will apply scientific formatting if a number is too large to display in a cell.
​

​

 

[A M I R]

[h=2]Formatting Cells

[h=3]Currency

Select Currency to add proper puncuation and currency symbols, like the dollar sign ($), to numerical values.



​

​

 

[A M I R]

[h=2]Formatting Cells

[h=3]Percentages

Select Percent to add the Percent sign (%) to numerical values.


Percentages can be formatted in two different ways: as Percent rounded (15%) and as exact percet (15.00%).


In our example below, we have forrmatted the same percentages using these options



​

​

 

[A M I R]

[h=2]Formatting Cells

[h=3]More Currency Formats

Hover the mouse over More Currencies to see more international currency options.



​

​

 

[A M I R]

[h=2]Formatting Cells

[h=3]Time and Date

There are numerous options for formatting time and date in your spreadsheet.

In our example below, we have applied three different formats to the same dates.


​

​

 

[A M I R]

[h=2]Formatting Cells

[h=3]More Date and Time Formats

Hover the mouse over More formats to see more time and date options.
​

​

 

[A M I R]

[h=2]Formatting Cells

[h=3]Plain Text

Select Plain text to remove all formatting from your cell content.
​

​

 

[A M I R]

[h=2]Working with Multiple Sheets

[h=3]Introduction

A Google Spreadsheet can contain one or more sheets. When working with a large amount

of information, you can create multiple sheets to help organize

your spreadsheet and make it easier to find information


In this lesson, you'll learn how to create, rename, move, delete, and duplicate sheets.

​

 

[A M I R]

[h=2]Working with Multiple Sheets

[h=3]Using Multiple Sheets
When you create a new Google Spreadsheet, it has one sheet which is named

Sheet1 by default. In the sheets toolbar located at the bottom of

the window, you will see a tab for each sheet that you have. To organize

your spreadsheet and make it easier to navigate, you can

create, rename, delete, move, and duplicate sheets

Sheet1 in the sheets toolbar

​

 

[A M I R]

[h=2]Working with Multiple Sheets

[h=4]To Create a New Sheet
In our example, the sheets of our service log are organized by

month. We will create a new sheet in the log so data can be entered in the new month


Click the Add Sheet command

in the sheets toolbar.

A new sheet will appear in the sheets toolbar.

Alternatively, you can create an additional sheet by clicking Insert and selecting New sheet from the drop-down menu.

Clicking New sheet
​

 

[A M I R]

[h=2]Working with Multiple Sheets

[h=4]To Rename a Sheet

Click the tab of the sheet you wish to rename. Select Rename... from the menu that appears.

In the dialog box that appears, type the desired name for the sheet. Then, click OK.

The sheet is renamed.

​

 

[A M I R]

[h=2]Working with Multiple Sheets

[h=4]To Switch to a Different Sheet:

Click the desired sheet tab in the sheets toolbar.

The selected sheet will appear.

If you wish to limit collaborators from editing specific sheets of your spreadsheet, you can

protect those sheets by clicking on the desired sheet tab and selecting Protect sheet... from the menu that appears

​

 

[A M I R]

[h=2]Working with Multiple Sheets

[h=4]To Move a Sheet:
Click, hold and drag the tab of the sheet you wish to move. As you move

the tab, a vertical blue bar

will appear to indicate where the tab is going to be placed

Release the mouse to place the tab at the desired location.

After placing the tab

​

 

[A M I R]

[h=2]Working with Multiple Sheets

[h=4]To Duplicate a Sheet:

Click the tab of the sheet that you wish to duplicate. Then select Duplicate from the menu that appears.

A duplicate of the sheet will appear in the sheets toolbar. It will be named as a

copy of the original sheet, such as "Copy of April". If you desire, you can rename the sheet

The duplicated sheet

​

 

[A M I R]

[h=2]Working with Multiple Sheets

[h=4]To Delete a Sheet:
Click the tab of the sheet you wish to delete. Select Delete from the menu that appears.

A warning dialog box appears. Click OK.

The sheet is deleted.

The remaining sheet tabs



​

 

[A M I R]

[h=2]Creating Simple Formulas

[h=3]Introduction

When working with numerical information, Google Spreadsheets can be used

to perform calculations. In this lesson, you'll learn how to create simple

formulas that will add, subtract, multiply, and divide values. You will also

be introduced to the basics of using cell references in formulas

​