MS Excel - Components of MS Excel Windows

-

 Components of MS Excel Windows

The different parts of Microsoft Excel are called components. Following are the components of Microsoft Excel -

  • ·  Office Button
  • ·  Quick access toolbar
  • ·  Title Bar
  • ·  Ribbon bar
  • ·  Menu bar
  • ·  Name box
  • ·  Formula bar
  • ·  Cell
  • ·  Workbook
  • ·  Worksheet

Office Button

Office Button It appears in the 2007 version of MS Excel. This button appears in a circular shape which contains the Microsoft logo. On clicking this button, we see various options like New, Open, Save, Save As, Print, Print Preview, Send, Close etc.

New (Ctrl+N)

This option is used to bring a new workbook in MS Excel, its shortcut key is control plus n ctrl+n.

Open (Ctrl+O)

The open option is used to open an already created excel file in MS Excel, its shortcut key is the control key plus o, ctrl+o.

On clicking the option, its dialog box opens, in which we have to select the MS Excel file, going to the location where our data is stored, we select the Excel sheet file and press the open button, our file opens.

Save (Ctrl+S)

Save It is used to save the file created in Microsoft Excel at a certain place. As soon as we use this option, we will have a dialog box open in which the location of the file will be asked to save the file, the name of the file. By giving as we click on save button our file will be from that place

Save As (F12)

It is used to save the previously saved file in Microsoft Excel by a different name at some other place. On clicking this option, we have its dialog box open in which we can name the file and save it at a certain place. After selecting and clicking the save option, the second copy of the file is saved with another name, its shortcut key is F12.

Print (Ctrl+P)

It is used to print the file prepared in Microsoft Excel through the printer, its shortcut key is control plus p ctrl + p

Print Preview (Ctrl+F2)

Through this option, we can see how the file will be printed before printing it and accordingly we can setup our page, its shortcut key is control plus app to ctrl + F2

Send

It is used to send files created in Microsoft Excel via e-mail through the Internet.

Close (Ctrl+W)

It is used to close an already open file in Microsoft Excel. its shortcut key is control plus app to Ctrl+W.

 

Quick Access Toolbar

 Through this toolbar, we can easily access many options or the toolbar appears to us in the title bar next to the office button, in which we can easily use opportunities like undo, redu, print, print preview, etc.

Menu bar / Tab

Just as we used to see menus in the 2003 version, now the menus are known as tabs, such as Home Tab, Insert Tab, Page Layout Tab, Formula Tab, Data Tab, Review Tab, View Tab, all these tabs can be clicked. On doing this ribbon appears in which we get many options using which we can use Microsoft Excel easily.

Ribbon

          Microsoft Excel 2007/2010 has a ribbon in which we can see the entire option of the menu through graphics. It is visible in 2007 and Microsoft Excel 2010. Earlier it used to be in the form of a menu, it has been upgraded and brought to the fore. Excel is easy to work with.

Formula Bar

In Excel, we see the formula bar in which we can apply the formula as per our requirement. Through this bar, we can edit any formula function, that is to say, any cell in which we have to edit, click on it. The formula appears in the bar, so that we can easily modify that formula or cell by going there, it is visible to us by doing FX and it is under the ribbon.

Cell

Cell Microsoft Excel Many rows and columns are given in MS Excel, when these rows and columns meet each other, then it is called a cell. Each cell has a cell address by which the cell is identified from it. It is like a rectangular box. When row and column meet each other, we call their combination a cell.

Cell Address / Name Box

Cell address of cell reference is the address of each cell by which that cell is identified, through that address we can work by applying different types of mathematical and logical formula functions, this is a very important information, without which we cannot correct We will not be able to apply formula function in this way, so it is very important to know and identify the cell address, it is always a cell address by combining both the number of rows and the number of columns, such as column number 1 and row number A, so its cell address will be A1.

Workbook

In Microsoft Excel, the work book itself is called a file, in which we do database and other work as per our requirement and store the data, there are 3 worksheets in each work book, thus we work in the work book itself.

Worksheet / Spread Sheet

The spreadsheet itself is called a worksheet. It is the primary document of ms-excel in which we work with data and store it. The spreadsheet is mainly a group of worksheets. It is an electronic line. The worksheet is made up of cells which are divided into rows and columns. The worksheet that is created together is always saved in the workbook. Each worksheet has 1048576 rows and 65536 columns. MS-Excel already has 3 sheets. We can bring maximum 256 sheets.

Location: FF-116, First Floor Gopal Vihar Shopping Complex, P N B Colony, Jabalpur, Madhya Pradesh 482002, India

Comments

Post a Comment

Popular posts from this blog

Courses After 12th Science

-
  Courses After 12th Science List of Best Courses after 12th Science with PCM Did you pursue the subject combination of Physics, Chemistry, and Mathematics in Class 12? If yes, then the following courses are the best options for you. BTech/Bachelor of Engineering Bachelor of Architecture (BArch) Bachelor of Computer Application (BCA) Integrated BE/MBA BSc Aviation Sciences BSc Physics BSc Chemistry BSc Maths BSc Computer Science BSc Information Technology BSc General BSc Electronics BSc Statistics BSc (Hons) Statistics BSc (Hons) Industrial Chemistry BSc Hotel Management BSc Electronics and Communication BSc Nautical Science Diploma in Computer Science Diploma in Nautical Science BSc Multimedia BSc Fire Safety and Hazard Management BSc Photography BSc Airlines and Tourism BSc Applied Chemistry BSc Finance BSc Software Engineering Bachelor of Engineering BSc Avionics BSc Accountancy BSc in Actuarial Science List of ...
Read more

MS Office Versions List

-
 MS Office Versions List Release date Title Components October 1, 1990 The Microsoft Office for Windows Word 1.1, Excel 2.0, PowerPoint 2.0 March 4, 1991 Office 1.5 Word 1.1, Excel 3.0, PowerPoint 2.0 July 8, 1991 Office 1.6 Word 1.1, Excel 3.0, PowerPoint 2.0, Mail 2.1 Early 1992 Office 2.5 Word 2.0a, Excel 4.0, PowerPoint 2.0e, Mail 2.1 August 30, 1992 Office 3.0 Word 2.0c, Excel 4.0, PowerPoint 3.0, Mail 3.0 January 17, 1994 Office 4.0 Word 6.0, Excel 4.0, PowerPoint 3.0, Mail 3.1 June 2, 1994 Office 4.3 Word 6.0, Excel 5.0, PowerPoint 4.0, Mail 3.2, Access 2.0 July 3, 1994 Office for NT 4.2 Word 6.0, Excel 5.0, PowerPoint 4.0, Office Manager August 24, 1995 Office 95 (7.0) ...
Read more

Computer - Network Topologies

-
Image
  Computer Network Topologies A Network Topology is the arrangement with which computer systems or network devices are connected to each other. Topologies may define both physical and logical aspect of the network. Both logical and physical topologies could be same or different in a same network. Point-to-Point Point-to-point networks contains exactly two hosts such as computer, switches or routers, servers connected back to back using a single piece of cable. Often, the receiving end of one host is connected to sending end of the other and vice-versa. If the hosts are connected point-to-point logically, then may have multiple intermediate devices. But the end hosts are unaware of underlying network and see each other as if they are connected directly. Bus Topology In case of Bus topology, all devices share single communication line or cable. Bus topology may have problem while multiple hosts sending data at the same time. Therefore, Bus topology either uses CSMA/CD tec...
Read more