Excel Basics Part — 2
Various functions and formulas can be used in order to make our work easier.
Split: The split button splits the screen into multiple sections, you can scroll each section separately.
Freeze panes: If you have headings in your columns like a header row, then you might want those to remain on screen while you move down the sheet. To do that you need to use Freeze Panes.
Entering data in workbook: Note that if you press Enter after typing data into a cell, the next cell is the one directly below, but if we press Tab after entering data in a cell, it selects the next cell along in the row as the active cell.
Adding a column between two columns: Simply select the right-hand of those two columns, then right-click and choose Insert to put another column to the left of the selected column.
Autofill Technique: We can use the autofill technique to directly fill the cells based on a particular pattern as shown below.
The AutoSum function in Excel gives a shortcut to calculate Sum, Average, Count, Maximum, Minimum, etc.
Error in function:
Although frustrating, formula errors are useful, because they tell you clearly that something is wrong. This is much better than not knowing.
Various errors are:
#DIV/0!, #NAME?, #N/A, #NUM, #VALUE!, #REF!, #NULL, ####, #SPILL!, #CALC!
Various functions and errors are covered in this article which form the basics of Excel.
To read Part — 1 of the basics of Excel follow the below link: