Online Examination

Question# 1. The keyboard shortcut for Undo operation is:

Ctrl+U

Shift+Z

Alt+U

Ctrl+Z

Question# 2. Tiny charts embedded in a cell that give a visual trend summary alongside your data are :

Embedded charts

Sparklines

Chart styles

Borderline

Question# 3. 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# 4. Which of the following functionality is not available with page Layout group option in MS–Word 2010?

Switch the page between portrait and landscape layout using orientation option.

Move in the left/Right side of the paragraph by certain amount using Indent option.

Insert the table using table option .

Insert the ghosted text behind the content of the page.

Question# 5. To enter a new paragraph into a document, press the ________ key.

CTRL

ALT

ESC

ENTER

Question# 6. Which of the following is also known as personal information manager?

Microsoft paint

Microsoft Outlook

Microsoft overlook

Microsoft Access

Question# 7. One can insert ______ to a power point presentation:

Hyperlinks

Smart Art

Clip Art

All of the above

Question# 8. Which of the following is the valid formula in MS-Excel :

=POWER(2^3)

=POWER(2,3)

=POWER(2#3)

=POWER(2*3)

Question# 9. How can you close a presentation? select the most appropriate option from the following :

Click on file tab and then click on close option .

Click on the close button that appears at the top right of the powerpoint window.

Use the keyboard shortcut key ctrl + W.

All the options are correct.

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

shell

formula

cell

function

Question# 11. if you want to show the black blank slide during the slideshow then you can press:

B Key

W Kay

Ctrl+B

None Of The Above

Question# 12. clip art option exists in .........menu/tab in microsoft power point 2010-

design

animations

insert

view

Question# 13. in ms word .........is used to create a form letter which you intend to print or e-mail multitple times ,sending each copy to a different recipient:

mail merge

e-mail

print-out

word art

Question# 14. ——— is the MS Excel 2010 tool that works backward from an objective to compute an unknown value.

Boolean operator

Mail Merge

Goal Seek

Bookmark

Question# 15. The word wrap features:

Automatically move text to the next line when necessary

Appears at the bottom of the document

Allows you to type over text

Is the short horizontal line indicating the end of the document

Question# 16. -------is popularly used for email purposes.

ms word

ms excel

ms power point

ms outlook

Question# 17. What is Landscape in MS-Word?

A font style

Paper size

Page layout

Page Orientation

Question# 18. in a powerpoint presentation:

sound clips can be inserted but not movie clips

movie clips can be inserted but not sound clips

both cannot be inserted

both can be inserted

Question# 19. What is the shortcut key for creating a duplicate slide .

Ctrl+L

Ctrl+C

Ctrl+N

Ctrl+M

Question# 20. Choose the most appropriate option from the following:

Workbook is consists of multiple worksheets and charts.

Worksheet is consists of multiple workbooks and charts.

Workbooks consists of multiple slides and charts.

Worksheet is consist of various network topology

Question# 21. arial is a:

font size

font style

font alignment

none of the above

Question# 22. ______ are animation like effects that occur when you move from one slide to another during slideshow

slide backgrounds

slide patterns

Slide transitions

slide breaks

Question# 23. which of the following is not a ms-powerpoint slide translation effect?

wipe right

dissolve

wedge

fly in

Question# 24. when an excel file is received from email or downloaded from internet then it will automatically open in -------to overcome potential vulnerability in ms-excel 2010.

protected view

antivirus view

recover view

public view (A)

Question# 25. .............is pressed to revert the effect of undo

f4

ctrl+y

both (A) and (B)

none of the above

Question# 26. select the most appropriate correct option regarding bar chart and column chart from the following in ms-excel 2010:

both bar chart and column chart can only represent positive data values.

both bar chart and column chart can only represent positive data values in a circular shape.

the data values are represented in horizontal bars in the bar chart whereas the data values are represented in vertical bars in column chart.

all options are correct.

Question# 27. What is the expected result of the following formula in MS-Excel?

=if (2<3,if(4<3,1+1,2+2),3+3)

4

3

None of the above .

Question# 28. 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# 29. which of the following enables us to send the same letter to different persons in ms-word?

mail join

mail copy

mail insert

mail merge

Question# 30. What is the use of shift +F3 shortcut key in MS-Excel 2010?

To insert an image

To open a new sheet

To save the existing sheet

To insert a function

Question# 31. To insert a function in MS-Excel using shortcut keys we press:

Shift + F3

Shift + F4

Shift + F5

Shift + 6

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

Accessing

Referencing

Updating

Functioning

Question# 33. To start slideshow of a presentation:

Press F5 key.

from slideshow menu choose view show option.

from slideshow menu choose rehearse timing.

Either option (A) or option (B).

Question# 34. ____________ is used to insert decorative text in MS-Power point 20

Word clip

Word art

Clip art

Deco text

Question# 35. a character that is raised and is smaller, above the baseline is known as-

capscript

raised

outlined

superscript

MULTITECH

RSCIT

Question Paper

RSCIT