Online Examination

Question# 1. suppose you are working on worksheet named ‘sheet1’ and you want sum the values of a1 to a10 cells present in worksheet named “sheet3” then the correct formula in ms-excel 2010 is

=sum(sheet3!a1:a10)

=sum(a1:a10)

=sheet3$a1t:a10

=sumsheet3(a1:a10)

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

Color

Grayscale

Pure black and white

All of the above

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

ms word

ms excel

ms power point

ms outlook

Question# 4. Which tool is used to graphically represent the data in MS Excel 2010?

Pivot table

Cell address

Charts

Algorithm

Question# 5. from which tab you can insert picture, text box and chart etc. in ms-powerpoint 2010?

file

edit

insert

view

Question# 6. If you want to make graphical diagram like graphical list, process diagram, Venn diagrams, organization charts etc. in MS-Word 2010, then you can make easily using?

Smart Art graphics.

Header and Footer.

Cross Reference.

Microsoft Draw.

Question# 7. How to create a uniform appearance by adding a background image to all slides?

Create a template

Edit the slide master

Use the auto correct wizard

All of the above

Question# 8. which file format can be added to a power point show in ms powerpoint 2010?

.jpg

.gif

.wav

all of the above

Question# 9. What is the shortcut key to insert a new slide in a presentation?

Ctrl + M

Ctrl + D

Ctrl + J

Ctrl +N

Question# 10. What lets you to create new presentation by selecting ready–made font color and graphics effects?

Presentation Template

Master slide

Design Template

Animation Scheme

Question# 11. What is the main use of MS-Outlook 2010?

it is used as drawing application.

it is used as calculating application.

it is used as email application.

it is used as web browsing application.

Question# 12. In MS Excel “ABS” function is used to :

Absolute value of a number

Abstract value of a number

Added value of a number

ABS is not a function

Question# 13. Flow charts are planning tools, generally used to represent:

An algorithm

A step by step process

Any logic

All of the above

Question# 14. 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# 15. The intersection of a row and column is called ______.

Data

A field

Cell

An Equation

Question# 16. A files name extension for MS-Word 2007 file is ___________.

.gif

.txt

.docx

.exe

Question# 17. which type of software typically supports the computer to manage its internal resources ?

Application software

System software

Word processor

Presentation application

Question# 18. portrait and landscape are:

page orientation

paper size

page layout

all of above

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

Microsoft paint

Microsoft Outlook

Microsoft overlook

Microsoft Access

Question# 20. 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# 21. _________ refers to moving away paragraph from left, right, or both margins.

Line spacing

Alignment

Indenting

Bulleted and Numbered list

Question# 22. 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# 23. why bookmark is used in ms-word 2010?

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

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

to insert text behind the content of the page.

none of the above

Question# 24. -------symbol is used to start a formula in ms excel 2010.

@

#

$

none of the above

Question# 25. In MS-Word, when you indent a paragraph you ___________.

Push the text in with respect to the outline.

Push the text in with respect to the trim.

Push the text in with respect to the margin.

Push the text in with respect to the blee

Question# 26. 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# 27. Which menu tab allows you to change the font style in MS-Word 2010?

Home Tab

Font Tab

Format Tab

Review Tab

Question# 28. 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# 29. Special effect used to introduce slides in a presentation are called-

Effects

Custom animations

Transitions

Present animations

Question# 30. The power point view that display only text (title and bullets) is.

Slide show

Outline view

Summary view

Slide sorted view

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

Work sheet

Data base

Document

Presentation

Question# 32. extensions of excel 2003, excel 2007 and excel 2010 file are-

xlsx, xls and xlsx

docx, doc and docx

xls, xlsx and xlsx

xls, xls and xlsx

Question# 33. ------is a way for microsoft word to keep monitors the changes you make to a document

track monitor

track changes

trace monitor

none of the above

Question# 34. Which features of MS-Word 2010 is used for monitoring all document changes?

Edit Documents

Monitor Changes

Track Changes

Let‘s play

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

ctrl+shift+f

ctrl+ship+c

ctrl+shift+p

ctrl+shift+l

MULTITECH

RSCIT

Question Paper

RSCIT