آموزش Google Spreadsheets-En

[A M I R]

Google Spreadsheets

Spreadsheet Basics



Getting Started with Google Spreadsheets

Modifying Columns, Rows, and Cells

Formatting Cells

Working with Multiple Sheets

---

Common Spreadsheet Tasks



Creating Simple Formulas

Creating Complex Formulas

Types of Cell References

Working with Functions

Sorting and F i l t e r ing Data

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]Introduction

Google Spreadsheets allows you to organize, edit and analyze different types of information

using spreadsheets. In this lesson, you'll learn about the different ways you might use spreadsheets

and how to navigate the Google Spreadsheets interface. You'll also learn the basic ways to work

with cells and cell content, including how to select cells, insert content, copy and paste cells, and more



​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=4]All About Google Spreadsheets
Google Spreadsheets is a web-based spreadsheet application that allows you to store and organize

different types of information, much like Microsoft Excel. While Google Spreadsheets does not

offer all of Excel's advanced features, it's easy to create and edit spreadsheets, ranging from the simple to the complex

.

While you might think that spreadsheets are only used by certain people to process complicated

numbers and data, they can actually be used for a variety of everyday tasks. Whether you're starting

a budget, planning a garden, creating an invoice, or just about anything else you can think of, spreadsheets

are a great way to organize information

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=4]To Create a New Google Spreadsheet:
While viewing your Google Drive, click Create and then select Spreadsheet from the drop-down menu.

The spreadsheet will appear in a new browser tab.

To name your spreadsheet, locate and select Untitled spreadsheet at the top of the page.


The Rename Document dialog box will appear. Type a name for your spreadsheet and then click OK.

Your spreadsheet will be renamed.

Whenever you need to view or edit your spreadsheet, you can access it again from

your Google Drive, where it will be saved automatically

You may notice that there is no save button. This is because Google Docs uses auto-save, which

automatically and immediately saves your files as you edit them

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]The Google Spreadsheets Interface

In order to use and edit spreadsheets, you will need to become familiar with the Google Spreadsheets interface.

​

 

[A M I R]

Getting Started with Google Spreadsheets

Toolbar Menu



You can use the toolbar menu options to edit and modify your spreadsheet in various ways. Click a menu and then select the desired action from the drop-down list.

​

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]Spreadsheet Title

By default, any new spreadsheet is named Untitled Spreadsheet. Click the title to rename the spreadsheet

​

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]Collaboration Options
Click Share to share your spreadsheet and even allow others to edit and collaborate

​

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

​

[h=3]

​

[h=3]Shortcut Toolbar
This toolbar provides convenient shortcut buttons for formatting the data in your spreadsheet, like font size, text alignment, text color, and more

​

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]Formula Bar

You can use the formula bar to enter and edit data, functions and formulas for a specific cell
.
In this example, cell C2 is selected. Note how the data appears in both the cell and the formula bar

​

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]Column
A column is a group of cells that run vertically from top to bottom. Columns are identified by letters. Column C is selected in this example

​

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]Cell

Each rectangle in a spreadsheet is called a cell

A cell is the intersection of a row and a column

Simply click to select a cell. Cell B5 is selected in this example

​

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]Column

A column is a group of cells that run vertically from top to bottom. Columns are identified by letters. Column C is selected in this example.

​

[h=3]Row

A row is a group of cells that run horizontally from side-to-side. Rows are identitied by numbers. Row 10 is selected in this example

​

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]Sheets Toolbar


Every spreadsheet can have multiple sheets. Select the sheet tabs to navigate between sheets or click the Add Sheet + command to add a new sheet

​

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]Cell Basics
Every spreadsheet is made up of thousands of rectangles, which are called cells. A cell

is the intersection of a row and a column. Columns are identified by letters (A, B, C) and

rows are identified by numbers (1, 2, 3

Every cell has its own name, or cell address, based on its column and row. In

this example, the cell we have selected intersects Column C and Row 10, so

the cell address is C10. Note that a cell's column and row headings become

darker when the cell is selected


You can also select multiple cells at the same time. A group of cells

is known as a cell range. Rather than a single cell address, you will

refer to a cell range using the cell address of the first and last cells

in the cell range, separated by a colon. For example, a cell range that

included cells A1, A2, A3, A4 and A5 would be written as A1:A5

Cell range A2:A8

Cell range A2:B8





​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=3]Understanding Cell Content

Any information you enter into a spreadsheet will be stored in a cell. Each cell can

contain several different kinds of content, including text, formatting, formulas, and functions


Text

Cells can contain text, such as letters, numbers, and dates.

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

Formatting attributes


Cells can contain formatting attributes that change the way letters, numbers, and dates

are displayed. For example, percentages can appear as 0.15 or 15%. You can even

change a cell's background color

​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

Formulas and Functions


Cells can contain formulas and functions that calculate cell values. In our example, SUM(B2:B8)

adds the value of each cell in cell range B2:B8 and displays the total in cell C9

Cell formulas
​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=4]To Select Cells:
To input or edit cell content, you'll first need to select the cell.


Click a cell to select it.


A blue box

will appear around the selected cell.

You can also select cells using the arrow keys on your keyboard.


​

 

[A M I R]

[h=2]Getting Started with Google Spreadsheets

[h=4]To Select a Cell Range:
Sometimes you may want to select a larger group of cells, or cell range.


Click, hold and drag the mouse until all the cells you wish to select are highlighted.

Release the mouse to select the desired cell range.

​