Exploring Microsoft Excel

exploring_ms_exccel

 

Description of the Excel window elements
Feature Description
Office Button A button that provides access to workbook-level features and program setting
Quick Access Toolbar A collection of buttons that provide one-click access to commonly used commands, such as Save, Undo, Redo etc.
Title Bar A bar that displays the name of active workbook and the Excel program name
Ribbon The main set of commands organized by task into tabs and groups
Column Headings The letters that appear along the tip of the worksheets window to identify the different columns in the worksheet
Workbook Window A window that displays an Excel workbook
Vertical Scroll Bar A scroll bar used to scroll vertically through the workbook window
Horizontal Scroll Bar A scroll bar used to scroll horizontally through the workbook window
Zoom Controls Controls for magnifying and shrinking the content displayed in the active workbook window
View Shortcuts Buttons used to change how the worksheet content is displayed- Normal, Page Layout, or Page Break Preview view
Sheet Tabs Tabs that display the names of the worksheets in the workbook
Sheet Tab Scrolling Buttons Buttons to scroll the list of sheet tabs in the workbook
Row Headings The numbers that appear along the left of the worksheet window to identify the different rows in the worksheet
Select All Button A button used to select all of the cells in the active worksheet
Active Cell The cell currently selected in the active worksheet
Name Box A box that displays the cell reference of the active cell
Formula Bar A bar that displays the value or formula entered in the active cell

 

Excel Navigation Keys
Press To move the active cell
­↑ ↓ ← → Up, Down, Left or Right one cell
Home To column A of the current row
Ctrl + Home To Cell A1
Ctrl + End To the last cell in the worksheet that contains data
Enter Down one row to the start of the next row of data
Shift + Enter Up one row
Tab One column to the right
Shift + Tab One column to the left
Page Up, Page Down Up or down one screen
Ctrl + Page Up To the previous sheet in the workbook
Ctrl + Page Down To the next sheet in the workbook

One thought on “Exploring Microsoft Excel

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

*

code

clearPost Comment