This section is for beginners with no knowledge of Excel.
A workbook is a group of worksheets that are used to organize, calculate & analyze various kind of related information.
Status Bar provides a quicker way to see the average, count, numerical count, minimum, maximum or sum of selected cells.
Percentage Formula is used to get the relationship between two numbers in percentage.
Percentage Change Formula in Excel is used to find out percentage difference between two numbers.
The Paste Options appear in Excel when you paste data into cells:
- Copy and paste values only help to prevent formatting.
- Keep source formatting helps to keep source formatting (like column width even formulas etc. of copied data) in pasted section.
Merge and unmerge cells combine more than one cells to a large one.
a cell reference is an address to a cell or a range of cells on a worksheet, it uses in formulas so that Excel find those values that you want to calculate in a formula.
A dynamic named range in Excel expands automatically when new values are added to the range. For Example, select the range A1:A6, name it ‘Data’ and then calculate the sum.
Use names in formulas: Formulas become much easier to understand and maintain when we use names instead of cell/range references.