Microsoft Word is a word processing program used for writing letters, memos, reports and paper representations. It is a spreadsheet program used for calculations, making charts and recording data about all sorts of business processes.
It is used by businesses and individuals to write personal and professional letters, reports for work and school to take notes on conversations and in seminars and classes. Because it's so widely used, many businesses appreciate that it is possible to send documents created in word to clients, employees and other business associates without worrying about weather or not they will be able to open them.
Here are some shortcut keys that are used in ms-word.
Shortcut keys used in MS-Word
- Ctrl+shift+</>=word size(Increase /Decrease)
- Windows+M=Minimize
- Windows+Tab=Maximize
- Alt+Space+R=Restore
- Alt+space+X=Maximize
- Ctrl+A=Select All
- Ctrl+B=Bold
- Ctrl+C=copy
- Ctrl+D=open front dialogue box 10
- Ctrl+E=Align center
- Ctrl+f=find
- Ctrl+G=Go to
- Ctrl+H=Replace
- Ctr1+I=Italic
- Ctrl+j=lustify
- Ctrl+K=Hyperlink
- Ctrl+L=left Align
- Ctrl+M=Increase in Depth
- Ctrl+N=New
- Ctrl+O=Open
- Ctrl+P=print
- Ctrl+Q=remove indent
- Ctrl+R=Right Align
- Ctrl+S=save
- Ctrl+T=create a hanging indent
- Ctrl+U=Underline
- Ctrl+V=Paste
- Ctrl+W=Close Worksheet
- Ctrl+X=Cut
- Ctrl+Y=Redo(Repeat last Action)
- Ctrl+Z=Undo
- Ctrl+Enter=Add New page/Page Break
- Ctrl+Backspace= reverse (Add new page/Page break)
Microsoft Excel is a spreadsheet program. That means it is used to create grids of text, numbers and formulas specifying calculations. That is extremely valuable for many businesses, which use it to record expenditures and income, plan budgets, chart and many useful things.
It can be programmed to pull in data from external source such as stock market feeds, automatically running the data through formula such as financial models to update such information in real time like microsoft word.
Excel also contains fairly powerful programming capabilities for those who wish to use them that can be used to develop relatively financial and scientific computation capabilities.
Here are some important keys for ms- excel.
- Select row- shift+spacebar
- Insert row- shift+spacebar+ctrl+
- Delete row- shift+spacebar+ctrl-
- Select colourm- ctrl+spacebar
- insert column- ctrl+spacebar +
- Delete column-ctrl + space —
- insert cursor in cell-f2
- For inserting line in text/wrap text- alt+enter
- Save as- f12
- For inserting chart- select data+fi1
- Filter- ctrl+shift+l
- Freeze- alt+WFF
- Forgo to next sheet-ctrl + pagedown
- Forgo to previous sheet- ctrl + pageup
- Current date- ctrl+;
- Current time- ctri+:
- Present days- countif(Attendance range , “p”)
- Per day salary - monthly salary/present days
- Net salary - per day salary * present days
- Round figure — round(Net salary,0)
- Median(it shows the middle term in the series) - =median(Range)
- Mode(it shows the most repeated number in the series) - =mode(Range)
- Mod(it shows the remainder) - =Mod(Range)
- Factorial of number - =fact(number)
- Power(it shows the multiplication of a number according to power)- =power(number, power of number)
- SumSQ(\t firstly square the number and do addition of the number)- =SumSQ(x,y)
- Sum product(It multiply the first and third number and second and fourth number)- =Sumproduct(a:b,c:d)
- Sumif(iT shows the sum according to condition) - =SUMIF(x:y,”condition”)
- Today(it shows the current date in the system) - =TODAY()
- Round{IT converts the number into round figure)- =Round(number range,0)
- Roundup(It converts the number into round up)- =ROUNDUP(number range,0)
- RoundDown(It converts the number into round down)- =ROUNDDOWN(number range,0)
- roman(it converts the number into roman counting)- =ROMAN(number)
- row(it shows the current row number)- =row()
- column(it shows the current coloumn number}- =column()
- row(range)- it count the rows selected
- =columns(range)- it count the no of coloumn selected
- =even(range)- it converts the odd no. into even
- =odd(range)- it converts the even no into odd
- =Type()- it shows the data type No=1,Text=2, logical=4 and Error=16
- =Isnumber()- it checks whether cell is number or not
- =upper(range)-it converts the text into capital letters
- =lower(range)- it converts the text into small letters
- Replace(range ,”position ofword”, “0”,”word") - it inserts the character which is missing in the text
- =trim(range)- it removes spacebar from the text if space is more than one
- concatenate(range,” “,range) - it joins the two strings/words
- sign(number)- it checks whether selected cell has positive or negatiae number
- =abs(value)- it shows the absolute value
- =count(range)- it counts the numeric value
- =countA(range)- it counts both numeric and alphabetic data
- countif(range,” specific word”)- it counts according to the condition
- =countBlank(range)- it count only blank cell
- =Ctrl+: - it shows the current time
- now()- it shows current date and time
- =radians(value)- it converts the angle into degree
- =PI()- it shows the value of pi
- sqrt()-it shows the square root of the number
- =isnumber(cell)- it checks whther a cell contains a number or not
- =isNONtext(cell)- it checks whether a cell contain non text or not
- =and(condition,condition)- it checks two condition are true or not
- =or(condtion,condition)- it checks two condition is true or false
- =Exact(range,range)- it checks two text are same or not
- =product(range)- it shows the mut jon of numb
- =now() - it shows the current date and time
- =hour(time)- it shows the hour
- =minute{time)- it shows the minute
- =second(time)- it show the second
- =year(date)- it shows the year
- =month(date)- it shows the month
- =day(date)- it shows the day
- =islogical(cell)- it shows the data is logical or not
- =isblank(cell)- it shows whether cell is blank or not
- =left(text,5)- it shows the text from left
- =right(text,5)- it shows the text from right
- =mid(text,1,6)- it shows the word from giving starting and ending character number
- =len(text)- it shows the number of character in a text
- =trunk(decimal number)- it removes the decimal place from a number
- =date(date)- it shows the date format
- Sum if(Range,”condition”)- it shows the sum of range according to condition
- Sumsq(numbers)- it shows the square of the numbers then addition of square of the numbers
- =SumProduct(two numbers)- it multiply first and third no. and second and fourth number then addition
- =type(cell)- it shows the data type if data in number shows 1 text shows Z, error shows 16 and logical shows 4
- =PMT(rate/12,time*12,loan)- it is use to find out a monthly installment
- =PPMT(rate/12,1,time*12,loan)- it is used to calculate the principal portion of a given loan payment.
- =IPMT(rate/12,1,time,loan)- it is used to calculate interest to be paid on a given loan
- CGST = net amount-gross amount/2
Thanks for reading this complete article.
