Bluejacking:

A kind of practical joke played out between Bluetooth-enabled devices, bluejacking takes advantage of a loophole in the technology's messaging options that allows a user to send unsolicited messages to other nearby Bluetooth owners. A bluejacker will most likely camp out in crowded areas like shopping malls, airports and subway systems to find victims -- places with a potentially high percentage of people with Bluetooth-enabled devices.
Bluetooth technology operates by using low-power radio waves, communicating on a frequency of 2.45 gigahertz. This special frequency is also known as the ISM band, an open, unlicensed band set aside for industrial, scientific and medical devices. When a number of Bluetooth devices are switched on in the same area, they all share the same ISM band and can locate and communicate with each other; much like a pair of walkie talkies tuned to the same frequency is able to link up.
Bluetooth technology users take advantage of this ability to network with other phones and can send text messages or electronic business cards to each other. To send information to another party, the user creates a personal contact name in his or her phone's address book -- the name can be anything from the sender's actual name to a clever nickname.
Bluejackers have devised a simple technique to surprise their victims: Instead of creating a legitimate name in the address book, the bluejacker's message takes the place of the name. The prank essentially erases the "from" part of the equation, allowing a user to send any sort of comment he wishes without indentifying himself.
Bluejacking is imprecise, however. Searching for other Bluetooth-enabled hardware might turn up a list of devices labeled with a series of numbers and letters. Unless the bluejacker's target has chosen to publicly identify his or her phone, or it's the only Bluetooth phone in the area, the bluejacker may have a hard time messaging his or her target on the first try.

Enter Current Date and Time:

To enter the current date or time click on a cell and type
=today() or =now().
Excel updates the result every time you open the sheet, so it’s always current.

Repeatability:

Repeatability is the variation in measurements taken by a single person or instrument on the same item and under the same conditions. A measurement may be said to be repeatable when this variation is smaller than some agreed limit. According to the Guidelines for Evaluating and Expressing the Uncertainty of NIST Measurement Results, repeatability conditions include:
• the same measurement procedure
• the same observer
• the same measuring instrument, used under the same conditions
• the same location
• Repetition over a short period of time.
Repeatability methods were developed by Bland and Altman (1986). The repeatability coefficient is a precision measure which represents the value below which the absolute difference between two repeated test results may be expected to lie with a probability of 95%. The standard deviation under repeatability conditions is part of precision and accuracy.

Enter URLs as Text:

To prevent Excel from converting written Internet addresses into hyperlinks, add an apostrophe to the beginning of the address.
For example - 'www.yahoo.com.

Also you can use the apostrophe for entering the functions also as text.
Ex:- '=today()

F1-F9 Key Commands for the Command Prompt:

Mentioned below F1- F9 key commands used in the Command prompt.

F1 / right arrow: Repeats the letters of the last command line, one by one.
F2: Displays a dialog asking user to “enter the char to copy up to” of the last command line
F3: Repeats the last command line
F4: Displays a dialog asking user to “enter the char to delete up to” of the last command line
F5: Goes back one command line
F6: Enters the traditional CTRL+Z (^z)
F7: Displays a menu with the command line history
F8: Cycles back through previous command lines (beginning with most recent)
F9: Displays a dialog asking user to enter a command number, where 0 is for first command line entered.
Alt+Enter: toggle fullScreen mode.
up/down: scroll thru/repeat previous entries
Esc: delete line

Copy Into:

"Copy Into" is a Lotus Notes mail template feature that enables you to select an existing Email/Calendar Entry/To-do, and create a new Email/Calendar Entry/To-do which automatically inherits information from the selected document. This is extremely useful, as it removes the need to manually copy and paste data from the selected document into the new one.

Let's say you get a memo from your manager. The memo discusses some details for an existing project, and requires you to call a meeting with the other recipients to discuss next steps. Rather than creating a new Calendar Entry for the meeting where you have to manually enter all the information, instead choose the action "Copy Into New - New Calendar Entry"


Lotus Notes prompts you for what type of Calendar Entry to create, and since this will involve others, you choose Meeting.


A new Calendar Entry is created for you with the Subject, Invitees, and Description fields automatically filled in for you.


The Required invitees will be the original Sender and all names that were in to To: field, and the Optional invitees will be all the names that were in the CC: field.

Now all you have to do is choose the date and time, and click Save and Send.

Dead Net:

The lowest costs for goods after all allowances are subtracted, also known as net-net.

More Keyboard Shortcuts:

CTRL and A ------ Selects all in the current document.
CTRL and B ------ Bold text.
CTRL and C ------ Copies the item or text to the Clipboard and can be pasted using CTRL and V
CTRL and D ------- Displays the Font dialogue box
CTRL and E ------ Centre Alignment
CTRL and F ------- Displays the Find dialog box, to search the current document.
CTRL and G ------- Displays the Go to dialog box, to go to a specific location in the current document.
CTRL and H ------- Displays the Replace dialogue box.
CTRL and I -------- Italic text
CTRL and J ------- Full Justification.
CTRL and K ------ Create Hyperlink
CTRL and L ------- Left Alignment
CTRL and M -------Tab
CTRL and N ------- Creates a new document
CTRL and O ------- Displays the Open File dialogue box.
CTRL and P ------- Displays the Print dialog box
CTRL and R ------- Right Alignment.
CTRL and S ------- Displays the Save dialog box
CTRL and U ------- Underline text
CTRL and V ------- Pastes the copied item or text from the Clipboard into the current position in the document
CTRL and X ------- Cuts the item or text selected to the Clipboard
CTRL and Y ------- Redo the last undone action
CTRL and Z ------- Undoes the last action.
CTRL and ENTER ---Insert Page Break.
CTRL and F2 --------Show Print preview.
CTRL and F4 ------- Closes the active document window.
CTRL and F6------- Opens the next document window

St. Patrick’s Day:

Saint Patrick's Day, colloquially St. Paddy's Day or Paddy's Day, is an annual feast day which celebrates Saint Patrick, one of the patron saints of Ireland, and is generally celebrated on March 17.
Saint Patrick's Day is celebrated worldwide by the those of Irish descent and increasingly by non-Irish people (usually in New Zealand and North America). Celebrations are generally themed around all things Irish and, by association, the colour green. Both Christians and non-Christians celebrate the secular version of the holiday by wearing green, eating Irish food and/or green foods, imbibing Irish drink (such as Irish stout, Irish Whiskey or Irish Cream) and attending parades.


The wearing of the green meaning to wear a shamrock on one's clothing. At many times in Irish history, to do so was seen as a sign of Irish nationalism or loyalty to the Roman Catholic faith. St. Patrick used the shamrock, a three-leaved plant, to explain the Holy Trinity to the pre-Christian Irish. The wearing of and display of shamrocks and shamrock-inspired designs have become a ubiquitous feature of the saint's holiday

Business Process Reengineering:

Business process reengineering (BPR) is, in computer science and management, an approach aiming at improvements by means of elevating efficiency and effectiveness of the business process that exist within and across organizations. The key to BPR is for organizations to look at their business processes from a "clean slate" perspective and determine how they can best construct these processes to improve how they conduct business.
Business process reengineering is also known as BPR, Business Process Redesign, Business Transformation, or Business Process Change Management.



BPR, if implemented properly, can give huge returns. BPR has helped giants like Procter and Gamble Corporation and General Motors Corporation succeed after financial drawbacks due to competition. It helped American Airlines somewhat get back on track from the bad debt that is currently haunting their business practice. BPR is about the proper method of implementation.

Key board Shortcuts:

F1 key Get help or use the Office assistant.
SHIFT and F1 Key Context sensitive help.
F2 Key Move text or image
SHIFT and F2 Key Copy Text.
F3 Key Insert an autotext entry.
SHIFT and F3 Key Change the case of the selected text.
F4 Key Perform last action again.
SHIFT and F4 Key Perform a Find or Go to action again.
F5 Key Displays the Go to dialogue box, from here you can also Find and Replace.
SHIFT and F5 Key Move to a previous revision.
F6 Key Go to the next frame or pane.
SHIFT and F6 Key Go to the previous frame or pane.
F7 Key Launch the Spell checker.
SHIFT and F7 Key Launch the Thesaurus.
F8 Key Extend the current selection.
SHIFT and F8 Key Shrink the current selection.
F9 Key Update the selected fields.
SHIFT and F9 Key Switch between a field code and it’s result.
F10 Key Activate the menu bar.
SHIFT and F10 Key Display a Shortcut Menu. Same as right clicking.
F11 Key Go to the next field.
SHIFT and F11 Key Go to the previous field.
F12 Key Save file As, equivalent to tools menu.
SHIFT and F12 Key Save document, equivalent to tools menu.

Color the Sheet Tabs:

Select a sheet tab, right-click, and select Tab Color from the shortcut menu.

Create a New Memo anytime:

Anytime you are using Lotus Notes... if you are in your inbox, in your calendar, in a discussion database, HelpDesk application, document library, or any other Notes database your company uses... don't navigate back to your inbox just to click "New Memo", instead simply hit CTRL+M.

Price Ceiling:

A price ceiling is a government-imposed limit on how high a price can be charged on a product. For a price ceiling to be effective, it must differ from the free market price. In the graph at right, the supply and demand curves intersect to determine the free-market quantity and price.
A price ceiling can be set above or below the free-market equilibrium price. In the graph at right, the dashed line represents a price ceiling set above the free-market price, called a non-binding price ceiling. In this case, the ceiling has no practical effect. The government has mandated a maximum price, but the market price is established well below that.

In contrast, the solid green line is a price ceiling set below the free-market price, called a binding price-ceiling. In this case, the price ceiling has a measurable impact on the market.
A price ceiling set below the free-market price has several effects. Suppliers find they can no longer charge what they had been charging for their products. As a result, some suppliers drop out of the market. This represents a reduction in the quantity supplied. Meanwhile, consumers find that they can now buy the same product at a lower price. As a result quantity demanded increases.

As a result of these two actions, quantity demanded exceeds quantity supplied and a shortage emerges. This leads to various forms of non-price competition.

Return to the last place you were working:

Return to the last place you were working or the place before that or before that.

Press Shift + F5 repeatedly to return to last 5 cursor positions (even if one of those positions is in another open document).

This one’s even cleverer, when you first open a document, press shift + F5 to jump to the last place you or someone else edited before closing the document.

Category Development Index (CDI):

Category Development Index or (CDI) measures the sales strength of a particular category of product, within a specific market (e.g. Soft drinks in 10 - 50 year old's). It is a trend analysis that indicates the pace of sales of a product category in an area.
To calculate the CDI:
A% / X% * 100
Simply divide product "A"'s total sales in the specific market, then divide it by the population in that specific market. Finally you multiply the result by one hundred to get an index number.
The CDI is useful in all marketing strategies when used with the Brand Development Index or BDI. The CDI can give vital data for marketers to allocate advertising to specific areas maximizing product category knowledge and profit.

Counting the Cells:

The COUNTA formula returns the number of cells that contain any type of data in a range.

The COUNT formula returns the number of cells that contain only numeric data in a range.

Subtracting the two formulas will return the number of cells that contain text in the range defined by the Name table:

=COUNTA(Table)-COUNT(Table)