So, each cell will have its own address and this is what defines the cell. Rows and columns make the array and the junctions are called CELLS. Similarly excel 2003 has a limited 256 columns while the later versions have 16K columns While excel 2003 has 65K rows the later versions have more than a million. The number of rows and columns is one of the differences in the 2003 and later versions. It starts from A up to Z and then AA to AZ and then BA to BZ and so on. Similarly, column is a vertical area that goes from top to bottom and indicated by letters. When you click on the indicative number of the row you are in turn selecting the entire row like this Row is a horizontal area that goes from left to right. What you have in this array is rows and columns. It is comprised of cells, these are the building blocks of a spreadsheet. It identifies you current cell, your selection or the named list that you are using The Worksheet: On the left of the formula bar, you can see what is called as the name box. We will talk about this in detail when we work on the formula. HOW TO USE MICROSOFT EXCEL PLUSWhile working on a formula if you are stuck, you can click on the fx icon and you will see all possible formula that you can use plus information about the formula. While working on formula or long text you can click on the base of the bar and drag it to see more content. This formula bar will display the content of the current cell and if you have used a formula in a cell, it will display the exact formula. This is the beauty of the ribboned interface only relevant tabs are visible Formula Bar: You will possibly see more tabs in the ribbons when you are working with charts, tables and graphics. You will see the developer tab in the ribbon with all options available. By default the developer tab here is unchecked in ribbons put a check mark on this and click okay. It is simple! Go to file, click options and in the excel options window and click "customize ribbons". Now if you are using excel to create forms and assign macros, you would want to add the developer tab to the ribbon. Ribbon brings excel commands at your fingertips click any one tab and you will see all the commands contained in that ribbon. Ribbon contains most of the excel commands and I find this good when compared to the older versions of excel that had pull down menus, task panes and tool-bars. You can also change the position of the quick access toolbar by clicking "Show below the ribbon" and if you want it back at the top "show below the ribbon". Click on the one that you most frequently use then click add and click okay and the command is available in the quick access toolbar. Now almost all commands in excel are available in this dialogue box. There are some options like new, open, print that are available plus an option to fully customize the toolbar by clicking the 'more commands' option. By default you can see the save, redo and undo commands there but then if you click the small down arrow icon, you get options to customize the quick access tool bar. This small toolbar can be seen at the top left corner of the excel interface. Let's look at each one of them individually. Please enable JavaScript to watch this video.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |