There is a table in MS Excel which contains numbers from 0 to 10. If you have to add numbers greater than 5 in that table, then the formula =SUMIF (A2:A8,”>0″) is suitable.

You can restore the following if your computer crashes.

1. Restoring the Windows Registry

2. Restoring installed applications

1. Mail Merge is a facility in MS Word using multiple or different letters, invitation cards, and personal letters that can be sent to many people in a minimum time.

2. This feature is more useful in a situation when a user has to deliver a letter or invitation card to thousands of people.

3. We can understand mail merge with an example. Suppose we have to send a letter or card to 1000 different people with their names and addresses, in that case, we will have to copy and paste that letter 1000 times for all those people, and then a lot of time will be wasted. A database will be created which will contain the names, addresses and other information of all the recipients. This database file is in MS Excel or MS Access.

1. A presentation design template is used to ensure a uniform display of all the slides present in the presentation.

2. A presentation design template is a ready-made theme that includes text, images, shapes, and colours. Using templates, you can create a uniform look and feel for all slides.

To save MS-Office documents in PDF file format, you can follow the following steps-

1. Open your MS-Office document.

2. Click on the File tab.

3. Click on Save As.

4. Select PDF from the Save As Type drop-down list.

4. In the File Name box, enter a name for your document.

5. Click on Save.

1. PowerPoint allows users to zoom in and zoom out from slides to help focus on specific sections.

2. It allows the entire slide to be viewed as a whole.

3. The maximum zoom supported by PowerPoint is 400%.

4. The minimum zoom supported by PowerPoint is 10%.

1. If a company wants to include its company name and logo at the bottom of each page of the brochure, the footer is to be used.

2. Inserting a header or footer in MS Word is a simple process that can be completed in just a few steps.

- Open the document in MS Word in which you want to insert a header or footer.

- Click on the “Insert” tab at the top of the MS Word window which is to the right of the Home tab. You can also open the insert tab by pressing the MS Word shortcut key “Alt+N”.

- In the “Header & Footer” group, click the “header” or “footer” button, depending on what you want to insert into your document.

- A menu will appear with various header and footer options. Select the desired option and then click “OK”.

- Header or Footer will now be inserted into your document. You can type directly into it or add images and other content as desired. When you're finished, click outside the header or footer area to return to the document.

Ctrl+x is used to cut the text and Ctrl+c is used to copy the text.