SlideShare a Scribd company logo
MS Excel 2010 User Interface
The Quick Access Toolbar
At the very top left hand side of the screen is the Quick Access toolbar. The Quick
Access toolbar gives you with access to commands you frequently use. By default,
Save, Undo, and Redo appear on the Quick Access toolbar. You can use Save to save
your file, Undo to roll back an action you have taken, and Redo to reapply an action
you have rolled back.
The Title Bar
Next to the Quick Access toolbar is the Title bar. On the Title bar, Microsoft Excel
displays the name of the workbook you are currently using. At the top of the
Excel window, you should see "Microsoft Excel - Book1" or a similar name.
The Ribbon
Tabs
Buttons
Font Group Dialog Box Launcher
You use commands to tell Microsoft Excel what to do. In Microsoft Excel 2010, you use
the Ribbon to issue commands. The Ribbon is located near the top of the Excel
window, below the Quick Access toolbar. At the top of the Ribbon are several tabs;
clicking a tab displays several related command groups. Within each group are related
command buttons. You click buttons to issue commands or to access menus and
dialog boxes. You may also find a dialog box launcher in the bottom-right corner of a
group. When you click the dialog box launcher, a dialog box makes additional
commands available.
Worksheets
Microsoft Excel consists of worksheets.
Each worksheet contains columns and
rows. The columns are lettered A to Z and
then continuing with AA, AB, AC and so
on; the rows are numbered 1 to
1,048,576. The number of columns and
rows you can have in a worksheet is
limited by your computer memory and
your system resources.
The combination of a column coordinate and a row coordinate make up a cell address.
For example, the cell located in the upper-left corner of the worksheet is cell A1,
meaning column A, row 1. Cell E10 is located under column E on row 10. You enter
your data into the cells on the worksheet.
The Formula Bar
Formula Bar
If the Formula bar is turned on, the cell address of the cell you are in displays in the
Name box which is located on the left side of the Formula bar. Cell entries display on
the right side of the Formula bar. If you do not see the Formula bar in your window,
perform the following steps:
1. Choose the View tab.
2. Click Formula Bar in the Show/Hide group. The Formula bar appears.
Note: The current cell address displays on the left side of the Formula bar.
The Status Bar
The Status bar appears at the very
bottom of the Excel window and
provides such information as the
sum, average, minimum, and
maximum value of selected numbers.
You can change what displays on the
Status bar by right-clicking on the
Status bar and selecting the options
you want from the Customize Status
Bar menu. You click a menu item to
select it. You click it again to deselect
it. A check mark next to an item
means the item is selected.
Move around a Worksheet
By using the arrow keys, you can move around your worksheet. You can use the down
arrow key to move downward one cell at a time. You can use the up arrow key to
move upward one cell at a time. You can use the Tab key to move across the page to
the right, one cell at a time. You can hold down the Shift key and then press the Tab
key to move to the left, one cell at a time. You can use the right and left arrow keys to
move right or left one cell at a time. The Page Up and Page Down keys move up and
down one page at a time. If you hold down the Ctrl key and then press the Home key,
you move to the beginning of the worksheet.
The Name Box
You can also use the Name box to go to a specific cell.
Just type the cell you want to go to in the Name box
and then press Enter.
1. Type B10 in the Name box.
2. Press Enter. Excel moves to cell B10.
Ad

More Related Content

What's hot (20)

Chapter 5 microsoft excel 2010
Chapter 5 microsoft excel 2010Chapter 5 microsoft excel 2010
Chapter 5 microsoft excel 2010
home
 
MS Excel Basics
 MS Excel Basics MS Excel Basics
MS Excel Basics
Muhammad Yasir Bhutta
 
Introduction to Excel
Introduction to ExcelIntroduction to Excel
Introduction to Excel
Najma Alam
 
Microsoft 2007 Basics
Microsoft 2007 BasicsMicrosoft 2007 Basics
Microsoft 2007 Basics
Julie Van Noy
 
Rows and Columns
Rows and ColumnsRows and Columns
Rows and Columns
coachhahn
 
MS Excel 2nd
MS Excel 2ndMS Excel 2nd
MS Excel 2nd
Adrian Apolinar Bulacan
 
Ms Excel Tutorials
Ms Excel TutorialsMs Excel Tutorials
Ms Excel Tutorials
LUZ PINGOL
 
TID Chapter 4 Introduction To Spreadsheet(Excel)
TID Chapter 4 Introduction To Spreadsheet(Excel)TID Chapter 4 Introduction To Spreadsheet(Excel)
TID Chapter 4 Introduction To Spreadsheet(Excel)
WanBK Leo
 
Introduction of ms excel
Introduction of ms excelIntroduction of ms excel
Introduction of ms excel
Muhammad Zeeshan Baloch
 
Excel Tutorial
Excel TutorialExcel Tutorial
Excel Tutorial
Jayson Patalinghug
 
Microsoft Excel- basics
Microsoft Excel-  basicsMicrosoft Excel-  basics
Microsoft Excel- basics
jeshin jose
 
Sample Training Ppt Excel Basics
Sample Training Ppt Excel BasicsSample Training Ppt Excel Basics
Sample Training Ppt Excel Basics
AudreyMc
 
Microsoft excel
Microsoft excelMicrosoft excel
Microsoft excel
GC University Faisalabad
 
Uses of Excel
Uses of ExcelUses of Excel
Uses of Excel
jarleewil
 
MS Excel Learning for PPC Google AdWords Training Course
MS Excel Learning for PPC Google AdWords Training CourseMS Excel Learning for PPC Google AdWords Training Course
MS Excel Learning for PPC Google AdWords Training Course
Ranjan Jena
 
Excel ppt
Excel pptExcel ppt
Excel ppt
ReachLocal Services India
 
Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table
Alomgir Hossain
 
A practical tutorial to excel
A practical tutorial to excelA practical tutorial to excel
A practical tutorial to excel
Munna India
 
ms excel presentation...
ms excel presentation...ms excel presentation...
ms excel presentation...
alok1994
 
Excel ppt
Excel pptExcel ppt
Excel ppt
nhumar
 
Chapter 5 microsoft excel 2010
Chapter 5 microsoft excel 2010Chapter 5 microsoft excel 2010
Chapter 5 microsoft excel 2010
home
 
Introduction to Excel
Introduction to ExcelIntroduction to Excel
Introduction to Excel
Najma Alam
 
Microsoft 2007 Basics
Microsoft 2007 BasicsMicrosoft 2007 Basics
Microsoft 2007 Basics
Julie Van Noy
 
Rows and Columns
Rows and ColumnsRows and Columns
Rows and Columns
coachhahn
 
Ms Excel Tutorials
Ms Excel TutorialsMs Excel Tutorials
Ms Excel Tutorials
LUZ PINGOL
 
TID Chapter 4 Introduction To Spreadsheet(Excel)
TID Chapter 4 Introduction To Spreadsheet(Excel)TID Chapter 4 Introduction To Spreadsheet(Excel)
TID Chapter 4 Introduction To Spreadsheet(Excel)
WanBK Leo
 
Microsoft Excel- basics
Microsoft Excel-  basicsMicrosoft Excel-  basics
Microsoft Excel- basics
jeshin jose
 
Sample Training Ppt Excel Basics
Sample Training Ppt Excel BasicsSample Training Ppt Excel Basics
Sample Training Ppt Excel Basics
AudreyMc
 
Uses of Excel
Uses of ExcelUses of Excel
Uses of Excel
jarleewil
 
MS Excel Learning for PPC Google AdWords Training Course
MS Excel Learning for PPC Google AdWords Training CourseMS Excel Learning for PPC Google AdWords Training Course
MS Excel Learning for PPC Google AdWords Training Course
Ranjan Jena
 
Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table Ms excel basic about Data, graph and pivot table
Ms excel basic about Data, graph and pivot table
Alomgir Hossain
 
A practical tutorial to excel
A practical tutorial to excelA practical tutorial to excel
A practical tutorial to excel
Munna India
 
ms excel presentation...
ms excel presentation...ms excel presentation...
ms excel presentation...
alok1994
 
Excel ppt
Excel pptExcel ppt
Excel ppt
nhumar
 

Viewers also liked (12)

MS Excel 2010 tutorial 3
MS Excel 2010 tutorial 3MS Excel 2010 tutorial 3
MS Excel 2010 tutorial 3
Khalfan Alshuaili
 
Uses & applications of microsoft excel in vph research
Uses & applications of microsoft excel in vph researchUses & applications of microsoft excel in vph research
Uses & applications of microsoft excel in vph research
Dr Alok Bharti
 
STARTING MICROSOFT EXCEL 2010
STARTING MICROSOFT EXCEL 2010STARTING MICROSOFT EXCEL 2010
STARTING MICROSOFT EXCEL 2010
Estrelle M.A.
 
Microsoft Excel Basics
Microsoft Excel BasicsMicrosoft Excel Basics
Microsoft Excel Basics
Jennifer Belmonte-Mejia
 
Excel Macro Magic
Excel Macro MagicExcel Macro Magic
Excel Macro Magic
Elaine Giles
 
Excel 2010 Unit A PPT
Excel 2010 Unit A PPTExcel 2010 Unit A PPT
Excel 2010 Unit A PPT
okmomwalking
 
A Quick Simple MS Excel Macro
A Quick Simple MS Excel MacroA Quick Simple MS Excel Macro
A Quick Simple MS Excel Macro
Pranav Ghode
 
An Interactive Dashboard - Part 2
An Interactive Dashboard - Part 2An Interactive Dashboard - Part 2
An Interactive Dashboard - Part 2
Pranav Ghode
 
Teaching Excel
Teaching ExcelTeaching Excel
Teaching Excel
sam ran
 
Ms excel 2007
Ms excel 2007Ms excel 2007
Ms excel 2007
rgaotbgal261415
 
Euclid’ s geometry
Euclid’ s geometryEuclid’ s geometry
Euclid’ s geometry
pawa9pawa
 
FEATURES OF MICROSOFT EXCEL
FEATURES OF MICROSOFT EXCELFEATURES OF MICROSOFT EXCEL
FEATURES OF MICROSOFT EXCEL
pawa9pawa
 
Uses & applications of microsoft excel in vph research
Uses & applications of microsoft excel in vph researchUses & applications of microsoft excel in vph research
Uses & applications of microsoft excel in vph research
Dr Alok Bharti
 
STARTING MICROSOFT EXCEL 2010
STARTING MICROSOFT EXCEL 2010STARTING MICROSOFT EXCEL 2010
STARTING MICROSOFT EXCEL 2010
Estrelle M.A.
 
Excel 2010 Unit A PPT
Excel 2010 Unit A PPTExcel 2010 Unit A PPT
Excel 2010 Unit A PPT
okmomwalking
 
A Quick Simple MS Excel Macro
A Quick Simple MS Excel MacroA Quick Simple MS Excel Macro
A Quick Simple MS Excel Macro
Pranav Ghode
 
An Interactive Dashboard - Part 2
An Interactive Dashboard - Part 2An Interactive Dashboard - Part 2
An Interactive Dashboard - Part 2
Pranav Ghode
 
Teaching Excel
Teaching ExcelTeaching Excel
Teaching Excel
sam ran
 
Euclid’ s geometry
Euclid’ s geometryEuclid’ s geometry
Euclid’ s geometry
pawa9pawa
 
FEATURES OF MICROSOFT EXCEL
FEATURES OF MICROSOFT EXCELFEATURES OF MICROSOFT EXCEL
FEATURES OF MICROSOFT EXCEL
pawa9pawa
 
Ad

Similar to MS Excel 2010 tutorial 2 (20)

Word excel
Word excelWord excel
Word excel
zgpc29
 
Word excel
Word excelWord excel
Word excel
jjsn04
 
Introduction to microsoft excel 2007
Introduction to microsoft excel 2007Introduction to microsoft excel 2007
Introduction to microsoft excel 2007
Abdul-rahaman Bin Abubakar Suleman
 
introductiontomicrosoftexcel2007-131031090350-phpapp01.pdf
introductiontomicrosoftexcel2007-131031090350-phpapp01.pdfintroductiontomicrosoftexcel2007-131031090350-phpapp01.pdf
introductiontomicrosoftexcel2007-131031090350-phpapp01.pdf
Nitish Nagar
 
Learn excel
Learn excelLearn excel
Learn excel
Rajeev Kumar
 
Lesson 1 introduction to spreadsheet
Lesson 1 introduction to spreadsheet Lesson 1 introduction to spreadsheet
Lesson 1 introduction to spreadsheet
afrimkofielias
 
Getting started with_microsoft_excel
Getting started with_microsoft_excelGetting started with_microsoft_excel
Getting started with_microsoft_excel
Pratiksha Mhatre
 
Introduction to Microsoft Excel for beginners
Introduction to Microsoft Excel for beginnersIntroduction to Microsoft Excel for beginners
Introduction to Microsoft Excel for beginners
Blogger Mumma
 
Excel for Dummies
Excel for DummiesExcel for Dummies
Excel for Dummies
eduCBA
 
Visual basic programming session 3
Visual basic programming session 3Visual basic programming session 3
Visual basic programming session 3
Russel Corraya
 
Ms excel
Ms excelMs excel
Ms excel
Chirag Pahlajani
 
Excel for beginners class 1
Excel for beginners class 1Excel for beginners class 1
Excel for beginners class 1
Nicholas Charles
 
How to use a spreadsheet
How to use a spreadsheetHow to use a spreadsheet
How to use a spreadsheet
Swarnima Tiwari
 
Excel 101
Excel 101 Excel 101
Excel 101
Seth Porter, MA, MLIS
 
Presentation-Ms Excel.pptx
Presentation-Ms Excel.pptxPresentation-Ms Excel.pptx
Presentation-Ms Excel.pptx
J and J's classroom / My Little J&J's classroom
 
ppt-2-for-DATA-MANAGEMENT.pdf
ppt-2-for-DATA-MANAGEMENT.pdfppt-2-for-DATA-MANAGEMENT.pdf
ppt-2-for-DATA-MANAGEMENT.pdf
JaylynMacababbad
 
Excel training basic
Excel training   basicExcel training   basic
Excel training basic
TimesRide
 
Excel for beginners class 1
Excel for beginners class 1Excel for beginners class 1
Excel for beginners class 1
Carlstadt Public Library
 
Microsoft® office excel
Microsoft® office excelMicrosoft® office excel
Microsoft® office excel
Small Business Solutions Enterprises, Inc
 
Training On Microsoft Excel
Training On Microsoft ExcelTraining On Microsoft Excel
Training On Microsoft Excel
TimesRide
 
Ad

More from Khalfan Alshuaili (20)

MS Word 2010 tutorial 6
MS Word 2010 tutorial 6MS Word 2010 tutorial 6
MS Word 2010 tutorial 6
Khalfan Alshuaili
 
MS Excel 2010 tutorial 1
MS Excel 2010 tutorial 1MS Excel 2010 tutorial 1
MS Excel 2010 tutorial 1
Khalfan Alshuaili
 
MS Word 2010 tutorial 5
MS Word 2010 tutorial 5MS Word 2010 tutorial 5
MS Word 2010 tutorial 5
Khalfan Alshuaili
 
MS Word 2010 tutorial 4
MS Word 2010 tutorial 4MS Word 2010 tutorial 4
MS Word 2010 tutorial 4
Khalfan Alshuaili
 
MS Word 2010 tutorial 3
MS Word 2010 tutorial 3MS Word 2010 tutorial 3
MS Word 2010 tutorial 3
Khalfan Alshuaili
 
MS Word 2010 tutorial 2
MS Word 2010 tutorial 2MS Word 2010 tutorial 2
MS Word 2010 tutorial 2
Khalfan Alshuaili
 
MS Word 2010 tutorial 1
MS Word 2010 tutorial 1MS Word 2010 tutorial 1
MS Word 2010 tutorial 1
Khalfan Alshuaili
 
MS PowerPoint 2010 tutorial 6
MS PowerPoint 2010 tutorial 6MS PowerPoint 2010 tutorial 6
MS PowerPoint 2010 tutorial 6
Khalfan Alshuaili
 
MS PowerPoint 2010 tutorial 5
MS PowerPoint 2010 tutorial 5MS PowerPoint 2010 tutorial 5
MS PowerPoint 2010 tutorial 5
Khalfan Alshuaili
 
MS PowerPoint 2010 tutorial 4
MS PowerPoint 2010 tutorial 4MS PowerPoint 2010 tutorial 4
MS PowerPoint 2010 tutorial 4
Khalfan Alshuaili
 
MS PowerPoint 2010 tutorial 3
MS PowerPoint 2010 tutorial 3MS PowerPoint 2010 tutorial 3
MS PowerPoint 2010 tutorial 3
Khalfan Alshuaili
 
MS PowerPoint 2010 tutorial 2
MS PowerPoint 2010 tutorial 2MS PowerPoint 2010 tutorial 2
MS PowerPoint 2010 tutorial 2
Khalfan Alshuaili
 
MS PowerPoint 2010 tutorial 1
MS PowerPoint 2010 tutorial 1MS PowerPoint 2010 tutorial 1
MS PowerPoint 2010 tutorial 1
Khalfan Alshuaili
 
MS Excel 2010 tutorial 5
MS Excel 2010 tutorial 5MS Excel 2010 tutorial 5
MS Excel 2010 tutorial 5
Khalfan Alshuaili
 
MS Access 2010 tutorial 6
MS Access 2010 tutorial 6MS Access 2010 tutorial 6
MS Access 2010 tutorial 6
Khalfan Alshuaili
 
MS Access 2010 tutorial 5
MS Access 2010 tutorial 5MS Access 2010 tutorial 5
MS Access 2010 tutorial 5
Khalfan Alshuaili
 
MS Access 2010 tutorial 4
MS Access 2010 tutorial 4MS Access 2010 tutorial 4
MS Access 2010 tutorial 4
Khalfan Alshuaili
 
MS Access 2010 tutorial 3
MS Access 2010 tutorial 3MS Access 2010 tutorial 3
MS Access 2010 tutorial 3
Khalfan Alshuaili
 
MS Access 2010 tutorial 2
MS Access 2010 tutorial 2MS Access 2010 tutorial 2
MS Access 2010 tutorial 2
Khalfan Alshuaili
 
MS Access 2010 tutorial 1
MS Access 2010 tutorial 1MS Access 2010 tutorial 1
MS Access 2010 tutorial 1
Khalfan Alshuaili
 

Recently uploaded (20)

Ajanta Paintings: Study as a Source of History
Ajanta Paintings: Study as a Source of HistoryAjanta Paintings: Study as a Source of History
Ajanta Paintings: Study as a Source of History
Virag Sontakke
 
Overview Well-Being and Creative Careers
Overview Well-Being and Creative CareersOverview Well-Being and Creative Careers
Overview Well-Being and Creative Careers
University of Amsterdam
 
How to Configure Public Holidays & Mandatory Days in Odoo 18
How to Configure Public Holidays & Mandatory Days in Odoo 18How to Configure Public Holidays & Mandatory Days in Odoo 18
How to Configure Public Holidays & Mandatory Days in Odoo 18
Celine George
 
Chemotherapy of Malignancy -Anticancer.pptx
Chemotherapy of Malignancy -Anticancer.pptxChemotherapy of Malignancy -Anticancer.pptx
Chemotherapy of Malignancy -Anticancer.pptx
Mayuri Chavan
 
LDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDMMIA Reiki News Ed3 Vol1 For Team and GuestsLDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDM Mia eStudios
 
puzzle Irregular Verbs- Simple Past Tense
puzzle Irregular Verbs- Simple Past Tensepuzzle Irregular Verbs- Simple Past Tense
puzzle Irregular Verbs- Simple Past Tense
OlgaLeonorTorresSnch
 
Classification of mental disorder in 5th semester bsc. nursing and also used ...
Classification of mental disorder in 5th semester bsc. nursing and also used ...Classification of mental disorder in 5th semester bsc. nursing and also used ...
Classification of mental disorder in 5th semester bsc. nursing and also used ...
parmarjuli1412
 
Origin of Brahmi script: A breaking down of various theories
Origin of Brahmi script: A breaking down of various theoriesOrigin of Brahmi script: A breaking down of various theories
Origin of Brahmi script: A breaking down of various theories
PrachiSontakke5
 
How to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo SlidesHow to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo Slides
Celine George
 
E-Filing_of_Income_Tax.pptx and concept of form 26AS
E-Filing_of_Income_Tax.pptx and concept of form 26ASE-Filing_of_Income_Tax.pptx and concept of form 26AS
E-Filing_of_Income_Tax.pptx and concept of form 26AS
Abinash Palangdar
 
The role of wall art in interior designing
The role of wall art in interior designingThe role of wall art in interior designing
The role of wall art in interior designing
meghaark2110
 
Final Evaluation.docx...........................
Final Evaluation.docx...........................Final Evaluation.docx...........................
Final Evaluation.docx...........................
l1bbyburrell
 
spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)
Mohamed Rizk Khodair
 
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Leonel Morgado
 
The History of Kashmir Karkota Dynasty NEP.pptx
The History of Kashmir Karkota Dynasty NEP.pptxThe History of Kashmir Karkota Dynasty NEP.pptx
The History of Kashmir Karkota Dynasty NEP.pptx
Arya Mahila P. G. College, Banaras Hindu University, Varanasi, India.
 
LDMMIA Reiki Yoga S5 Daily Living Workshop
LDMMIA Reiki Yoga S5 Daily Living WorkshopLDMMIA Reiki Yoga S5 Daily Living Workshop
LDMMIA Reiki Yoga S5 Daily Living Workshop
LDM Mia eStudios
 
Pope Leo XIV, the first Pope from North America.pptx
Pope Leo XIV, the first Pope from North America.pptxPope Leo XIV, the first Pope from North America.pptx
Pope Leo XIV, the first Pope from North America.pptx
Martin M Flynn
 
Drugs in Anaesthesia and Intensive Care,.pdf
Drugs in Anaesthesia and Intensive Care,.pdfDrugs in Anaesthesia and Intensive Care,.pdf
Drugs in Anaesthesia and Intensive Care,.pdf
crewot855
 
What is the Philosophy of Statistics? (and how I was drawn to it)
What is the Philosophy of Statistics? (and how I was drawn to it)What is the Philosophy of Statistics? (and how I was drawn to it)
What is the Philosophy of Statistics? (and how I was drawn to it)
jemille6
 
Ajanta Paintings: Study as a Source of History
Ajanta Paintings: Study as a Source of HistoryAjanta Paintings: Study as a Source of History
Ajanta Paintings: Study as a Source of History
Virag Sontakke
 
Overview Well-Being and Creative Careers
Overview Well-Being and Creative CareersOverview Well-Being and Creative Careers
Overview Well-Being and Creative Careers
University of Amsterdam
 
How to Configure Public Holidays & Mandatory Days in Odoo 18
How to Configure Public Holidays & Mandatory Days in Odoo 18How to Configure Public Holidays & Mandatory Days in Odoo 18
How to Configure Public Holidays & Mandatory Days in Odoo 18
Celine George
 
Chemotherapy of Malignancy -Anticancer.pptx
Chemotherapy of Malignancy -Anticancer.pptxChemotherapy of Malignancy -Anticancer.pptx
Chemotherapy of Malignancy -Anticancer.pptx
Mayuri Chavan
 
LDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDMMIA Reiki News Ed3 Vol1 For Team and GuestsLDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDMMIA Reiki News Ed3 Vol1 For Team and Guests
LDM Mia eStudios
 
puzzle Irregular Verbs- Simple Past Tense
puzzle Irregular Verbs- Simple Past Tensepuzzle Irregular Verbs- Simple Past Tense
puzzle Irregular Verbs- Simple Past Tense
OlgaLeonorTorresSnch
 
Classification of mental disorder in 5th semester bsc. nursing and also used ...
Classification of mental disorder in 5th semester bsc. nursing and also used ...Classification of mental disorder in 5th semester bsc. nursing and also used ...
Classification of mental disorder in 5th semester bsc. nursing and also used ...
parmarjuli1412
 
Origin of Brahmi script: A breaking down of various theories
Origin of Brahmi script: A breaking down of various theoriesOrigin of Brahmi script: A breaking down of various theories
Origin of Brahmi script: A breaking down of various theories
PrachiSontakke5
 
How to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo SlidesHow to Create Kanban View in Odoo 18 - Odoo Slides
How to Create Kanban View in Odoo 18 - Odoo Slides
Celine George
 
E-Filing_of_Income_Tax.pptx and concept of form 26AS
E-Filing_of_Income_Tax.pptx and concept of form 26ASE-Filing_of_Income_Tax.pptx and concept of form 26AS
E-Filing_of_Income_Tax.pptx and concept of form 26AS
Abinash Palangdar
 
The role of wall art in interior designing
The role of wall art in interior designingThe role of wall art in interior designing
The role of wall art in interior designing
meghaark2110
 
Final Evaluation.docx...........................
Final Evaluation.docx...........................Final Evaluation.docx...........................
Final Evaluation.docx...........................
l1bbyburrell
 
spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)spinal cord disorders (Myelopathies and radiculoapthies)
spinal cord disorders (Myelopathies and radiculoapthies)
Mohamed Rizk Khodair
 
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Redesigning Education as a Cognitive Ecosystem: Practical Insights into Emerg...
Leonel Morgado
 
LDMMIA Reiki Yoga S5 Daily Living Workshop
LDMMIA Reiki Yoga S5 Daily Living WorkshopLDMMIA Reiki Yoga S5 Daily Living Workshop
LDMMIA Reiki Yoga S5 Daily Living Workshop
LDM Mia eStudios
 
Pope Leo XIV, the first Pope from North America.pptx
Pope Leo XIV, the first Pope from North America.pptxPope Leo XIV, the first Pope from North America.pptx
Pope Leo XIV, the first Pope from North America.pptx
Martin M Flynn
 
Drugs in Anaesthesia and Intensive Care,.pdf
Drugs in Anaesthesia and Intensive Care,.pdfDrugs in Anaesthesia and Intensive Care,.pdf
Drugs in Anaesthesia and Intensive Care,.pdf
crewot855
 
What is the Philosophy of Statistics? (and how I was drawn to it)
What is the Philosophy of Statistics? (and how I was drawn to it)What is the Philosophy of Statistics? (and how I was drawn to it)
What is the Philosophy of Statistics? (and how I was drawn to it)
jemille6
 

MS Excel 2010 tutorial 2

  • 1. MS Excel 2010 User Interface The Quick Access Toolbar At the very top left hand side of the screen is the Quick Access toolbar. The Quick Access toolbar gives you with access to commands you frequently use. By default, Save, Undo, and Redo appear on the Quick Access toolbar. You can use Save to save your file, Undo to roll back an action you have taken, and Redo to reapply an action you have rolled back. The Title Bar Next to the Quick Access toolbar is the Title bar. On the Title bar, Microsoft Excel displays the name of the workbook you are currently using. At the top of the Excel window, you should see "Microsoft Excel - Book1" or a similar name.
  • 2. The Ribbon Tabs Buttons Font Group Dialog Box Launcher You use commands to tell Microsoft Excel what to do. In Microsoft Excel 2010, you use the Ribbon to issue commands. The Ribbon is located near the top of the Excel window, below the Quick Access toolbar. At the top of the Ribbon are several tabs; clicking a tab displays several related command groups. Within each group are related command buttons. You click buttons to issue commands or to access menus and dialog boxes. You may also find a dialog box launcher in the bottom-right corner of a group. When you click the dialog box launcher, a dialog box makes additional commands available. Worksheets Microsoft Excel consists of worksheets. Each worksheet contains columns and rows. The columns are lettered A to Z and then continuing with AA, AB, AC and so on; the rows are numbered 1 to 1,048,576. The number of columns and rows you can have in a worksheet is limited by your computer memory and your system resources. The combination of a column coordinate and a row coordinate make up a cell address. For example, the cell located in the upper-left corner of the worksheet is cell A1, meaning column A, row 1. Cell E10 is located under column E on row 10. You enter your data into the cells on the worksheet. The Formula Bar Formula Bar If the Formula bar is turned on, the cell address of the cell you are in displays in the Name box which is located on the left side of the Formula bar. Cell entries display on the right side of the Formula bar. If you do not see the Formula bar in your window, perform the following steps: 1. Choose the View tab. 2. Click Formula Bar in the Show/Hide group. The Formula bar appears.
  • 3. Note: The current cell address displays on the left side of the Formula bar. The Status Bar The Status bar appears at the very bottom of the Excel window and provides such information as the sum, average, minimum, and maximum value of selected numbers. You can change what displays on the Status bar by right-clicking on the Status bar and selecting the options you want from the Customize Status Bar menu. You click a menu item to select it. You click it again to deselect it. A check mark next to an item means the item is selected. Move around a Worksheet By using the arrow keys, you can move around your worksheet. You can use the down arrow key to move downward one cell at a time. You can use the up arrow key to move upward one cell at a time. You can use the Tab key to move across the page to the right, one cell at a time. You can hold down the Shift key and then press the Tab key to move to the left, one cell at a time. You can use the right and left arrow keys to move right or left one cell at a time. The Page Up and Page Down keys move up and down one page at a time. If you hold down the Ctrl key and then press the Home key, you move to the beginning of the worksheet. The Name Box You can also use the Name box to go to a specific cell. Just type the cell you want to go to in the Name box and then press Enter. 1. Type B10 in the Name box. 2. Press Enter. Excel moves to cell B10.
  翻译: