4 Code for iPhone

Signal Check
Input the following in the dial pad
*3001#12345#*
Then press "dial"
>-50dBm  indicates signal strength is very good

-50 to -70 indicates signal strength is pretty good

-70 to -90 indicates signal strength is normal

'-90' - '-100dBm' indicates signal strength is normal


Incoming Call status (turn on call forward or not)
Input the following in the dial pad
*#21#
Then press "dial"

IMEI Number

Input the following in the dial pad
*#06#
Then press "dial"


Show the Support Number of Service Provider

Input the following in the dial pad
*#5005*7672#

Then press "dial"

Five usages of "Delete" key in Mac

In Mac, when "delete" key is pressed, Mac deletes a character of the left hand side of the cursor.

And any other usages ?

1. Press "fn" and "delete" key at the same time, Mac deletes a character of the right hand side of the cursor.

2. Press "option" and "delete" key, Mac deletes a whole word of the left hand side of the cursor.

3. Press "command" and "delete" key, Mac deletes the whole line.

4. Select a file or files and press "command" and "delete", Mac deletes the selected file(s) to recycle bin.

Make a Phone Call in Yosemite

You can make phone call in your mac with the following conditions

1. Mac with Yosemite installed.
2. iPhone with IOS 8 or above.
3. Both your Mac and iPhone are connected to the same wireless network.
4. Both devices are signed in with the same iCloud account.
5. Both devices are bluetooth turned on.


If you have satisfied all above conditions, you can make your phone call in you Mac......

But how ??
There is no dial pad in Yosemite, right ?

Here are the situations to make phone calls in Yosemite:

1. Click the phone icon in a contact's details within the Contacts app

2. Click the phone icon next to a valid phone number detected by Safari

3. Manually select a phone number and right-click it to call through a context menu

If you want  dial pad, you may try the following

Continuity Keypad  US$0.99 from the Mac App Store.

MS Excel Formula for Calculate Age by Entering Date of Birth

Formula: =TRUNC((DAYS360(D1,today(), FALSE))/360, 0)

D1:  is your target cell for input date of birth
today(): is the formula to return the date of today




Then, the cell with this formula returns the age of input.



Easy!

Rename a Group of Files in Yoesmite

In previous OSX, you need to use Automator to help you to change the name file of a group of files.

But in Yoesmite,
you can easily do it by Finder.
1. Highlight all your files.
2. Right-click and select "rename items"
3. A select "format" dropdown to apply a new nomemnclature to the whole list.

Re-size Your Windows in Yosemite

In Yoesmite,
If you click the green button, it will make your current windows expands to full screen.

But you just want the "old" way, how to do it ?

You just need to hold down the option key when clicking green button.

Microsoft Excel 2011 -- Move the cursor to the beginning of the line within a cell

How to move the cursor to the beginning of the line within a cell ??

Windows: Home
Mac: option + "left arrow"