Admissions Open: Regular Batch Dec 2026 & Mar 2027 Attempt— Get Upto 30% Off(T&C Apply)!
| Functions | Additional Information/ Shortcuts |
|---|---|
| Reset | This icon allows students to erase all that you wrote. A notification will pop up to confirm reset. |
| Paste Copy Cut |
Following are small shortcuts Paste (Ctrl+V) Copy (Ctrl+C) Cut (Ctrl+X) |
| Undo Redo |
When you undo your previous action and it happens to be reset then the erased content will restore in the word processing but not in the spreadsheet. The shortcut for this icon is Ctrl+Z (undo) Redo (Ctrl+Y) |
| Paragraph | 6 different font sizes are available |
| Bold Italic Underline and strikethrough |
Ctrl+B (bold) Ctrl+I (italic) Ctrl U (Underline) |
| Tables | The basic table offering cell, row, and column feature |
| Bulleted List Numbered List |
The text can be presented either in the bulleted or numbered ways. |
| Format painter | Format painter If there are set of text or object in a particular format and you wish to apply that format to your whole response or other objects than this tool is used |
| Select All | There is no toolbar icon available for this feature but this function has a shortcut of (Ctrl+A) |
| Cell fill colour | Right click the cell and select format cells and that is how cell is colored |
| Number formats | This feature allows students to format cell numbers. Right click the cell and select format cell for this feature |
| Currency format | This function can format currency. Again format cell option by way of right clicking the cell can opens this feature |
| Percentage format | It's the same as above |
| Fraction format | Same as above |
| date/ time format | This can be accessed the same way |
| Fraction format | Same as above |
| Function | Syntax | Description |
|---|---|---|
| Sum |
=SUM(number1,[number2],…) number1 (necessary) – the first number argument to be added. number2,,… (can be opted) – extra number arguments to be added. |
Sum up arguments you specify A number, range cell reference is called an argument |
| Average |
=AVERAGE(number1,[number2],…) number1 (required) – This indicates the argument you want the average of. number2,,… (optional) –This indicates the option to add extra argument you want the average of |
Average functionality allows students to get average of an argument they specify |
| Square root |
=SQRT(number) number (required) – the argument for square root |
This formula provides positive square root |
| Power |
=POWER(number, power) number (needed) – the base number (must be a real number) power (requiste) – It is the exponent that raises base number |
Returns the number raised to a power Can also be used to apply multiple roots. |
| Count |
=COUNT(value1,[value2],…) value1 (required) – The main item, range of cell, or cell reference counts the numbers contained. value2,… (needed) - extra numbers, cell references or cell ranges that need to be counted. |
If your spreadsheet contains lots of numerical data in cell the count feature will count the number of cells |
| Round |
=ROUND(number, num_digits) number (required) – the number you wish to round num_digits – the number of digits which you wish to round the number argument to. This argument allows number of digits to be rounded |
This feature allows student to round digits as per their request |
| Log |
=LOG(number,[base]) number (required) – the positive real number for which you want the logarithm base (optional) – This option allows alteration of the base you specify and if base is omitted it is perceived to be 0 |
The base you specify is returned to that logarithm number |
| NPV |
=NPV(rate,value1,[value2],…) rate (required) – the discount rate given as a decimal. value1 (required) – the item, cell reference, or range you want to discount cash flows within. value2,… (required) – additional numbers, cell references or ranges to be discounted. |
With this formula students can perform NPV calculation of an investment at a given discount rate over series of future cash flows. |
| IRR |
=IRR(values,[guess]) values (required) – the range of cash flows for which you want the internal rate of return. guess (optional) – a rate you think is close to the result of the IRR given as a decimal. |
This formula allows student to perform calculation on internal rate of return for a series of cash flows |
Begin your journey toward academic and professional success with VIFHE. Enroll today and take the first step toward achieving your aspirations!