MS EXCEL
1) INTRODUCTION
Quick Access toolbar is the only toolbar available in Microsoft Excel in the new
version 2010. Every tab has its own different ribbon, which are different options
available. Abcd Efg are the column headings. These are the columns headings. If you
click on any one column heading the entire column gets selected. The formula bar
where when you write a formula in the cell you get the answers. These are the
worksheets for navigating you have a button here. Let’s come on the right hand side
at the bottom if you see there is a scroll bar. The screen zoom scroll bar. If you want
the screen to go down right you have to click on this vertical scroll bar. Similarly, if
you want to take it back, you can use it using the mouse itself next is the buttons
which are used for minimize maximize. If I want to enter some data in the
worksheet, how do you enter it? You just keep occurs in any cell and you just start
typing here. If you want to edit the same cell, you have to use the shortcut key as f2
from a keyboard. F2 will bring your cursor in the editing mode and the cursor will
blink otherwise. If you forget the shortcut you can just use your mouse.
Lately, XLS and the newer version is XLSX. If you want to convert into pdf. You see
there's a Pdf option, if you want a macro-enabled workbook you can go for it, hence
there are various formats left while saving in SAVE AS format.
1) INTRODUCTION
Quick Access toolbar is the only toolbar available in Microsoft Excel in the new
version 2010. Every tab has its own different ribbon, which are different options
available. Abcd Efg are the column headings. These are the columns headings. If you
click on any one column heading the entire column gets selected. The formula bar
where when you write a formula in the cell you get the answers. These are the
worksheets for navigating you have a button here. Let’s come on the right hand side
at the bottom if you see there is a scroll bar. The screen zoom scroll bar. If you want
the screen to go down right you have to click on this vertical scroll bar. Similarly, if
you want to take it back, you can use it using the mouse itself next is the buttons
which are used for minimize maximize. If I want to enter some data in the
worksheet, how do you enter it? You just keep occurs in any cell and you just start
typing here. If you want to edit the same cell, you have to use the shortcut key as f2
from a keyboard. F2 will bring your cursor in the editing mode and the cursor will
blink otherwise. If you forget the shortcut you can just use your mouse.
Lately, XLS and the newer version is XLSX. If you want to convert into pdf. You see
there's a Pdf option, if you want a macro-enabled workbook you can go for it, hence
there are various formats left while saving in SAVE AS format.
