Share Excel Application
Save to Folder
It identifies the location of a cell or a group of cells in a worksheet.
cell reference or cell address
The row and column references can change when we copy formula to another cell. It is the default cell reference
Relative reference
The row and column references do not change when we copy formula as the reference points to a fixed cell address.
Absolute Referencing
The ___ sign is used for absolute referencing
$
If the row reference is relative, the column reference will be absolute and vice versa.
Mixed Reference
when a formula refers to its own cell value directly or indirectly. It is referred as ___ reference
Circular
The predefined formula that performs specific calculation is known as a __
Function
The process of linking or joining text values in a series is called ___
Concatenation
Symbol used to add text/string values is ___
&
The order in which the operators are to be evaluated in a formula in MS Excel is known as
Operator Hierarchy
The feature automatically adds the numbers in the selected cells.
AutoSum
The Auto sum button ( ∑ ) is present in the editing group of ___ tab.
HOME
Shortcut key to create a new workbook
ctrl+N
Pictorial representation of the data in the cells is known as a ___
Chart
The group of contiguous cells is known as ____
Cell Range
List any 6 types of charts
Column chart, Line chart, Pie chart, Bar chart, Area chart, Scatter chart ,Surface chart ,Radar Combo chart ,Stock chart
