جاوا اسکریپت غیر فعال است برای تجربه بهتر، قبل از ادامه، جاوا اسکریپت را در مرورگر خود فعال کنید.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser .
Excel 2010 [h=3]Excel Basics
Common Tasks in Excel Doing More with Excel
[h=2]Getting Started with Excel
[h=3]Introduction
Excel is a
spreadsheet program that allows you to store, organize, and analyze information. In this lesson, you will learn your
way around the Excel 2010 environment, including the new
Backstage view , which replaces the Microsoft Button menu from Excel 2007.
We will show you how to use and modify the
Ribbon and the
Quick Access Toolbar , and how to
create new and
open existing ones. After this lesson, you will be ready to get started on your first workbook.
[h=2]Getting Started with Excel
[h=3]Getting to Know Excel 2010
The
Excel 2010 interface is very similar to Excel 2007. There have been some changes that we will review
later in this lesson, but if you are new to Excel, first take some time to learn how to navigate an Excel workbook.
[h=2]Getting Started with Excel
[h=3]Quick Access Toolbar
The Quick Access Toolbar lets you access common commands no matter which tab you
[h=2]Getting Started with Excel
[h=3]Name Box
The Name box tells you the location or the "name" of a selected cell. In the image below, cell B4 is in the
[h=2]Getting Started with Excel
[h=3]Formula Bar
In the formula bar , you can enter or edit data, a formula, or a function that will appear in a specific
[h=2]Getting Started with Excel
[h=3]Column
A column is a group of cells that runs from the top of the page to the bottom. In Excel, columns
[h=2]Getting Started with Excel
[h=3]Ribbon
The ribbon contains all of the commands you will need in order to do common tasks. It has multiple
[h=2]Getting Started with Excel
[h=3]Row
A row is a group of cells that runs from the left of the page to the right. In Excel, rows are
[h=2]Getting Started with Excel
[h=3]Worksheets
Excel files are called workbooks . Each workbook holds one or more worksheets (also known as "spreadsheets"). Three worksheets appear by default when you open an Excel workbook. You can rename, add and delete worksheets.
[h=2]Getting Started with Excel
[h=3]Horizontal Scroll Bar
You may have more data than you can see on the screen all at once. Click and hold thehorizontal scroll bar and slide it to the left or right depending on what part of the page you want to see.
[h=2]Getting Started with Excel
[h=3]Page View
There are three ways to view a spreadsheet. Click on a page view button to select it.
• Normal view is selected by default, and shows you an unlimited number of cells and columns. It is highlighted in the image below. • Page Layout view divides your spreadsheet into pages. • Page Break view lets you see an overview of your spreadsheet, which is helpful when you are adding page breaks.
[h=2]Getting Started with Excel
[h=3]Zoom Control
Click and drag the slider to use the Zoom control . The number to the left of the slider bar reflects the zoom percentage.
[h=2]Getting Started with Excel Ribbon and the Quick Access Toolbar are where you will find the commands you need to do Backstage view .
[h=2]Getting Started with Excel
[h=3]The Ribbon
The Ribbon contains multiple
tabs , each with several
groups of commands. You can add your own tabs that contain your favorite commands.
Certain programs, such as
Adobe Acrobat Reader , may install additional tabs to the ribbon. These tabs are called
Add-ins .
[h=2]Getting Started with Excel
[h=4]To Customize the Ribbon:
You can customize the ribbon by creating your own
tabs that house your desired commands. Commands
are always housed within a
group , and you can create as many groups as you need to keep your tabs
organized. In addition, you can even add commands to any of the default tabs, as long as you create a custom group within the tab.
Right-click the Ribbon and select
Customize the Ribbon . A
dialog box will appear
.
Click New Tab . A new tab will be created with a new group inside it.
Make sure the new group is selected.
Select a command from the list on the left, then click Add . You can also drag commands directly into a group.
When you are done adding commands, click OK .
If you do not see the command you want, click on the
Choose commands drop-down box and select
All Commands .
[h=2]Getting Started with Excel
[h=4]To Minimize and Maximize the Ribbon:
The Ribbon is designed to be responsive to your current task and easy to use, but if you find it is taking up too much of your screen space, you can
minimize it.
Click the
arrow in the upper-right corner of the Ribbon to minimize it.
To maximize the Ribbon, click the arrow again.
When the Ribbon is minimized, you can make it reappear by clicking on a tab. However, the Ribbon
will disappear again when you are not using it.
[h=2]Getting Started with Excel Quick Access Toolbar is located above the Ribbon, and it lets you access common commands Save , Undo , and Repeat commands. You
[h=2]Getting Started with Excel
[h=4]To Add Commands to the Quick Access Toolbar:
Click the drop-down arrow to the right of the Quick Access Toolbar .
Select the command you wish to add from the drop-down menu. To choose from more commands, select More Commands .
[h=2]Getting Started with Excel Office Button menu from Excel 2007 or the File menu from earlier versions of Excel. However, instead
