You are here: Home⇒Basic of Excel⇒ Cell in Excel Worksheet is a combination of rows and column. When row and column inter-cross each other, there are make a rectangular shape, this rectangular shape is called Cell. A Cell is the smallest unit of worksheet. Total number of cell is 17,179,869,184 in one worksheet. Each cell has unique cell address. A cell address is combination of column name and row number.
You are here: Excel⇒Ms-Excel Worksheet What is Worksheet When data is arranged in tabular format, it is technically called worksheet. Worksheet is like as tables. And a table is a combination of Row and Column. When we make a new Ms Excel file, there are three worksheet already opened as named Sheet1, Sheet2, Sheet3. You can add more or delete any sheet. Total no. of rows and columns are depend on the version of MS-Excel. The following table shows the total no. of rows and columns with their excel version:-
You are here:Excel⇒Basic of Ms-Excel You had been learned introduction of Ms-Excel, now it is time to to learn about the basic of Excel. When you open Ms-Excel first time, its look something as following screenshot:
Figure: Screen shot of Basic Of Ms-Excel - Ms Excel theme
As you can analysis there are many options/tabs available in Ms-Excel. Let's we deal with all these options step by step. Firstly we can be divided these options in various parts as:
There are no pre-define keyboard shortcut key for open the MS Excel. If you frequently use Ms-Excel, then it is good for to make your own keyboard shortcut key to open Ms-Excel. It is very easy to create a built-in keyboard short-key. MS Excel give the facility to create your own keyboard shortcut key so you can open the MS Excel direct through keyboard. Creating or assign a keyboard shortcut key for MS Excel:
Step 1: Follows below process to Open Microsoft Office Excel Properties option
Start → All Programs → Microsoft Office → Microsoft Office Excel
(Right Click) → Properties
Figure: Screen shot for open the properties of MS Excel
MS Excel is a worksheet application program, which is developed by Micro Soft Corporation USA for Microsoft Windows, Mac OS X and Linux. It is used for storing, organizing and analyzing data. It features calculation, graphing tools, pivot tables, and macro programming language called Visual Basic for Applications. Excel is a part of Microsoft office or MS-Office. How to open or create a new Excel File: After the download/install the MS-Excel, there are first thing comes in mind how to open the your first excel file? There are many ways to open or creating a new file in excel as following :
Q. Write a C program to make the following continuous number pattern as: 1 2 6 3 7 10 4 8 11 13 5 9 12 14 15 Ans. Before write to start the C coding, first of all you should the understand the concept of above number pattern.
The 21th century is known for computer century. The innovation of computer is revolutionary step in the human world. Today each and every part of human life is directly or indirectly connecting to computer.
Q.Write a C program to make the following perfect equal number triangle shape as: 4 4 3 4 4 3 2 3 4 4 3 2 1 2 3 4 4 3 2 3 4 4 3 4 4 Ans. Its looks very tough to make the above number triangle but when you divided this triangle (pyramid) in sub-triangle (sub-pyramid) then its look like as: 4 4 34 4 3 23 4 4 3 2 12 3 4 4 3 23 4 4 34 4