All are matched-

(a) Ctrl + Shift + C    (vi) For pasting

(b) Ctrl + Z                 (iv) Undo

(c) Ctrl + L                 (ii) The alignment of the text

(d) Ctrl + H                (i) To replace

1. Which of the following formulas is a feature in Microsoft Excel that is used to perform calculations on data in a spreadsheet?

2. A formula is a special type of formula used to add, subtract, multiply, and divide numbers, text, and other data.

3. LANPAR, the first electronic spreadsheet on mainframe and time-sharing computers, was developed in the year 1969.

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.

1. Animation like effect when you use MS. Transition from one slide to another during a slide show in PowerPoint 2010.

2. First of all, select the slides in which the transition effect is to be added.

3. Click on the Slide Transition option in the Slide Show menu available in the menu bar, which opens the Slide Transition dialogue box.

5. The desired speed of the transition effect is set using the Slow, Medium or Fast option button.

1. The shortcut key to start the slide show from the beginning in MS PowerPoint is F5. Pressing this key will start the presentation and slide show starting from the first slide.

2. If you want to start the slideshow from the current slide, you can use the Shift+F5 key combination. Pressing this key will start the presentation and start the slide show from the current slide.

1. Using Ctrl + F opens the option of ‘Find and Replace’.

2. In Word, the shortcut key Ctrl + F is used to open the Find box.

3. Ctrl + F is used to find a document.

1. Icons are small pictures that represent a program, folder, or program function and are displayed in the user's user interface when they are double-clicked.

1. In MS Excel 2010, the address of the topmost cell is Al.

2. Microsoft Excel is a commercial spreadsheet application written and distributed by Microsoft for Microsoft Windows and Mac OS X.

3. Microsoft Excel is a spreadsheet tool capable of performing calculations, analyzing data, and integrating information from different programs.