Search This Blog

Search Engine

Custom Search

20090222

Lenova Warranty Service Telephone number in India

  1. India Toll Free - 1800 113324
  2. Alternate no. - 011 - 26388288
  3. SMS - 99001 73324

Function keys in Lenovo laptop

Lenovo G500s laptop-2905

PHOTO SOURCE  - © Raimond Spekking / , via Wikimedia Commons


LENOVO LAPTOP FUNCTION KEYS
  1. Fn+Esc - Disables & enables the camera
  2. Fn+F1 - Puts computer in stand by mode
  3. Fn+F2 - Turns LCD Screen on or off.
  4. Fn+F3 - Shifts to other connected display devices
  5. Fn+F5 - Enables or disables the built-in wireless device feature
  6. Fn+F6 - Enables or disables the touch pad
  7. Fn+F7/NmLk - Enables or Disables the Numeric keypad
  8. Fn+F8/ScrLk - Enables or Disables the Scroll Lock
  9. Fn+F9/Break - Activate the Break Function
  10. Fn+F10/Pause - Activate the Pause Function
  11. Fn+F11/F12 - Activate the F12 Function
  12. Fn+PgUp/Home - Activate the Home function
  13. Fn+Ins/SysRq - Activate the System Request
  14. Fn+Del/PrtSc - Activate the Print Screen function
  15. Fn+Upper arrow/Lower arrow - Increases or Decreases Dislay brightness
  16. Fn+Left arrow/right arrow - Increases or Decreases computer volume

Size Standards in Lenovo laptop

Hard Disk size standards

Size Standard by Manufacturers
1G=1000MB where
1MB=1000KB where
1KB=1000 bytes

And

Size Standard adopted by computers
1G=1024MB where
1MB=1024KB where
1KB=1024 bytes

So there is difference between the hard disk capacities indicated and displayed

20090221

Microsoft vs Sun Microsystem & Vlookup in Both offices

Microsoft gives Windows whereas Sun Microsystem gives Linux


Microsoft gives Microsoft office whereas Sun Microsystem gives Open office


Microsoft costs in India somewhat around Rs. 9000+14000 for office & window that amounts to Rs.23000 or around for 1 PC for installing licensed copy of Office & Window whereas Sun Microsystem is free.


Vlookup formula in Office is vlookup(F14,A5:B5,2,0) whereas vlookup formula in Open office is vlookup(F14;A5:B5;2)


Means instead of commas we have semi-columns and 4th part where zero or false is given is not applicable in Open office


Similarly CTRL+D function does not work in open office.


Hyperlink on any given word does not work in open office.We have to delete that word and after installing hyperlink a # mark comes against the word of that sheet with which we have established hyperlink.

20090216

What is Navdha Bhakti?

Vrundavan Radha Krishna 02

By Vrundavan gopi (Own work) [CC BY-SA 3.0], via Wikimedia Commons

Navdha Bhakti


1.) Hearing about the Lord - singing & chanting God's names (japa), hearing stories from scripture.
2.) Glorifying the Lord - describing God's all-attractive features, Praising, Stuti
3.) Remembering the Lord - internal meditation on the Lord's form, activities, names or personality, meditation in padmasan, smaran
4.) Serving the lotus feet of the Lord - providing a form of physical service, brooming temple, making prasad for Lord Vishnu
5.) Worshiping the Lord - deity worship (puja) is a popular form of this within India, Satyannarayan Puja, offering flowers, deepa, tilak etc.
6.) Offering prayers to the Lord - any form of prayer offered to please God.
7.) Serving the Lord - offering a service for Lord's pleasure, such as preaching activity, propagation of Gita verses & other Vedic thoughts and good thoughts
8.) Building a friendship with the Lord - having an internal, loving relationship with God.
9.) Surrendering everything unto the Lord - surrendering one's thoughts, actions and deeds to God, Karmafal Tyaag

Software testing jobs

For Software testing jobs to apply at
1.) hr@globalsoftech.org
2.) wbpojobs@wipro.com

20090209

105 Excel shortcut keys - all in 1 place

EXCEL KEYBOARD SHORTCUTS TO SAVE TIME

QWERTY keyboard

PICTURE - QWERT KEYBOARD ON COMMONS WIKIMEDIA


PART 1


  1. F1  Display the Assistant balloon
  2. CTRL+TAB  Switch to the next tab
  3. ALT+TAB  Switch to the next program.
  4. ALT+SHIFT+TAB  Switch to the previous program.
  5. CTRL+P or CTRL+SHIFT+F12  Display the Print dialog box.
  6. HOME  Move to the beginning of the row.
  7. CTRL+HOME  Move to the beginning of the worksheet.
  8. CTRL+END  Move to the last cell on the worksheet, in the bottom-most used row of the rightmost used column.
  9. CTRL+SHIFT+O (the letter O)  Select all cells that contain comments.
  10. F4 or CTRL+Y  Repeat the last action.
  11. CTRL+K  Insert a hyperlink.
  12. CTRL+; (semicolon)  Enter the date.
  13. CTRL+SHIFT+: (colon)  Enter the time.
  14. CTRL+Z  Undo the last action.
  15. CTRL+C  Copy the selected cells.
  16. CTRL+C, immediately followed by another CTRL+C   Display the Microsoft Office Clipboard (multiple copy and paste).
  17. CTRL+X  Cut the selected cells.
  18. CTRL+V  Paste copied cells.
  19. DELETE  Clear the contents of the selected cells.
  20. CTRL+HYPHEN  Delete the selected cells.
  21. CTRL+SHIFT+PLUS SIGN  Insert blank cells.
  22. ALT+' (apostrophe)  Display the Style dialog box.
  23. CTRL+1  Display the Format Cells dialog box.
  24. CTRL+SHIFT+~  Apply the General number format.
  25. CTRL+SHIFT+$  Apply the Currency format with two decimal places (negative numbers in parentheses).
  26. CTRL+SHIFT+%  Apply the Percentage format with no decimal places.
  27. CTRL+SHIFT+^  Apply the Exponential number format with two decimal places.
  28. CTRL+SHIFT+#  Apply the Date format with the day, month, and year.
  29. CTRL+SHIFT+@   Apply the Time format with the hour and minute, and AM or PM.
  30. CTRL+SHIFT+!  Apply the Number format with two decimal places, thousands separator, and minus sign (–) for negative values.
  31. CTRL+B  Apply or remove bold formatting.
  32. CTRL+I  Apply or remove italic formatting.
  33. CTRL+U  Apply or remove underlining.
  34. CTRL+5  Apply or remove strikethrough.
  35. CTRL+9  Hide the selected rows.
  36. CTRL+SHIFT+( (opening parenthesis)  Unhide any hidden rows within the selection.
  37. CTRL+0 (zero)  Hide the selected columns.
  38. CTRL+SHIFT+) (closing parenthesis)  Unhide any hidden columns within the selection.
  39. CTRL+SHIFT+&  Apply the outline border to the selected cells.
  40. CTRL+SHIFT+_  Remove the outline border from the selected cells.
  41. HOME or END  Move to the beginning or end of a field.


PART-2 - PIVOT TABLE


  1. CTRL+SHIFT+* (asterisk)   Selects an entire PivotTable report.
  2. ALT+SHIFT+RIGHT ARROW   Groups the selected items in a PivotTable field.
  3. ALT+SHIFT+LEFT ARROW  Ungroups grouped items in a PivotTable field.


PART 3 - OUTLOOK


  1. ALT+S  Sends the e-mail message.
  2. CTRL+SHIFT+B  Opens the Address Book.
  3. ALT+O  Opens the Options menu for access to the Options, Bcc Field, and From Field commands.
  4. ALT+P  Opens the Outlook Message Options dialog box (Options menu, Options command).
  5. ALT+K  Checks the names in the To, Cc, and Bcc boxes against the Address Book.
  6. ALT+PERIOD  Opens the Address Book for the To box.
  7. ALT+C  Opens the Address Book for the Cc box.
  8. ALT+B  If the Bcc box is displayed, opens the Address Book for the Bcc box.
  9. ALT+J  Goes to the Subject box in Outlook
  10. CTRL+SHIFT+G   Creates a message flag in Outlook


PART 4 - General excel shortcut keys


  1. CTRL+( Unhides any hidden rows within the selection.
  2. CTRL+) Unhides any hidden columns within the selection.
  3. CTRL+& Applies the outline border to the selected cells.
  4. CTRL+_ Removes the outline border from the selected cells.
  5. CTRL+~ Applies the General number format.
  6. CTRL+$ Applies the Currency format with two decimal places & negative numbers in parentheses.
  7. CTRL+% Applies the Percentage format
  8. CTRL+^ Applies the Exponential number format
  9. CTRL+# Applies the Date format
  10. CTRL+@ Applies the Time format in AM or PM.
  11. CTRL+! Applies the Number format with two decimal places, thousands separator, and minus sign (-) for negative values.
  12. CTRL+- Displays the Delete dialog box to delete the selected cells.
  13. CTRL+: Enters the current time.
  14. CTRL+; Enters the current date.
  15. CTRL++ Displays the Insert dialog box to insert blank cells.
  16. CTRL+1 Displays the Format Cells dialog box.
  17. CTRL+2 Applies or removes bold formatting.
  18. CTRL+3 Applies or removes italic formatting.
  19. CTRL+4 Applies or removes underlining.
  20. CTRL+5 Applies or removes strikethrough.
  21. CTRL+6 Alternates between hiding objects, displaying objects, and displaying placeholders for objects.
  22. CTRL+7 Displays or hides the Standard toolbar.
  23. CTRL+8 Displays or hides the outline symbols.
  24. CTRL+9 Hides the selected rows.
  25. CTRL+0 Hides the selected columns.
  26. CTRL+A Selects the entire worksheet.
  27. CTRL+B Applies or removes bold formatting.
  28. CTRL+C Copies the selected cells.
  29. CTRL+C+CTRL+C displays the Microsoft Office Clipboard.
  30. CTRL+D copy the cell into the cells below.
  31. CTRL+F Displays the Find dialog box.
  32. SHIFT+F5 also displays this dialog box, while SHIFT+F4 repeats the last Find action.
  33. CTRL+G Displays the Go To dialog box.
  34. F5 also displays this dialog box.
  35. CTRL+H Displays the Find and Replace dialog box.
  36. CTRL+I Applies or removes italic formatting.
  37. CTRL+K Inserts Hyperlink
  38. CTRL+L Displays the Create List dialog box.
  39. CTRL+N Creates a new, blank file.
  40. CTRL+O Displays the Open dialog box to open or find a file.
  41. CTRL+SHIFT+O selects all cells that contain comments.
  42. CTRL+P Displays the Print dialog box.
  43. CTRL+R Just as CTRL+D copies upper cells, CTRL+R copies Right cells,rows,columns whatever
  44. CTRL+S Saves the active file with its current file name, location, and file format.
  45. CTRL+U Applies or removes underlining.
  46. CTRL+V Pastes
  47. CTRL+W Closes the selected workbook window.
  48. CTRL+X Cuts the selected cells.
  49. CTRL+Y Repeats the last command or action upto certain limit
  50. CTRL+Z Undo command
  51. CTRL+SHIFT+Z uses the Undo or Redo command to reverse or restore the last correction



20090202

Age calculators in excel

First of all give formula = Today( )

This will give today's date on any day

Write your birth date say 26-1-1970

Now subtract A1-B1 where A1 = Today( )

& B1 = Birth date

So we get a number in cell C31 .

Now use formula = TEXT(C31,"yy-mm-dd") where C31 is A1-B1

Then we will get that number in C1 in format like 31-08-09 which means 31 is the age in years, 8

is the age in months and 9 is the age in days.

Similarly to know day of original and first birth date

Write birth date say 26-1-1970

Use formula Text(B31,"ddd") which will give answer as "Sun" that means day for 26-1-1970 was
Sunday means u were born on Sunday.

Other formula to calculate age based on Birth date is =DATEDIF(C12,NOW(),"y")
Where C12= Birth date

How to add 6 months to a date and get new date in next column?

FORMULA FOR ADDING 6 MONTHS TO A DATE 



Say 6-Jan-08

USE FORMULA = DATE(YEAR(A27),MONTH(A27)+6, Day(A27))
where A27=6-Jan-08

So we get answer as 6-Jul-08 in next column

That way days and year can also be added to get added date , year or month in next column of excel.