Online Examination

Question# 1. in ms excel,-------is an intersection of row and column.

shell

formula

cell

function

Question# 2. The four types of Mail Merge main documents are–

Form letters, Directory, catalogs and Envelopes

Form letters, Envelopes and Mailing labels, Directories, and lists

Basic letters, envelopes, labels and lists

Form letters, Envelopes, Labels and Directory

Question# 3. What is the shortcut key for slideshow in MS-Power point?

F5

F1

F12

F8

Question# 4. _________ enables us to send the same letter to different persons in MS-Word.

Mail join

Mail paste

Mail insert

Mail merge

Question# 5. Which of the following section doese not exist in a slide layout?

Titles

Lists

Charts

Animations

Question# 6. Which of the following files can be created using word processor?

Work sheet

Data base

Document

Presentation

Question# 7. In MS-Excel charts, actual value of the data point is called _________ .

Legend

Gridlines

Data labels

Data series

Question# 8. Getting data from a cell located in a different sheet is called ________.

Accessing

Referencing

Updating

Functioning

Question# 9. Which of the following is NOT true regarding conditional formatting in MS–Excel 2010?

We can add more than one condition to check

We can set condition to look for bold and apply Italics on them.

We can apply Font, Border and pattern formats that meets the specified onditions.

We can delete any condition from conditional formatting dialog box if it is not require

Question# 10. in which tab header and footer option is available in ms-word 2010?

view tab

page layout tab

print layout tab

insert tab

Question# 11. the following option joins the selected cell into larger cell and centers the contents in the new cell in ms-excel 2010:

Wrap Cell

Rename

Merge & Center

Alignment

Question# 12. what is motion path in ms power point?

a type of animation entrance effect

a method of advancing slides

a method of moving items on a slide

all of the above

Question# 13. Which type of personal email account is typically used to download emails to your computer?

Microsoft Exchange

POP3

IMAP

HTTP

Question# 14. filtering of selected cells in ms excel is done by:

ctrl+shift+f

ctrl+ship+c

ctrl+shift+p

ctrl+shift+l

Question# 15. if you want to display only those rows which contain data of students who have scored more than 70 marks in a subjects in ms-excel 20 Then you can use

Filtering

Freezing pane

Mail Merge

Legend

Question# 16. Shortcut key to start a slide show from current slide:

Shift+F5

Ctrl+F5

Ctrl+Shift+F5

Ctrl+Shift+Delete

Question# 17. You can create appointment, arrange meetings & mange your time using __ view in Outlook-2010

Mail

Design

Backup

Calendar

Question# 18. We are having marks of English, Maths and Science in B2’B3 and B4 cells respectively. The maximum marks of each subject are 100. Then the correct formula for calculating percentage in MS– Excel is/are:

= SUM(B2:B4)/300*100

= (B2+B3+B4)/100*300

= SUM(B2:B4)*100/300

Option (A) and Option (C) both arecorrect

Question# 19. one can view a powerpoint presentation in:

pure black and white

grayscale

color

all of the above

Question# 20. which command is used for copy formatting in ms-word 2010-

ctrl+shift+v

ctrl+shift+c

ctrl+c

ctrl+alt+v

Question# 21. To copy formatting from one area in a work sheet and apply it to another area you would use:

The Edit>copy format and edit>paste format commands

The copy and apply formatting dialog box, located under the format >copy

There is no way to copy and apply formatting in excel

The format painter button on the home Tab

Question# 22. the shortcut key for save as in microsoft word 2010 is-

f11

f12

f10

f 9

Question# 23. Which of the following MS-Excel 2010 tools works backward from an objective to compute an unknown value?

Goal seek

Custom filter function

Pivot table

Boolean operator

Question# 24. what is the use of applying header and footer to a document?

it is used to link to a webpage or outside documents.

it is used to incorporate text into a document that is repeated on each page like company name and page number.

it is used to change the theme and page background of the document.

it is used to identify a location or a selection of text that you name and identify for future reference.

Question# 25. what happens if you edit an image inserted on Power point?

The source file that was inserted is not changed

The source file that was inserted is changed

The source file is changed when you save the presentation

None of the above

Question# 26. Which of the following software is often used as an email application and also includes a calendar, task manager etc.?

MS-Word

MS-Excel

MS-Access

MS-Outlook

Question# 27. Calibri is a:

Font size

Font style

Font alignment

None of the above

Question# 28. in ms word, ctrl+return is used for:

copy-paste

cut-paste

page break

page delete

Question# 29. The option in control panel by which we can manage the energy consumption of the device is:

Internet option

Energy option

Electricity option

Power option

Question# 30. Which of the following is not the example of Image Editor?

Microsoft paint

Adobe Photoshop

GIMP

Octave

alt+c

ctrl+c

alt+ctrl+c

ctrl+shift+c

Question# 32. which of the following is used to include page number or document related information?

footnote

header/footer

bookmark

caption

Question# 33. The key F12 opens a _____ in MS Word

‘Save As‘ dialog box

open dialog box

Save dialog box

Close dialog box]

Question# 34. _________ function will return the remainder after a number divided by a divisor in MS-Excel 2010.

ROUND ()

FACT ()

MOD ()

DIV ()

Question# 35. One can view a power point presentation in:

Color

Grayscale

Pure black and white

All of the above

MULTITECH

RSCIT

Question Paper

RSCIT