Microsoft Office Tutorials and References
In Depth Information
Worksheet basics: a quick tour of Microsoft Excel
Worksheet basics: a quick tour of Microsoft Excel
Before you can completely understand the capabilities of Excel, you need to understand the
components of the program. Let’s begin by working with a basic worksheet.
1
In the Excel program, choose File > Open. Navigate to the Excel02lessons folder and
click on excel0202. This is a simple worksheet of names and addresses.
A worksheet is a type of ledger. It consists of a grid made from columns and rows.
A
B
C D
E
F
A. Rows. B. Ta b s. C. Quick Access Toolbar. D. Ribbon. E. Columns. F. Title bar.
Take a look at the Ribbon at the top of the Excel interface. The Ribbon is an important
element in Excel 2010 because it contains the buttons and controls for accessing Excel
commands. The commands that display on the Ribbon change, depending on which tab
you have clicked.
2
Click the Insert tab. The Ribbon changes to display dif erent commands.
The commands are divided into groups, and the group labels are on the bottom of the
Ribbon. For example, Tables, Illustrations, Charts, Sparklines, Filter, Links, Text, and
Symbols are the groups found on the Insert tab. When you want to insert a chart, for
example, you can use the commands in the Charts group to insert the type of chart that
you want.
3
Click the File tab to display Backstage view.
4
Click the Home tab.
Exploring worksheets
Now, let’s explore the worksheet.
1
Click on the letter A in the upper-left corner of the worksheet. The letters along the top
represent columns. Notice that the column title is Last, indicating the last name. Other
column names are First, Address, City, State, and Zip.
2
Click on the number 2 to the left of column A. The numbers represent the rows of
entries. Notice that clicking the number selects the entire row.
Search JabSto ::




Custom Search