Friday, August 23, 2013

"Excel 2010 Ribbon: Overview and How to Hide the Ribbon?"


The Excel 2010 Ribbon is great! This is because it allows to access all of the program's features and commands. The Ribbon is the horizontal strip that runs across the top of the Excel2010 window, just below the title bar.

  • Clicking the down arrow in the upper right hand corner of the application (near the question mark) will open or close the ribbon interface (as shown below).
  • You can also use the keyboard shortcut Ctrl + F1 to minimize or expand the ribbon.
  • Click the arrow again will expand the ribbon.

The Ribbon is organized into various tabs, such as File, Home, Insert, etc and each tab contains related controls, which usually include buttons, lists, and check boxes. Not like Excel 2003, there is no menu bar in Excel 2010, so you do not use pull-down menus to access commands.
To help you better understand the ribbon, here are the tabs as it common functions:
  • File: This tab replaces the Office Button in Excel 2007. Use this tab to do things such as opening, saving, printing files and so on.
  • Home: Use this tab when creating, formatting, and editing a spreadsheet.
  • Insert: Use this tab when adding particular elements (including graphics, table, PivotTables, charts, hyperlinks, headers and footers, etc) to a spreadsheet.
  • Page Layout: Use this tab when preparing a spreadsheet for printing or reordering graphics on the sheet (including changing theme, setting margins, graphic orientations, etc).
  • Formulas: Use this tab when adding formulas and functions to a spreadsheet or checking a worksheet for formula errors.
  • Data: Use this tab when importing, querying, outlining, and subtotaling the data placed into a worksheet's data list.
  • Review: Use this tab when proofing, protecting, and marking up a spreadsheet for review by others.
  • View: Use this tab when changing the display of the Worksheet area and the data it contains.

In Office 2010 the ribbon can be hidden way with one simple mouse click. This function is available to the entire office suite include Word, Outlook, PowerPoint, and Excel.
Show Ribbon:
Excel 2010 ribbon expand

Minimize Ribbon:
Excel 2010 ribbon minimize

"Excel 2010 Quick Access Toolbar (QAT) - Adding and Removing Commands"

To add a command to the QAT
  • Select the Ribbon tab that contains the command you want to add.
  • Right-click the command and click Add to Quick Access Toolbar in the menu that appears.

  • add command to quick access toolbar

To quickly add some commands to the QAT
  • Click the arrow to the right of the quick access toolbar and choose a command from the menu.

  • quickly add command to quick access toolbar

  • The default 3 commands that appear on the QAT have the 'tick' beside the command.

To add an entire Ribbon command group to the QAT
  • Just right-click an area in the command group name (for example, Paragraph in the Home tab) and choose Add to Quick Access Toolbar.

To remove a command (including the default commands) from the QAT
  • Right-click the command you want to remove from the QAT.
  • Choose Remove from Quick Access Toolbar in the menu that appears.
You can access commands on the Excel 2010 Quick Access toolbar using the keyboard. Press the Alt key and then a number key that represents the KeyTip for the command you want to access.
For example, Alt + 1 will save the worksheet.

Thursday, August 8, 2013

Friday, August 2, 2013

Collage created by the ICT Club Students of Class IX and X (Session 2012-13) by using COLLAGE MAKER SOFTWARE.

Hardik Singhal


Bharat Gulati   

Rachit Singhal   


Riya Gupta                


 Rohan Kapoor         


Shikhar Jain          

Thursday, August 1, 2013

Students of classes 6th  to  8th  are required to submit their practical assignments in CD's from 15th  to  30th August in their respective computer periods.

Students participated in INTERNATIONAL OLYMPIAD OF COMPUTER SCIENCE (2012-13) and brought laurels for the School


Name

Class

Medals






Yashika Jindal
III
Gold

Navya Jain 
III
Silver





Amit Patel 
VI 
Gold





Deepanshu Jindal
IX
Gold

Sumit Patel 
IX
Silver

Arpit Goel
IX
Bronze





Tushar Gupta
X
Gold


Let's Learn How To Create Cross Word