Changing paper size for a complete workbook:

If you need to change the size of paper on which your worksheets will be printed, it can be bothersome to make the change on each worksheet individually. Here's how to make the change on the entire workbook, at one time, regardless of how many worksheets it contains.
1. Right-click any worksheet tab. You'll see a Context menu appear.
2. Choose Select All Sheets. All the worksheet tabs should now be selected.
3. Display the Page Setup dialog box. (In Excel 2007 display the Page Layout tab of the ribbon and click the small icon at the bottom-right of the Page Setup group. In earlier versions of Excel choose File | Page Setup.)
4. Make sure the Page tab is displayed.
5. Using the Paper Size drop-down list, choose A4.
6. Click OK.
7. Right-click any worksheet tab. You'll again see a Context menu.
8. Choose Ungroup Sheets.

Recording a narration in Power point:

You can record a narration into a PowerPoint slide easily. To do this:
• Go to the Slide you wish to add a narration to.
• From the Insert menu select Movies and Sounds.
• Click Record Sounds.
• When ready, click the Record button (the red circle).
• When finished recording, click the black Stop button.
• Click OK.

Types of Software Testing Techniques:

Broadly, software testing techniques can be broken into two types:
1. Functionality testing
2. Non-functionality testing
Functionality testing
This means testing the behaviour of the application to see if it is doing what it is expected to do. If one person was to use a Windows calculator application, he should expect to see that addition, subtraction, multiple and division work accurately.
Example: If he enters 2, presses + button, enters 2, presses = button, the result displayed should be 4.
Which means the programming logic of the application should follow the actual requirement. This is functionality testing.
Non-functionality testing
Non-functionality testing is not really about programming logic. It's about how the same application would behave when run under different circumstances.
Example: If the above Windows calendar application works perfectly well for a single user on a machine with 512KB RAM and 20GB hard disk, assuming that 500 users are going to login to that machine and use that application at the same time, what would happen to it?
It is possible that the application might crash. If that happens, either the resource of the machine needs to be improved, like increase RAM or increase CPU, etc or the application code has to be improved to handle 500 users.
So, unless we run such a test, we will be at risk of the application crashing in production on a customer site when it comes under heavy load.
It is thus important, during requirements gathering, that not only functional requirements are detailed but also non-functional requirements.
An example of non-functional requirement can be '500 users must be able to use the Windows calculator at the same time'. It cannot be something like 'Many users should be able to use the Windows calculator at the same time'. There should not be any place for ambiguity.
It is the responsibility of the tester to get clarity on these requirements.

Weighted Voting:

Weighted Voting is a way to prioritize a list of issues, ideas or attributes by assigning points to each item based on its relative importance.

Tie and High:

Tie and High are the width and height of freight on pallets and warehouse storage racks. "Tie" refers to the number of dimensions of each tier (layer) of standard pack product while "High" means the total physical height of one or more "Ties" making up the unit load.

Sum Top 5 numbers in the List:

Use the Excel SUM function and LARGE functions together, to add the largest numbers in the list.
If a few numbers are to be summed, e.g. top 3, you can type the numbers into the formula. For example:
=SUM(LARGE(A1:A7,{1,2,3}))
The result is 70+60+50 = 180
Note: The second 50 is not included in the result, even though it is tied for 3rd place.
If many top numbers are to be summed you can include the INDIRECT function in the formula with the Excel SUM function. In the INDIRECT function, use row numbers that represent the numbers you want to include. In this example, rows 1:10 are used, so the top 10 numbers in the referenced range will be summed.
1. Type the formula:
=SUM(LARGE(A1:A50,ROW(INDIRECT("1:10"))))
2. This is an array formula, and must be array-entered. To do this, hold the Ctrl and Shift keys, and press Enter
If a variable number of top numbers are to be summed you can include the INDIRECT function in the formula with the Excel SUM function, as shown above, and refer to a cell that holds the variable..
1. In cell C1, type the number of top cells, e.g. 10
2. Type the formula:
=SUM(LARGE(A1:A7,ROW(INDIRECT("1:"&C1))))
3. This is an array formula, and must be array-entered. To do this, hold the Ctrl and Shift keys, and press Enter

Managing more address books:

Address Book. Contacts. Personal Directory. Little Black Book. There are many names for it, but no matter what you call it, essentially this is the place where you store the names, phone numbers, and email addresses of your friends, family, and coworkers.

In Lotus Notes, your personal address book is the database names.nsf.

We can create new address books in Lotus notes.
Here is how you do it:

1. From the Notes menus choose File - Database - New. (or press CTRL+N)
2. In the dialog box, leave Local as the Server, and enter a Title and File Name. These can be whatever you would like. "Friends and Family", "Secondary Address Book", etc. The most important thing is that you choose "Personal Address Book" as the template, as shown by the arrow in the screen shot below.




3. Press OK, and Notes will create the new database for you.

Now we want to transfer contacts from your original Address Book, into the new one you just created. As with any change, you many want to make a backup before doing this, just to make sure you don't loose any data!


4. Open your original address book, names.nsf. Select the contacts you want to move. From the Notes menus choose Edit - Cut. (or press CTRL+X)


5. Open the new address book that you created in step #2. From the Notes menus choose Edit - Paste. (or press CTRL+V)

Now you have a nice and "clean" primary address book, and an archive that you can look up any of the old names if/when you need them.