Getting started with Excel 2007
Microsoft Excel 2007 came with similar features to previous versions, and many new features. There are three features to remember as you work within Excel 2007: The Microsoft Office Button, the Quick Access Toolbar, and the Ribbon. The various functions will be fully explained below.
Microsoft Excel could also be called a Spreadsheet. A spreadsheet is an electronic document that stores various types of data. It is mostly used for calculations. Below An example of a spreadsheet.
The Image above represent a Spreadsheet window.
There are vertical columns and horizontal rows. Each of The square shape boxes is called Cell , where the column and row intersect.
A cell is where you insert your texts or data during calculations within the spreadsheet. An Excel spreadsheet can contain workbooks and worksheets. The workbook is the holder for related worksheets.
Microsoft Office Button
Like the word processor, The Microsoft Office Button performs many of the functions. This button allows you to create a new workbook, Open an existing workbook, save and save as, print, send, or close and so many other commands which we will come across as we proceed further.
The Ribbon
The Ribbon can be called the control panel at the topside of the document. This is where the commonly used features are displayed. On it is seven tabs: Home, Insert, Page Layouts, Formulas, Data, Review, and View. Each tab is divided into groups. The groups are logical collections of features designed to perform function that you will utilize in creating, developing or editing your spreadsheets.
Additional features within each group can be found at the downward pointing arrow at the bottom of each group.
Click the arrow to display additional features.
Below is a general overview of what you can find contained in the tabs
Home: Clipboard, Fonts, Alignment, Number, Styles, Cells, Editing
Insert: Tables, Illustrations, Charts, Links, Text
Page Layouts: Themes, Page Set up, Scale to Fit, Sheet Options, Arrange
Formulas: Function Library, Defined Names, Formula Auditing, Calculation
Data: Get External Data, Connections, Sort & Filter, Data Tools, Outline
Review: Proofing, Comments, Changes
View: Workbook Views, Show/Hide, Zoom, Window, Macros
Quick Access Toolbar
The quick access toolbar contains commands that you can use to customize your worksheet. To view other command in the quick access bar , Click the downward pointing arrow beside it.
