Formatting Cell

MS Excel Cell can hold different types of data like Numbers, Currency, Dates, etc. You can set the cell type in various ways as shown below −

• Right Click on the cell » Format cells » Number.
• Click on the Ribbon from the ribbon.

Various Cell Formats

Below are the various cell formats.

• General − This is the default cell format of Cell.

• Number − This displays cell as number with separator.

• Currency − This displays cell as currency i.e. with currency sign.

• Accounting − Similar to Currency, used for accounting purpose.

• Date − Various date formats are available under this like 17-09-2013, 17^th-Sep-2013, etc.

• Time − Various Time formats are available under this, like 1.30PM, 13.30, etc.

• Percentage − This displays cell as percentage with decimal places like 50.00%.

• Fraction − This displays cell as fraction like 1/4, 1/2 etc.

• Scientific − This displays cell as exponential like 5.6E+01.

• Text − This displays cell as normal text.

• Special − Special formats of cell like Zip code, Phone Number.

• Custom − You can use custom format by using this.

Explore Window

The following basic window appears when you start the excel application. Let us now understand the various important parts of this window.

File Tab

The File tab replaces the Office button from Excel 2007. You can click it to check the Backstage view, where you come when you need to open or save files, create new sheets, print a sheet, and do other file-related operations.

Quick Access Toolbar

You will find this toolbar just above the File tab and its purpose is to provide a convenient resting place for the Excel's most frequently used commands. You can customize this toolbar based on your comfort.

Ribbon

Ribbon contains commands organized in three components −

• Tabs − They appear across the top of the Ribbon and contain groups of related commands. Home, Insert, Page Layout are the examples of ribbon tabs.

• Groups − They organize related commands; each group name appears below the group on the Ribbon. For example, group of commands related to fonts or group of commands related to alignment etc.

• Commands − Commands appear within each group as mentioned above.

Title Bar

This lies in the middle and at the top of the window. Title bar shows the program and the sheet titles.

Help

The Help Icon can be used to get excel related help anytime you like. This provides nice tutorial on various subjects related to excel.

Zoom Control

Zoom control lets you zoom in for a closer look at your text. The zoom control consists of a slider that you can slide left or right to zoom in or out. The + buttons can be clicked to increase or decrease the zoom factor.

View Buttons

The group of three buttons located to the left of the Zoom control, near the bottom of the screen, lets you switch among excel's various sheet views.

• Normal Layout view − This displays the page in normal view.

• Page Layout view − This displays pages exactly as they will appear when printed. This gives a full screen look of the document.

• Page Break view − This shows a preview of where pages will break when printed.

Sheet Area

The area where you enter data. The flashing vertical bar is called the insertion point and it represents the location where text will appear when you type.

Row Bar

Rows are numbered from 1 onwards and keeps on increasing as you keep entering data. Maximum limit is 1,048,576 rows.

Column Bar

Columns are numbered from A onwards and keeps on increasing as you keep entering data. After Z, it will start the series of AA, AB and so on. Maximum limit is 16,384 columns.

Status Bar

This displays the current status of the active cell in the worksheet. A cell can be in either of the fours states (a) Ready mode which indicates that the worksheet is ready to accept user inpu (b) Edit mode indicates that cell is editing mode, if it is not activated the you can activate editing mode by double-clicking on a cell (c) A cell enters into Enter mode when a user types data into a cell (d) Point mode triggers when a formula is being entered using a cell reference by mouse pointing or the arrow keys on the keyboard.

Dialog Box Launcher

This appears as a very small arrow in the lower-right corner of many groups on the Ribbon. Clicking this button opens a dialog box or task pane that provides more options about the group.

Introduction to Excel Starter

Microsoft Excel Starter 2010 is a spreadsheet program designed for everyday tasks such as setting up a budget, maintaining an address list, or keeping track of a list of to-do items. Excel Starter is part of Microsoft Office Starter 2010, and comes pre-loaded on your computer.

Excel Starter 2010 is very similar to Microsoft Excel 2010 in appearance. If you are new to the Ribbon interface or the Backstage view, Excel Starter gives you an opportunity to get accustomed to the new interface before upgrading to Excel 2010.

Excel Starter differs from the complete version of Excel in that it includes display advertising, and it does not support the advanced features of the complete version of Excel. If you find that you want more features, you can upgrade to Excel 2010 right from Excel Starter 2010. Just click Purchase on the Home tab on the ribbon.

Open Excel Starter and take a look around

Open Excel Starter with the Windows Start button.

1. Click the Start button  . If Excel Starter is not included among the list of programs you see, click All Programs, and then click Microsoft Office Starter.

2. Click Microsoft Excel Starter 2010.

   The Excel Starter startup screen appears, and a blank spreadsheet is displayed. In Excel Starter, a spreadsheet is called a worksheet, and worksheets are stored in a file called a workbook. Workbooks can have one or more worksheets in them.

1. Columns (labeled with letters) and rows (labeled with numbers) make up the cells of your worksheet.

2. Clicking the File tab opens the Backstage view of your workbook, where you can open and save files, get information about the current workbook, and perform other tasks that do not have to do with the content of the workbook, such as printing it or sending a copy of it in e-mail.

3. Each tab in the ribbon displays commands that are grouped by task. You'll probably spend most of your time using the Home tab, when you're entering and formatting data. Use the Insert tab to add tables, charts, pictures, or other graphics to your worksheet. Use the Page Layout tab to adjust margins and layout, especially for printing. Use the Formulas tab to make calculations on the data in your worksheet.

4. The pane along the side of the Excel Starter window includes links to Help and shortcuts to templates and clip art, to give you a head-start on creating workbooks for specific tasks, such as managing a membership list or tracking expenses. The pane also displays advertising and a link to purchase a full-feature edition of Office.

Rearrange the order of slides

In the pane on the left, click the thumbnail of the slide that you want to move, and then drag it to the new location.

To select multiple slides: Press and hold Ctrl, and in the pane on the left, click each slide that you want to move. Release the Ctrl key, and then drag the selected slides as a group to the new location.

Delete slides

1. For a single slide: Right-click the slide in the thumbnail pane on the left, and select Delete Slide.

2. For multiple slides: Press and hold Ctrl, and in the thumbnail pane on the left, select the slides. Release the Ctrl key. Then right-click the selection and choose Delete Slide.

3. For a sequence of slides: Press and hold Shift, and in the thumbnail pane on the left, select the first and last slides in the sequence. Release the Shift key. Then right-click the selection and choose Delete Slide.

Adding text to slides

1. On the Home tab, under Insert, click Text.
2. On the pop-up menu, click Text Box.
3. On the slide, click the location where you want to add the text box.
4. Type or paste your text in the text box.

 

Important Shortcut Keys for Computer

  

CTRL+A. . . . . . . . . . . . . . . . . Select All

CTRL+C. . . . . . . . . . . . . . . . . Copy

CTRL+X. . . . . . . . . . . . . . . . . Cut

CTRL+V. . . . . . . . . . . . . . . . . Paste

CTRL+Z. . . . . . . . . . . . . . . . . Undo

CTRL+B. . . . . . . . . . . . . . . . . Bold

CTRL+U. . . . . . . . . . . . . . . . . Underline

CTRL+I . . . . . . . . . . . . . . . . . Italic

F1 . . . . . . . . . . . . . . . . . . . . . . Help

F2 . . . . . . . . . . . . . . . . . . . . . Rename selected object

F3 . . . . . . . . . . . . . . . . . . . . . Find all files

F4 . . . . . . . . . . . . . . . . . . . . . Opens file list drop-down in dialogs

F5 . . . . . . . . . . . . . . . . . . . . . Refresh current window

F6 . . . . . . . . . . . . . . . . . . . . . Shifts focus in Windows Explorer

F10 . . . . . . . . . . . . . . . . . . . . Activates menu bar options

ALT+TAB . . . . . . . . . . . . . . . . Cycles between open applications

ALT+F4 . . . . . . . . . . . . . . . . . Quit program, close current window

ALT+F6 . . . . . . . . . . . . . . . . . Switch between current program windows

ALT+ENTER. . . . . . . . . . . . . . Opens properties dialog

ALT+SPACE . . . . . . . . . . . . . . System menu for the current window

ALT+¢ . . . . . . . . . . . . . . . . . . opens drop-down lists in dialog boxes

BACKSPACE . . . . . . . . . . . . . Switch to the parent folder

CTRL+ESC . . . . . . . . . . . . . . Opens Start menu

CTRL+ALT+DEL . . . . . . . . . . Opens task manager, reboots the computer

CTRL+TAB . . . . . . . . . . . . . . Move through property tabs

CTRL+SHIFT+DRAG . . . . . . . Create shortcut (also right-click, drag)

CTRL+DRAG . . . . . . . . . . . . . Copy File

ESC . . . . . . . . . . . . . . . . . . . Cancel last function

SHIFT . . . . . . . . . . . . . . . . . . Press/hold SHIFT, insert CD-ROM to bypass auto-play

SHIFT+DRAG . . . . . . . . . . . . Move file

SHIFT+F10. . . . . . . . . . . . . . . Opens context menu (same as right-click)

SHIFT+DELETE . . . . . . . . . . . Full wipe delete (bypasses Recycle Bin)

ALT+underlined letter . . . . Opens the corresponding menu

PC Keyboard Shortcuts

Document Cursor Controls

HOME . . . . . . . . . . . . . . to the beginning of the line or far left of field or screen

END . . . . . . . . . . . . . . . . to end of line, or far right of field or screen

CTRL+HOME . . . . . . . . to the top

CTRL+END . . . . . . . . . . to the bottom

PAGE UP . . . . . . . . . . . . moves document or dialog box up one page

PAGE DOWN . . . . . . . . moves document or dialog down one page

ARROW KEYS . . . . . . . move focus in documents, dialogs, etc.

CTRL+ > . . . . . . . . . . . . next word

CTRL+SHIFT+ > . . . . . . selects a word

Windows Explorer Tree Control

Numeric Keypad * . . . Expand all under the current selection

Numeric Keypad + . . . Expands the current selection

Numeric Keypad – . . . Collapses current selection

¦ . . . . . . . . . . . . . . . . . . Expand current selection or go to first child

‰ . . . . . . . . . . . . . . . . . . Collapse current selection or go to parent

Special Characters

‘ Opening single quote . . . alt 0145

’ Closing single quote . . . . alt 0146

“ Opening double quote . . . alt 0147

“ Closing double quote. . . . alt 0148

– En dash. . . . . . . . . . . . . . . alt 0150

— Em dash . . . . . . . . . . . . . . alt 0151

… Ellipsis. . . . . . . . . . . . . . . . alt 0133

• Bullet . . . . . . . . . . . . . . . . alt 0149

® Registration Mark . . . . . . . alt 0174

© Copyright . . . . . . . . . . . . . alt 0169

™ Trademark . . . . . . . . . . . . alt 0153

° Degree symbol. . . . . . . . . alt 0176

¢ Cent sign . . . . . . . . . . . . . alt 0162

1⁄4 . . . . . . . . . . . . . . . . . . . . . alt 0188

1⁄2 . . . . . . . . . . . . . . . . . . . . . alt 0189

3⁄4 . . . . . . . . . . . . . . . . . . . . . alt 0190

PC Keyboard Shortcuts

Creating unique images in a uniform world! Creating unique images in a uniform world!

é . . . . . . . . . . . . . . . alt 0233

É . . . . . . . . . . . . . . . alt 0201

ñ . . . . . . . . . . . . . . . alt 0241

÷ . . . . . . . . . . . . . . . alt 0247

File menu options in the current program

Alt + E Edit options in the current program

F1 Universal help (for all programs)

Ctrl + A Select all text

Ctrl + X Cut selected item

Shift + Del Cut selected item

Ctrl + C Copy selected item

Ctrl + Ins Copy selected item

Ctrl + V Paste

Shift + Ins Paste

Home Go to the beginning of the current line

Ctrl + Home Go to bethe ginning of the document

End Go to end of the current line

Ctrl + End Go to end of the document

Shift + Home Highlight from the current position to the beginning of the line

Shift + End Highlight from the current position to the end of line

Ctrl + f Move one word to the left at a time

Ctrl + g Move one word to the right at a time

MICROSOFT® WINDOWS® SHORTCUT KEYS

Alt + Tab Switch between open applications

Alt +

Shift + Tab

Switch backward between open

applications

Alt + Print

Screen

Create a screenshot for the current program

Ctrl + Alt + Del Reboot/Windows® task manager

Ctrl + Esc Bring up the start menu

Alt + Esc Switch between applications on the taskbar

F2 Rename selected icon

F3 Start find from desktop

F4 Open the drive selection when browsing

F5 Refresh contents

Alt + F4 Close current open program

Ctrl + F4 Close window in the program

Ctrl + Plus

Key

Automatically adjust widths of all columns

in Windows Explorer

Alt + Enter Open properties window of selected icon

or program

Shift + F10 Simulate right-click on selected item

Shift + Del Delete programs/files permanently

Holding Shift

During Bootup

Boot safe mode or bypass system files

Holding Shift

During Bootup

When putting in an audio CD, will prevent

CD Player from playing

WINKEY SHORTCUTS

WINKEY + D Bring desktop to the top of other windows

WINKEY + M Minimize all windows

WINKEY +

SHIFT + M

Undo the minimize done by WINKEY + M

and WINKEY + D

WINKEY + E Open Microsoft Explorer

WINKEY + Tab Cycle through open programs on the taskbar

WINKEY + F Display the Windows® Search/Find feature

WINKEY +

CTRL + F

Display the search for computers window

WINKEY + F1 Display the Microsoft® Windows® help

WINKEY + R Open the run window

WINKEY +

Pause /Break

Open the system properties window

WINKEY + U Open utility manager

WINKEY + L Lock the computer (Windows XP® & later)

OUTLOOK® SHORTCUT KEYS

Alt + S Send the email

Ctrl + C Copy selected text

Ctrl + X Cut selected text

Ctrl + P Open print dialog box

Ctrl + K Complete name/email typed in the address bar

Ctrl + B Bold highlighted selection

Ctrl + I Italicize highlighted selection

Ctrl + U Underline highlighted selection

Ctrl + R Reply to an email

Ctrl + F Forward an email

Ctrl + N Create a new email

Ctrl + Shift + A Create a new appointment to your calendar

Ctrl + Shift + O Open the outbox

Ctrl + Shift + I Open the inbox

Ctrl + Shift + K Add a new task

Ctrl + Shift + C Create a new contact

Ctrl + Shift+ J Create a new journal entry

WORD® SHORTCUT KEYS

Ctrl + A Select all contents of the page

Ctrl + B Bold highlighted selection

Ctrl + C Copy selected text

Ctrl + X Cut selected text

Ctrl + N Open new/blank document

Ctrl + O Open options

Ctrl + P Open the print window

Ctrl + F Open find box

Ctrl + I Italicize highlighted selection

Ctrl + K Insert link

Ctrl + U Underline highlighted selection

Ctrl + V Paste

Ctrl + Y Redo the last action performed

Ctrl + Z Undo last action

Ctrl + G Find and replace options

Ctrl + H Find and replace options

Ctrl + J Justify paragraph alignment

Ctrl + L Align selected text or line to the left

Ctrl + Q Align selected paragraph to the left

Ctrl + E Align selected