December 04, 2019
Amitraj
* Mathematical Functions of MS Excel:-
-> A very important feature in Excel is the formula. It is used to calculate values based on what is in cells, perform operations on a cell content, fetch values after an operation based on your search criteria and much more.
-> Mathematical Formulas in Excel are used to perform various arithmetic operations like sum, average, count, max, min etc. Here is a list of most frequently used mathematical formulas in excel.
SUM():
This function is used to add all the values within a cell range.
ROUND()
This function returns a number rounded to given number of digits.
DEC2BIN()
This function is used to convert a decimal number into a binary
number.
DEC2OCT()
This function is used to convert a decimal number to octal number
DEC2HEX()
This function is used to convert a decimal number to hexadecimal number.
POWER()
This function is used to find the power raised to a given number.
SQRT()
This function is used to find the square root of a given positive number.
AVERAGE()
To find the average of given range of values.
*MS Word Keyboard Shortcuts:
Event Shortcut
Open:- Ctrl+O
Save:- Ctrl+S
Close:- Ctrl+W
Cut:- Ctrl+X
Copy:- Ctrl+C
Paste:- Ctrl+V
Selct all:- Ctrl+A
Bold:- Ctrl+B
Italic:- Ctrl+I
Underline:- Ctrl+U
Decrease font size 1 point:- Ctrl+[
Increase font size 1 point:- Ctrl+]
Center text:- Ctrl+E
Print Window:- Ctrl+P
Save Document:- Ctrl+S
Cancel:- Esc
Undo:- Ctrl+Z
Re-do:- Ctrl+Y
*MS Powerpoint keyboard Shortcuts:
Start a slide show :- F5
Slide show from current slide:- Shift+ F5
Insert new Slide:- Ctrl+M
Goto next slide:- N
Goto previous slide:- P
Display blank black slide:- B
Display blank white slide:- W
Duplicate a slide:- Ctrl+D
Change Case:- Shift+F3
Apply superscript formatting:- Ctrl++
Apply subscript formatting:- Ctrl+=
Return to the first slide during show:- 1+Enter
End the slide show:- Esc
