1. Microsoft Excel is a widely used spreadsheet program that can be used for tasks like data management, statistics, forecasting, and business intelligence. It has key components like cells, worksheets, and workbooks.
2. The main components of an Excel window are the ribbon tabs, worksheet tabs, active cell, columns and rows, address bar, and formula bar. The formula bar displays the selected cell's content and address and can be used to enter values and formulas.
3. The formula bar can be expanded vertically and widened, and allows entering data, functions, and editing shapes by linking them to cells. It also includes buttons for entering, canceling, and inserting functions into a cell.
1. Microsoft Excel is a widely used spreadsheet program that can be used for tasks like data management, statistics, forecasting, and business intelligence. It has key components like cells, worksheets, and workbooks.
2. The main components of an Excel window are the ribbon tabs, worksheet tabs, active cell, columns and rows, address bar, and formula bar. The formula bar displays the selected cell's content and address and can be used to enter values and formulas.
3. The formula bar can be expanded vertically and widened, and allows entering data, functions, and editing shapes by linking them to cells. It also includes buttons for entering, canceling, and inserting functions into a cell.
1. Microsoft Excel is a widely used spreadsheet program that can be used for tasks like data management, statistics, forecasting, and business intelligence. It has key components like cells, worksheets, and workbooks.
2. The main components of an Excel window are the ribbon tabs, worksheet tabs, active cell, columns and rows, address bar, and formula bar. The formula bar displays the selected cell's content and address and can be used to enter values and formulas.
3. The formula bar can be expanded vertically and widened, and allows entering data, functions, and editing shapes by linking them to cells. It also includes buttons for entering, canceling, and inserting functions into a cell.
1. Microsoft Excel is a widely used spreadsheet program that can be used for tasks like data management, statistics, forecasting, and business intelligence. It has key components like cells, worksheets, and workbooks.
2. The main components of an Excel window are the ribbon tabs, worksheet tabs, active cell, columns and rows, address bar, and formula bar. The formula bar displays the selected cell's content and address and can be used to enter values and formulas.
3. The formula bar can be expanded vertically and widened, and allows entering data, functions, and editing shapes by linking them to cells. It also includes buttons for entering, canceling, and inserting functions into a cell.
Download as DOCX, PDF, TXT or read online from Scribd
Download as docx, pdf, or txt
You are on page 1/ 5
An Introduction to Microsoft Excel | Basics Knowledge + Components +
Examples
Introduction to Microsoft Excel
There are numbers of spreadsheet programs but from all of them, Excel is most widely used. People have been using it for last 30 years and throughout these years, it has been upgraded with more and more features.
The best part about Excel is, it can apply to many business tasks,
including statistics, finance, data management, forecasting, analysis, to track inventory & billing, and business intelligence. Following are the few things which it can do for you:
Number Crunching Charts and Graphs Store and Import Data Manipulating Text Templates/Dashboards Automation of Tasks And Much More… Three most important components of Excel is which you need to understand first:
1. Cell A cell is a smallest but most powerful part of a spreadsheet. You can enter your data into a cell either by typing or by copy-paste. Data can be a text, a number, or a date. You can also customize it by changing its size, font color, background color, borders, etc.
Every cell is identified by its cell address, cell address contains its column number and row number (If a cell is on 11th row and on column AB, then its address will be AB11).
2. Worksheet: A worksheet is made up of individual cells which can contain a value, a formula, or text. It also has an invisible draw layer, which holds charts, images, and diagrams. Each worksheet in a workbook is accessible by clicking the tab at the bottom of the workbook window.
In addition, a workbook can store chart sheets; a chart sheet displays
a single chart and is accessible by clicking a tab.
3. Workbook A workbook is a separate file just like every other application has. Each workbook contains one or more worksheets. You can also say that a workbook is a collection of multiple worksheets or can be a single worksheet.
You can add or delete worksheets, hide them within the workbook without deleting them, and change the order of your worksheets within the workbook. Microsoft Excel Window Components Before you start using it, it’s really important to understand that what’s where in its window. So ahead we have all the major component which you need to know before entering the world of Microsoft Excel.
1. Active Cell: A cell which is currently selected. It will be
highlighted by a rectangular box and its address will be shown in the address bar. You can activate a cell by clicking on it or by using your arrow buttons. To edit a cell, you double-click on it or use F2 to as well. 2. Columns: A column is a vertical set of cells. A single worksheet contains 16384 total columns. Every column has its own alphabet for identity, from A to XFD. You can select a column clicking on its header. 3. Rows: A row is a horizontal set of cells. A single worksheet contains 1048576 total rows. Every row has its own number for identity, starting from 1 to 1048576. You can select a row clicking on the row number marked on the left side of the window. 4. Fill Handle: It’s a small dot present on the lower right corner of the active cell. It helps you to fill numeric values, text series, insert ranges, insert serial numbers, etc. 5. Address Bar: It shows the address of the active cell. If you have selected more than one cell, then it will show the address of the first cell in the range. 6. Formula Bar: The formula bar is an input bar, below the ribbon. It shows the content of the active cell and you can also use it to enter a formula in a cell. 7. Title Bar: The title bar will show the name of your workbook, followed by the application name (“Microsoft Excel”). 8. File Menu: The file menu is a simple menu like all other applications. It contains options like (Save, Save As, Open, New, Print, Excel Options, Share, etc). 9. Quick Access Toolbar: A toolbar to quickly access the options which you frequently use. You can add your favorite options by adding new options to quick access toolbar. 10. Ribbon Tab: Starting from the Microsoft Excel 2007, all the options menus are replaced with the ribbons. Ribbon tabs are the bunch of specific option group which further contains the option. 11. Worksheet Tab: This tab shows all the worksheets which are present in the workbook. By default you will see, three worksheets in your new workbook with the name of Sheet1, Sheet2, Sheet3 respectively. 12. Status Bar: It is a thin bar at the bottom of the Excel window. It will give you an instant help once you start working in Excel. Formula Bar in Excel
What is the Excel Formula Bar?
Excel Formula Bar is a thin bar below the ribbon that displays the selected cell’s content and displays the cell address of the selected cell on the left side. You can also enter a value into the cell from the formula bar. It has three buttons (Enter, Cancel, and Insert Function).
Name Box Horizontal Expand Buttons Input bar Vertical Expand How to Show Formula Bar (or Hide it) The formula bar is active by default but if it is hidden, you can activate it from the view tab.
1. First go to the view tab, and from the show group and tick mark formula bar.
2. Apart from this, you can also activate it from the Excel options. 3. Go to the Excel options ➜ Advanced ➜ Display ➜ Show formula bar.
You can use the same steps if you want to hide it.
Expand Formula Bar
By default, the formula bar is thin, but you can expand it and make it a little wide. When you hover your cursor on the bottom of the formula bar, it converts into a vertical double-ended arrow, and then you can pull it down to expand it. There’s also a shortcut key (Control + Shift + U) that you can use to expand the formula bar vertically. You can also use the drop-down icon from the right side.
And if you want to change its width you can do it by hovering
your cursor on the three dots between the name box and formula bar and then stretch it to the right or left.
Excel Keyboard Shortcut Cheat
Sheet Enter Data from the Formula Bar You can enter data into a cell using the formula bar and for this, you need to select the cell and click on the input bar in the formula bar.
And once you are done with the
value that you want to enter; you can click on the enter button that is on the left side of the formula bar.
There’s also a button to cancel the data entry or you can press the escape key.
Enter a Function using Formula Bar
There is an insert function button on the formula bar, and when you click on this button, it opens a dialogue box from which you can find and insert the function. Once you select the function you want to insert, click OK, and it will show you a dialog box to define the function’s arguments.
Use Name Box
On the right side of the formula bar, you have a name box that shows the cell address for the selected cell. But you can also use this name box to navigate. You are a specific cell or a range. When you click on the name box, it allows you to edit it, and you can enter a cell address, and once you do that and hit enter, it will navigate you to that cell.
In the same way, you can also enter a range’s
address to select it.
Edit Shapes from Formula Bar
If you want to connect a shape with a cell, you can do that by editing it from the formula bar.
1. Select the shape that you have in the worksheet.
2. Click on the formula bar to edit it. 3. Enter “=” and select the cell that you want to connect with the shape. 4. In the end, click, OK.
(9789004395114 - Reading Proclus and The < I> Book of Causes< - I> Volume 1) Reading Proclus and The < I> Book of Causes< - I> Volume 1 PDF
(9789004395114 - Reading Proclus and The < I> Book of Causes< - I> Volume 1) Reading Proclus and The < I> Book of Causes< - I> Volume 1 PDF
